xlswrite will no longer work on my computer

7 次查看（过去 30 天）
Connor
Connor 2014-8-7
评论： 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
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
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
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 个评论
显示 10更早的评论
Image Analyst
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
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
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 个评论
显示 5更早的评论
Geoff Hayes
Geoff Hayes 2014-8-8
I have the Mac version which does not include xlwrite (only xlswrite).

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by