How to get readcell to read leading empty columns and rows in spreadsheet
41 views (last 30 days)
Show older comments
Say I have an Excel file with some entries, offset so that they start at B2 instead of A1 (see image below):
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1214263/image.png)
So column A is completely empty, and row 1 is completely empty.
Can I use readcell() so that it includes the empty leading columns and rows? I want to do this without specifying a full range (i.e., 'A1:J50') because I don't know how large my data is. I want MATLAB to find that out for me. If I do readcell(file,'Range','A1'), then it omits the leading row because it's empty, which is the issue I'm facing.
0 Comments
Accepted Answer
More Answers (1)
Arif Hoq
on 30 Nov 2022
please refer to this answer:
https://www.mathworks.com/matlabcentral/answers/90811-how-to-import-excel-file-including-empty-cells
You don't need to specify the range. readtable, readcell, readmatrix functions can export all your data from excel.
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!