How to get xlsread, xlswrite, actxserver to find, read and write to/from Excel 2010?
2 views (last 30 days)
Matlab newbie. Lots of questions around about why Matlab no longer talks to Excel 2010 - but no satisfactory answers as to how to fix it. These are the errors, refer to the screenshot below
- xlswrite: 'Warning: Could not start Excel server for export.'
- xlsread: 'Warning: Could not start Excel server for import, 'basic' mode will be used.'
- actxserver: 'Server creation failed. Invalid ProgID 'Excel.Application'.'
- If I type 'actxcontrollist' I do not see any references to Excel or Spreadsheet.
OCTAVE on the other hand is able to read and write to Excel 2010 with no problems using its xlsread and xlswrite commands, so it would seem that something within Matlab is not doing its job. What do I have to do to setup Matlab so that it will talk to Excel?
This is a major issue as in my case it negates the reason for which it was purchased. Any help solving it would be highly appreciated.
Setup: Win7 (64bit), Matlab2014b (64 bit), Office Home 2010 Italian (32 bit)