xlswrite will no longer work on my computer
조회 수: 3 (최근 30일)
이전 댓글 표시
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 ..?
채택된 답변
Image Analyst
2014년 8월 7일
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
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일
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.
추가 답변 (1개)
azizullah khan
2014년 8월 7일
Use xlwrite Follow these steps: 1. Copy xlwrite code and save it in your current directory. 2. Then download poi-library files and save in the current library. 3. Now you can use xlwrite without any problem.........
댓글 수: 7
Image Analyst
2014년 8월 8일
Not sure why azizullah didn't think to provide the link. I did a search of the File Exchange and found two with that name: http://www.mathworks.com/matlabcentral/fileexchange/index?utf8=%E2%9C%93&term=xlwrite
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!