Is there any other matlab function equivalent to xlswrite that work on macbook ?

Hi everybody, Is there any other matlab function equivalent to xlswrite that work on macbook ? I heard about the "xlwrite" function, i did download the java thing but I don't know how to use it.

I get this error : Warning: Could not start Excel server for export. XLSWRITE will attempt to write file in CSV format

Thank you,

Meryem

Answer 1

[Pariterre]

Hi Meryem,

As you tried, https://www.mathworks.com/matlabcentral/fileexchange/38591-xlwrite--generate-xls-x--files-without-excel-on-mac-linux-win, did work for me on Linux, but I never tried on Mac.

The error you reported (The POI library is not loaded in Matlab.) may just be due to the fact that you did not include the Apache POI function in you path (addpath('path_to_poi_functions')) which are provided with the function!

[Meryem Rhouzlane]

Thank you for your quick reply. The thing is i'm not familiar with java so i just copy paste the code files in a file. Is there any other step to load the POI library ? thanks.

[Pariterre]

there should be.. as soon as you use the command

addpath('path_to_poi_files')

matlab should be able to load them. Could you provide us with a minimalistic version of the code you use?

Answer 2

[Walter Roberson]

We recommend using writetable(), which can work with csv, xls, and xlsx files. You might need to use array2table() to convert your data to table object.