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

Question

azizullah khan 2014-7-31

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/144269-export-save-data-into-excel-in-matlab-2014a

评论： Geoff Hayes 2014-8-1

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 个评论
显示 6更早的评论隐藏 6更早的评论

Geoff Hayes 2014-7-31

在 MATLAB Online 中打开

Try the following: in the Command Window type

open xlswrite

This will open the xlswrite.m file in the MATLAB Editor. Put a breakpoint at line 83 (which should be the first line of code). Now back in the Command Window, type

xlswrite('someting.xls',data)

Once you execute this command, the debugger will be enabled within the Editor and the execution should be paused at the line of your breakpoint. Now just step through each line, pressing the Step button (to right of Continue button) until you get to the line 171 which is

Excel = actxserver('Excel.Application');

(Alternatively, just put a breakpoint here.) If this fails, for whatever reason, the subsequent catch block

 catch exception %#ok<NASGU>
    warning(message('MATLAB:xlswrite:NoCOMServer'));

prints out the warning message that you have observed. What would be interesting though is nature of the exception. While still debugging the code, and presumably you are now within the catch block with the warning message been printed out, in the Command Window type

exception

which is the MException object input to the catch block. When I type this value and press enter, I see

 exception = 
  MException with properties:
    identifier: 'MATLAB:UndefinedFunction'
       message: 'Undefined function 'actxserver' for input arguments of type 'char'.'
         cause: {}
         stack: [1x1 struct]

What do you see when you do the same?

azizullah khan 2014-8-1

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 2014-8-1

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?

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Image Analyst 2014-8-1

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/144269-export-save-data-into-excel-in-matlab-2014a#answer_147059

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 个评论
显示无隐藏无

azizullah khan 2014-8-1

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 .