Reading multiple number of an EXCEL file without knowing number of rows and columns

2014 4 2
1 个回答
回答已采纳
更新时间：2014 4 4
1 次查看（30 天）

0 个投票

Hello, in the code below i have to specify the range for columns but i have 100 set of excel files in that with different column length so how to specify in that case
[~, ~, raw]= xlsread(fullFileName,'Results','B3:1000');

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

 采纳的回答

Jeff Johnson
Jeff Johnson 2014-4-2

0 个投票

Assuming the data you are interested in is always in column B:
[~,~,raw]=xlsread(fullFileName,'Results','B:B'); % reads all rows in Column B
raw(any(cellfun(@(x) any(isnan(x)),raw),2),:) = []; % removes all NaN entries
This code will leave you with a cell array with the raw data for all non-empty cells in column B. As written it will read all of the rows (65,536 of them!) in each file. If you know the maximum number of non-empty rows in all files (say 1500), you could speed this up by replacing 'B:B' with 'B1:B1500'.
This thread contains more information about deleting rows with NaN entires.

3 个评论
显示 1更早的评论 隐藏 1更早的评论

Yogesh Babu
Yogesh Babu 2014-4-3
编辑：Yogesh Babu 2014-4-3
Hello ,
After this I would like to plot them but that is not working in plotting them.Have a look and tel me the solution for this problem
[~,~,raw]=xlsread(fullFileName,'Results','B:B'); % reads all rows in Column B raw(any(cellfun(@(x) any(isnan(x)),raw),2),:) = []; % removes all NaN entries Blob = data(:,1); Area = data(:,2); clearvars data raw; h=bar(Area);figure(gcf);
Jeff Johnson
Jeff Johnson 2014-4-4
Hi Yogesh,
What is the data variable you are referencing? Can you also include the error message returned when you try to plot these data?

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by