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

3 views (last 30 days)
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
azizullah khan
azizullah khan on 1 Aug 2014
thanks for replying ,sir i want to use xlswrite for mac operating system... i find that xlwirte is useful but the problem is with poi library files that how i can find and insert the jars files.if you have any idea kindly share it with me.....please.
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
azizullah khan
azizullah khan on 1 Aug 2014
thanks for replying ,sir i want to use xlswrite for mac operating system... i find that xlwirte is useful but the problem is with poi library files that how i can find and insert the jars files.if you have any idea kindly share it with me.....please. sir if you know any other command or code for xlswirte in mac share it with me .
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!