Discover MakerZone

MATLAB and Simulink resources for Arduino, LEGO, and Raspberry Pi

Learn more

Discover what MATLAB® can do for your career.

Opportunities for recent engineering grads.

Apply Today

Error in exporting values using xlswrite

Asked by Chris 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

Chris

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

Chris 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.

Chocolate Warrior
Answer by Chris on 19 Sep 2013

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

0 Comments

Chris
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

Arthur

Contact us