Drexel dragonThe Math ForumDonate to the Math Forum

Search All of the Math Forum:

Views expressed in these public forums are not endorsed by Drexel University or The Math Forum.

Math Forum » Discussions » Software » comp.soft-sys.matlab

Topic: Simple but stunning xlswrite problem.
Replies: 1   Last Post: Dec 5, 2012 12:55 PM

Advanced Search

Back to Topic List Back to Topic List Jump to Tree View Jump to Tree View   Messages: [ Previous | Next ]
Steven Lord

Posts: 17,945
Registered: 12/7/04
Re: Simple but stunning xlswrite problem.
Posted: Dec 5, 2012 12:55 PM
  Click to see the message monospaced in plain text Plain Text   Click to reply to this topic Reply

"Paul " <pecmertens@gmail.com> wrote in message
> I get an error when trying to write very basic arrays using xlswrite.
> This works:
> a = cell(5);
> a(1:25) = 1;

This line should have thrown an error assuming you're using the built-in
CELL function.

> xlswrite('test', a)
> THIS does not work:
> a = cell(5)
> a(1:25) = 1;


> a(1,5) ={'a'};
> xlswrite('test',a);
> I get the following error:
> ??? Error using ==> xlswrite at 180
> An error occurred on data export in CSV format.
> Error using ==> <a href="error:C:
> Does anyone have any idea why this could be happening?

What version of MATLAB are you using?

Do you have Microsoft Excel installed on your machine? If so, what version?

Have you tried explicitly specifying that the file you're trying to create
should have the .xls extension?

Steve Lord
To contact Technical Support use the Contact Us link on

Point your RSS reader here for a feed of the latest messages in this topic.

[Privacy Policy] [Terms of Use]

© The Math Forum 1994-2015. All Rights Reserved.