xlwrite problem - Undefined function or variable 'XSSFWorkbook'
Mostra commenti meno recenti
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 Commenti
Brendan Hamm
il 15 Lug 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
il 7 Ago 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
il 7 Ago 2015
xlswrite() does work on OS-X, provided you restrict yourself to "basic" mode.
Osman Ciftci
il 30 Gen 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
Risposte (0)
Categorie
Scopri di più su Spreadsheets in Centro assistenza e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!