您正在关注此问题

您将在关注的内容源中看到更新。
您可能会收到电子邮件，具体取决于您的通信预设项。

Hello, so i have 4 XLS files that contain data and every files has the same information but at different locations within that specific file. I want to extract all needed data

1 次查看（过去 30 天）

显示更早的评论

Ahisa 2021-6-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/865560-hello-so-i-have-4-xls-files-that-contain-data-and-every-files-has-the-same-information-but-at-diffe

⋮

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/865560-hello-so-i-have-4-xls-files-that-contain-data-and-every-files-has-the-same-information-but-at-diffe

编辑： Ahisa 2021-6-28

so all the files start like this: "HAYT" and at the end of HAYT, it contains one number(1-4) so the filenames range from HAYT1-HAYT4. I want all the files to be in one specfic folder where the code would sort through all four files and extract the data needed. how would i go about this? I am currently trying to code it but I am stuggling a bit.

12 个评论
显示 10更早的评论隐藏 10更早的评论

Scott MacKenzie 2021-6-25

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/865560-hello-so-i-have-4-xls-files-that-contain-data-and-every-files-has-the-same-information-but-at-diffe#comment_1605355

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/865560-hello-so-i-have-4-xls-files-that-contain-data-and-every-files-has-the-same-information-but-at-diffe#comment_1605355

Do you know the range of the data in each file? Do you want to read the data into separate matrices/tables or concatenate into a single matrix/table?

Ahisa 2021-6-25

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/865560-hello-so-i-have-4-xls-files-that-contain-data-and-every-files-has-the-same-information-but-at-diffe#comment_1605360

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/865560-hello-so-i-have-4-xls-files-that-contain-data-and-every-files-has-the-same-information-but-at-diffe#comment_1605360

thanks for the comment, each file has about 10 sheets, the first sheet is what is needed. the data are in different rows/columns and i wouldnt know what to do with that. i want each file to have all the data on one row

Scott MacKenzie 2021-6-25

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/865560-hello-so-i-have-4-xls-files-that-contain-data-and-every-files-has-the-same-information-but-at-diffe#comment_1605380

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/865560-hello-so-i-have-4-xls-files-that-contain-data-and-every-files-has-the-same-information-but-at-diffe#comment_1605380

Your reply just raises more questions.

Can you inspect the files and determine the range of the data to read in the usual format; e.g., 'A5:F22'?

What do you mean by i want each file to have all the data on one row? I assumed you want to read the data into a MATLAB matrix or table. But, is your intent to read the data, then write it back out? Please clarify, if you can.

Ahisa 2021-6-25

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/865560-hello-so-i-have-4-xls-files-that-contain-data-and-every-files-has-the-same-information-but-at-diffe#comment_1605395

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/865560-hello-so-i-have-4-xls-files-that-contain-data-and-every-files-has-the-same-information-but-at-diffe#comment_1605395

well, the data that i need are in random areas. i would like it to read into a table within matlab, EX:

HAYT1 2323 2323 54545 454545 676767

HAYT1 545df je4j55 and so on...

Star Strider 2021-6-25

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/865560-hello-so-i-have-4-xls-files-that-contain-data-and-every-files-has-the-same-information-but-at-diffe#comment_1605410

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/865560-hello-so-i-have-4-xls-files-that-contain-data-and-every-files-has-the-same-information-but-at-diffe#comment_1605410

Do the data have anything at all in common (same column or variable names, same row names)?

Think of it this way: If you were replying to your question, what information would you need in order to provide a solution?

Ahisa 2021-6-25

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/865560-hello-so-i-have-4-xls-files-that-contain-data-and-every-files-has-the-same-information-but-at-diffe#comment_1605415

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/865560-hello-so-i-have-4-xls-files-that-contain-data-and-every-files-has-the-same-information-but-at-diffe#comment_1605415

编辑：Ahisa 2021-6-25

completely agree! so every file has the same headers but they are in different locations

dpb 2021-6-26

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/865560-hello-so-i-have-4-xls-files-that-contain-data-and-every-files-has-the-same-information-but-at-diffe#comment_1606110

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/865560-hello-so-i-have-4-xls-files-that-contain-data-and-every-files-has-the-same-information-but-at-diffe#comment_1606110

编辑：dpb 2021-6-26

在 MATLAB Online 中打开

Random tidbits being pulled by repeated questions tersely replied to but with little real information and what is given just randomly pulled out of context will never get to a solution...

Without actually seeing at least a couple of the files sufficiently to be able to know what are looking at and what is wanted/needed to be returned, it's a wild goose chase to provide any useful code.

Other than that, getting the files is easy...

d=dir('HAYT*.xls');
for i=1:numel(d)
  d=read???(d(i).name,...);
  ....
end

Ahisa 2021-6-28

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/865560-hello-so-i-have-4-xls-files-that-contain-data-and-every-files-has-the-same-information-but-at-diffe#comment_1608855

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/865560-hello-so-i-have-4-xls-files-that-contain-data-and-every-files-has-the-same-information-but-at-diffe#comment_1608855

how can i edit this to a specific folder?

dpb 2021-6-28

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/865560-hello-so-i-have-4-xls-files-that-contain-data-and-every-files-has-the-same-information-but-at-diffe#comment_1608945

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/865560-hello-so-i-have-4-xls-files-that-contain-data-and-every-files-has-the-same-information-but-at-diffe#comment_1608945

在 MATLAB Online 中打开

Set the folder path either as a variable defined in your code or let use select it with a call to uigetdir() if you want fancy interface, then use fullfile() to build the fully qualified file search path. Similarly for the access, use fullfile and

d=read???(fullfile(d(i).folder,d(i).name),...);

You've still not given enough information on the file structure itself to be able to know what else about the input itself would need...

Ahisa 2021-6-28

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/865560-hello-so-i-have-4-xls-files-that-contain-data-and-every-files-has-the-same-information-but-at-diffe#comment_1609063

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/865560-hello-so-i-have-4-xls-files-that-contain-data-and-every-files-has-the-same-information-but-at-diffe#comment_1609063

i am unable to share the files, would there be a way to make a layout of the code? as in, most the data are on the first sheet and are at differemt locations, i was thinking of doing 4 loops for the 4 types of files. so, I would create a single loop per file type and have it loop through every file within the folder

dpb 2021-6-28

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/865560-hello-so-i-have-4-xls-files-that-contain-data-and-every-files-has-the-same-information-but-at-diffe#comment_1609348

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/865560-hello-so-i-have-4-xls-files-that-contain-data-and-every-files-has-the-same-information-but-at-diffe#comment_1609348

You can put artificial data (of the same time data types and locations) in a sample file or two that illustrate the format and what data are needed.

It might be that just calling detectImportOptions for each could automagically find where the data are, or you might discover that the internal logic already built into readtable does it without any human intervention.

Have you tried it or just presumed it wouldn't work...?

Ahisa 2021-6-28

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/865560-hello-so-i-have-4-xls-files-that-contain-data-and-every-files-has-the-same-information-but-at-diffe#comment_1609448

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/865560-hello-so-i-have-4-xls-files-that-contain-data-and-every-files-has-the-same-information-but-at-diffe#comment_1609448

编辑：Ahisa 2021-6-28

i can edit the file and may be able to share them, i do believe they are encrypted, so i'm unsure.

I havent tried anything yet, trying to figure it out first before i do.

请先登录，再进行评论。

请先登录，再回答此问题。

回答（0 个）

请先登录，再回答此问题。

另请参阅

类别

MATLAB Programming Files and Folders File Operations

在 Help Center 和 File Exchange 中查找有关 File Operations 的更多信息

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

发生错误

由于页面发生更改，无法完成操作。请重新加载页面以查看其更新后的状态。

Translated by

选择网站

选择网站以获取翻译的可用内容，以及查看当地活动和优惠。根据您的位置，我们建议您选择：。

(English)
(Deutsch)
(Français)

（简体中文）
(English)

您也可以从以下列表中选择网站：

如何获得最佳网站性能

选择中国网站（中文或英文）以获得最佳网站性能。其他 MathWorks 国家/地区网站并未针对您所在位置的访问进行优化。

美洲

América Latina (Español)
Canada (English)
United States (English)

欧洲

Belgium (English)
Denmark (English)
Deutschland (Deutsch)
España (Español)
Finland (English)
France (Français)
Ireland (English)
Italia (Italiano)
Luxembourg (English)

Netherlands (English)
Norway (English)
Österreich (Deutsch)
Portugal (English)
Sweden (English)
Switzerland
United Kingdom(English)

亚太

Australia (English)
India (English)
New Zealand (English)
中国
- 简体中文Chinese
- English
日本Japanese (日本語)
한국Korean (한국어)

联系您当地的办事处

Hello, so i have 4 XLS files that contain data and every files has the same information but at different locations within that specific file. I want to extract all needed data

12 个评论 显示 10更早的评论隐藏 10更早的评论

回答（0 个）

另请参阅

类别

标签

Community Treasure Hunt

12 个评论
显示 10更早的评论隐藏 10更早的评论