The Math Forum



Search All of the Math Forum:

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


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

Topic: writing cell with string and numerical matrix to Excel using xlswrite?
Replies: 2   Last Post: Nov 7, 2017 7:21 PM

Advanced Search

Back to Topic List Back to Topic List Jump to Tree View Jump to Tree View   Messages: [ Previous | Next ]
beginner1.mat@hotmail.com

Posts: 61
Registered: 11/7/07
writing cell with string and numerical matrix to Excel using xlswrite?
Posted: Nov 6, 2017 10:15 PM
  Click to see the message monospaced in plain text Plain Text   Click to reply to this topic Reply

I am trying to write a cell (called FORM) that is a 1x5 cell, that contains string and numerical values. Within the FORM cell it looks like:

'Form Name' 1x10 double 1x10 double 1x10 double 1x10 double

I tried the following:

xlswrite('filename.xls', FORM)%

This did not work...I cannot write the FORM cell to Excel using xlswrite.

I removed the string, 'Form Name' (which leaves me with a 1x4 cell of numerical values), and was able to write the numerical values to Excel using:

xlswrite('filename.xls',FORM)% this works when I remove the first column of string data, leaving the other 4 cells showing as 1x10 double 1x10 double 1x10 double 1x10 double

I have seen there may be ways to use fprintf, but I would rather simply use xlswrite, if possible.

Please help!




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

[Privacy Policy] [Terms of Use]

© The Math Forum at NCTM 1994-2017. All Rights Reserved.