xlwrite problem - Undefined function or variable 'XSSFWorkbook'
Show older comments
Matlab's xlswrite does not work in OSX. Instead, I have tried xlwrite, a Java-based solution to the same need contributed to File Exchange by Marin Deresco. After getting the associated Java "Poi" library onto my Java path, I get "Undefined function or variable 'XSSFWorkbook'. Error in xlwrite (line 148)" when I run the associated Text_xlWrite.
Anyone know how to get xlwrite to work on OSX? An alternative substitute to xlswrite would also be welcome.
OSX 10.10.4, Matlab 8.5.0.197613 (R2015a)
4 Comments
Brendan Hamm
on 15 Jul 2015
You could always use csvwrite as excel will still read this, but this only pertains to numeric data. If you have a cell array then you can use lower level I/O Write To Delimited Files
Marshall
on 7 Aug 2015
The most common reason for this is that the jar files in the poi-library are not in the Matlab path; make sure you have the poi-library added to your path.
I sometimes still receive this error the first time I run xlwrite(), but it disappoints on subsequent calls.
Walter Roberson
on 7 Aug 2015
xlswrite() does work on OS-X, provided you restrict yourself to "basic" mode.
Osman Ciftci
on 30 Jan 2019
@Walter Roberson,
the xlswrite doesn't have the basic mode in some versions, such as 2017b. (Link to the documentation on Mathworks website: https://nl.mathworks.com/help/releases/R2017b/matlab/ref/xlswrite.html?searchHighlight=xlswrite&s_tid=doc_srchtitle )
What would you propose?
Thnx in advance :)
Osman
Answers (0)
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!