xlwrite problem - Undefined function or variable 'XSSFWorkbook'
Afficher commentaires plus anciens
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 commentaires
Brendan Hamm
le 15 Juil 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
le 7 Août 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
le 7 Août 2015
xlswrite() does work on OS-X, provided you restrict yourself to "basic" mode.
Osman Ciftci
le 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
Réponses (0)
Catégories
En savoir plus sur Spreadsheets dans Centre d'aide et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!