Info
This question is closed. Reopen it to edit or answer.
how to read date and time from worksheets in a excel spreadsheet?
1 view (last 30 days)
Show older comments
I have an excel spreadsheet with several worksheets. I would like to import data from each worksheet into matlab as a separate matrix. I think xlsread works best, but I can only do it manually i.e. A = xlsread('testfile.xls',1); B=xlsread('testfile.xls',2) etc. i tried putting it into loop as for(i=1:10); data(:,:,i)=xlsread('testfile.xls',i); using this i get an error" ??? Subscripted assignment dimension mismatch. ".
this may be because all the worksheet is not of same dimensions, how can i proceed with it? thanks in advance...
0 Comments
See Also
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!