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: write to multiple dataset to excel spreadsheet
Replies: 0  

Advanced Search

Back to Topic List Back to Topic List  
Ajay Bidyarthy

Posts: 4
Registered: 3/6/14
write to multiple dataset to excel spreadsheet
Posted: May 15, 2014 8:23 AM
  Click to see the message monospaced in plain text Plain Text   Click to reply to this topic Reply

Hi,

I have 4 variables defined in matlab,

for example:
x1=rand(10);
x2=rand(10);
x3=rand(10);
x4=rand(10);

data1 = dataset(x1, x2);

data2 = dataset(x3, x4);

I want to save data1 and data2 to one excel file where data1 and data2 writes to sheet name 'data1' and 'data2' respectively with column names x1, x2, ....

I tried by doing this but in csv:

export(data1, 'file', 'data.csv', 'Delimiter', ',');

Need help,
Thanks




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

[Privacy Policy] [Terms of Use]

© Drexel University 1994-2014. All Rights Reserved.
The Math Forum is a research and educational enterprise of the Drexel University School of Education.