I need to be able to read csv files which:
contain rectangular arrays of values; contain more than 65536 rows; vary in format from file to file (number and content of columns); contain mixed format values (strings AND numbers), and; contain many empty cells.
I then need to be able to distinguish between valid 0's and blanks.
xlsread does the job for less than 65536 rows. csvread does the job for fully populated files. textscan cannot be given a suitable format argument.
I have written some code to do the job, however, it takes excessively long to read the files. - Any ideas?
No products are associated with this question.
Excel help says
In Excel 2010, the maximum worksheet size is 1,048,576 rows by 16,384 columns.
I believe that in Matlab 64bit xlsread is not limitted by "65536 rows". However, I fail to find it in the Matlab documentation.