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

Question

Meryem Rhouzlane 2018-6-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/407654-is-there-any-other-matlab-function-equivalent-to-xlswrite-that-work-on-macbook

回答： Walter Roberson 2018-6-27

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

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Pariterre 2018-6-27

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/407654-is-there-any-other-matlab-function-equivalent-to-xlswrite-that-work-on-macbook#answer_326515

编辑：Walter Roberson 2018-6-27

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!

2 个评论
显示无隐藏无

Meryem Rhouzlane 2018-6-27

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 2018-6-27

在 MATLAB Online 中打开

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 2018-6-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/407654-is-there-any-other-matlab-function-equivalent-to-xlswrite-that-work-on-macbook#answer_326564

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.