xlswrite will no longer work on my computer

4 views (last 30 days)
Connor
Connor on 7 Aug 2014
Commented: Geoff Hayes on 11 Aug 2014
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 Comments
Connor
Connor on 7 Aug 2014
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.

Sign in to comment.

Accepted Answer

Image Analyst
Image Analyst on 7 Aug 2014
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 Comments
Geoff Hayes
Geoff Hayes on 11 Aug 2014
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.

Sign in to comment.

More Answers (1)

azizullah khan
azizullah khan on 7 Aug 2014
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 Comments
Image Analyst
Image Analyst on 8 Aug 2014
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

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!