xlswrite will no longer work on my computer

3 次查看（过去 30 天）

Connor 2014-8-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/146724-xlswrite-will-no-longer-work-on-my-computer

评论： Geoff Hayes 2014-8-11

Warning: Could not start Excel server for export.
XLSWRITE will attempt to write file in CSV format.

For whatever reason, I used to be able to export to a excel file but it will no longer work and I keep getting this error message. Nothing has changed, what do I do??

2 个评论
显示无隐藏无

Geoff Hayes 2014-8-7

Connor, in your previous post can't start excel you mentioned that It used to work now that the computer has been updated i keep getting the same error and I am now using microsoft excel 2010 and matlab R2014a. So what changed in the updated computer - a new version of Excel or ..?

Connor 2014-8-7

To clarify, the matlab version is the same and so is the Excel. That's why I am confused. The only thing updated was the computer itself. I have been using the xlsappend function that is available in the file exchange to export data to the excel sheet.

请先登录，再进行评论。

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

采纳的回答

Image Analyst 2014-8-7

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/146724-xlswrite-will-no-longer-work-on-my-computer#answer_147788

ExcelDemo.m

Well something changed didn't it? It no longer runs.

Does Excel itself run? Did you have a trial version of Excel that expired? Do you have a starter version of Excel, which does not allow ActiveX?

Let's see your code for xlswrite.

Do you want to try it via ActiveX instead? Can you run my attached ActiveX demo?

12 个评论
显示 10更早的评论隐藏 10更早的评论

Connor 2014-8-7

在 MATLAB Online 中打开

Ok I downloaded matlab again and all files are present. The computer runs windows 7 and has matlab R2014 and microsoft excel 2010. Still the actxserver will not open excel when it tries to, I keep getting the following warning, then error message. FYI, I am using xlsappend which contains xlswrite within it.

Warning: Could not start Excel server for export.
XLSWRITE will attempt to write file in CSV format. 
> In xlsappend at 178
  In multiwavelet>perform_wavelet_transform_Callback at 327
  In gui_mainfcn at 95
  In multiwavelet at 46
  In @(hObject,eventdata)multiwavelet('perform_wavelet_transform_Callback',hObject,eventdata,guidata(hObject)) 
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
Error using xlsappend (line 193)
An error occurred on data export in CSV format.
Error in multiwavelet>perform_wavelet_transform_Callback (line 327)
    xlsappend('Exported Data.xlsx',W,'DMEY');
Error in gui_mainfcn (line 95)
        feval(varargin{:});
Error in multiwavelet (line 46)
    gui_mainfcn(gui_State, varargin{:});
Error in
@(hObject,eventdata)multiwavelet('perform_wavelet_transform_Callback',hObject,eventdata,guidata(hObject))
Caused by:
    Error using dlmwrite (line 112)
    The input cell array cannot be converted to a matrix.
Error while evaluating uicontrol Callback

Image Analyst 2014-8-11

What's the full code? Is the second line in the catch? But that still doesn't explain why you got the "'actxserver' not found." message.

Geoff Hayes 2014-8-11

在 MATLAB Online 中打开

Maybe, for MATLAB 2014a on this updated computer (@Connor - what version of Windows was the computer updated to?) with Excel 2010, the line

Excel = actxserver('Excel.Application')

does not work unless

Excel = actxGetRunningServer('Excel.Application');

is called first. Given the results that Connor has outlined - the demo works, and then calling his GUI worked wrt xlswrite, but upon restart his GUI would not work wrt xlswrite unless the demo was called first - seems to suggest that there is "something" that calling actxGetRunningServer does that is "needed" to get actxserver('Excel.Application') to work.

请先登录，再进行评论。