How to convert .xlsx file to .mat larger than 200 mb

Hi, I have a file with 65536 rows and almost 1800 columns that makes my excel file to approx 210 MBs and i want to convert it in .mat file but when i used save command it gave an error of exceeding memory resources,please help me to encounter this problem Thankx

Answer 1

[Raghava S N]

Hello,

The parameter “version” in the MATLAB function “save” can be used to specify the MAT-file version. This effects the maximum size of the variable that can be saved in the MAT file. For more information, refer to this link - https://www.mathworks.com/help/matlab/ref/save.html#btox10b-1-version:~:text=version%20%E2%80%94%20MAT%2Dfile%20version.

I also found this MATLAB Answers post which discusses storing data bigger than 2GB in MAT files - https://www.mathworks.com/matlabcentral/answers/381308-bigger-than-2gb-data-storage. The solution is to save the excel file using the following command:

save('myFile.mat', 'Variablename', '-v7.3')

The “version” parameter here is set to ‘-v7.3’ which enables storage of data that is larger than 2 GB.