MATLAB Answers

Lawrence Johny

Error in exporting values using xlswrite

Asked by Lawrence Johny
on 19 Sep 2013

While exporting using xlswrite, MATLAB gives the error as follows:

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

This is not a concern since Excel can handle CSV files. But when I checked the exported values, I note that the matrix has been exported into CSV in a scrambled format. Values exported do not correspond to the actual matrix obtained in MATLAB.

I tried exporting with csvwrite as well.

Any help is appreciated.

Thanks in advance.

  0 Comments

Products

3 Answers

Answer by Chocolate Warrior on 19 Sep 2013

Do you have MS Excel installed? look at this link please.. http://www.mathworks.in/matlabcentral/answers/21477

  1 Comment

Lawrence Johny
on 19 Sep 2013

I have MS Excel installed. It is on a mac environment, which is why i used csvwrite. Nevertheless, the matrix exported has data offset. I am exporting asset paths of Monte Carlo simulations. Data from one asset path is being written in another asset path in Excel.

The matrix contains only numbers.


Answer by Lawrence Johny
on 19 Sep 2013

Its ok. When i export a smaller matrix there is no issue. Thanx.

  0 Comments


Answer by Arthur
on 19 Sep 2013

As far as I know, Matlab can (still) not access Excel on a mac. xlswrite only works on a pc.

A shame, if you ask me.

You could try this: http://www.mathworks.com/matlabcentral/fileexchange/37560-xlwrite-export-data-to-excel-from-matlab-on-macwin

  0 Comments


Discover what MATLAB® can do for your career.

Opportunities for recent engineering grads.

Apply today