Computer Hope

Software => Computer software => Topic started by: a_dabch on October 07, 2016, 10:56:14 AM

Title: Transfer a matlab table to CSV file/ Row Limit??
Post by: a_dabch on October 07, 2016, 10:56:14 AM

I have a MATLAB table of 8 columns and 246 312 ROWS. I tried to transfer the MATLAB table to CSV in order to be able to use it in STATA cause I have a MAC and the xlwrite or any other function to transfer to an excel file from MATLAB sends an error mess. So i am using the matlab function:
writetable(A, 'filename.csv', 'Delimiter',' ,' ,'QuoteStrings', true).
I get a CSV file with all the 8 columns but only a part of the rows, i get 139 521 instead of the 246 312 rows.
WHY???
How can i get all the rows in?
I tried transferring the CSV file to EXCEl to double check if excel was gonna pick it up, but EXCEL too only gets 139 521.
How can i do to correct that?

Thank you for your help.

Title: Re: Transfer a matlab table to CSV file/ Row Limit??
Post by: soybean on October 07, 2016, 12:13:54 PM

Your question seems to pertain mainly to MATLAB, not Excel.  For Excel 2016 and Excel 2013 (https://support.office.com/en-us/article/Excel-specifications-and-limits-ca36e2dc-1f09-4620-b726-67c00b05040f), the maximum Worksheet size is 1,048,576 rows by 16,384 columns. So, it will accommodate a file with 246 312 rows (your file size).  I suggest you seek an answer at http://www.mathworks.com/matlabcentral/?s_tid=gn_mlc