Reading multiple number of an EXCEL file without knowing number of rows and columns
조회 수: 3 (최근 30일)
이전 댓글 표시
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');
댓글 수: 0
채택된 답변
Jeff Johnson
2014년 4월 2일
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
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개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!