How to get consistent import data outputs

2015 6 29
2 个回答
回答已采纳
更新时间：2015 6 29
5 次查看（30 天）

0 个投票

Im my program I am attempting to import multiple xcel files in a for loop. Then storing the results in a struct with dynamically named fields which I can evaluate later. However, when the for loop is done I get what is in the screenshot below the code.
for i=1:sizeOfSel
j = num2str(i);
fieldName = strcat('data_' , j);
stmfile = temp(i,:)
pathname = handles.A.dir;
tic
handles.A.data.(fieldName) = importdata(fullfile(pathname, stmfile));
toc
end
Ideally, I need every field to contain a structure that import data is outputting. But because only one or two of the files being processed actually fit the format, I can only process those files. The image shows the output of two identical xcel files.

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

 采纳的回答

Tim Tobias
Tim Tobias 2015-6-29

0 个投票

They are both xls. I copy/pasted it, so besides an extra '-copy' in the name they should contain the same values.

4 个评论
显示 2更早的评论 隐藏 2更早的评论

Walter Roberson
Walter Roberson 2015-6-29
Is that a copy-paste of the file, or of the contents?
If you rename the copy so that it matches the pattern but would occur earlier in the list than the file that works now, then does the problem stay with the copy or does it stay with the slot, the fact that it is not the first file?
Tim Tobias
Tim Tobias 2015-6-29
copy-paste of the file itself.
So breaking the problem down I've figured out it's because I'm calling specific file names that don't follow a pattern. Right now each iteration through the loop the exact filename/path is handed to import data.
Is there a way to import them individually without importdata/xls reader expecting a pattern?
Walter Roberson
Walter Roberson 2015-6-29
The only thing about pattern that importdata() cares about is that it looks at the file extension to figure out how to handle the file. If your copy ended up without the .xls extension then it would have been treated as ASCII data. There is no provision to override that behaviour to tell it which helper to call. If you need to have it handle filenames with unexpected extension as if they were a particular type, then you should use the appropriate helper function such as xlsread()
Tim Tobias
Tim Tobias 2015-6-29
I'm able to watch the incoming filenames as they are processed and I haven't lost any extensions. If I have files 1.xls 2.xls and 3.xls it will happily process all files. But if I change 3.xls to a3.xls or any change outside of changing 3 to (another single digit number).xls it will no longer be able to process all three files.
Going to have to restructure some things but it looks like xlsread will be the way to go.
Thank you!

请先登录，再进行评论。

更多回答（1 个）

Walter Roberson
Walter Roberson 2015-6-29

1 个投票

Are they really identical, or have some of them been saved in csv (Comma Separated Value) format, and some of them in binary format (.xls)? And possibly some of them are in .xlsx structured text format?
You will probably need to switch to xlsread() instead of importdata()

类别

在 帮助中心 和 File Exchange 中查找有关 Large Files and Big Data 的更多信息

产品

标签

Community Treasure Hunt

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

Start Hunting!

Translated by