MATLAB Answers

Export/save data into excel in matlab 2014a...

4 views (last 30 days)
azizullah khan
azizullah khan on 31 Jul 2014
Commented: Geoff Hayes on 1 Aug 2014
xlswrite('someting.xls',data) make error i.e
Warning: Could not start Excel server for export.
XLSWRITE will attempt to write file in CSV format.
but when i use csvwrite it make an error i.e:
Error using dlmwrite (line 112)
The input cell array cannot be converted to a matrix.
in matlab 2008b this type of error doesn't come: need your help i am tired...
  8 Comments
Geoff Hayes
Geoff Hayes on 1 Aug 2014
I'm confused. In my initial comment, I as asked you whether you were running MATLAB on Windows or something else, and you responded with i am using on my pc. So where are you experiencing this problem - on the PC or on the Mac?
What is a poi library? What do jar files have to do with xlswrite?

Sign in to comment.

Answers (1)

Image Analyst
Image Analyst on 1 Aug 2014
Are you sure you have full blown Excel and not a "starter version" which is installed free on some new computers. The starter version will not respond to ActiveX commands.
I don't think csvwrite takes cell arrays. Certainly not those with mixed numbers and strings. Evidently it thinks you have a cell array and is trying to call cell2mat on it and it's failing, probably because you have mixed class content in your cells.
If you can start Excel via ActiveX, then use xlswrite1() in the File Exchange to write your cell array. http://www.mathworks.com/matlabcentral/fileexchange/10465-xlswrite1
  2 Comments
Image Analyst
Image Analyst on 1 Aug 2014
Sorry, I know nothing about MATLAB on the mac. I don't even know what a poi library file is. I'll put "mac" in the tags for you though. Good luck.

Sign in to comment.

Products

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!