How to store 5 or 6 files output into same excel file

3 views (last 30 days)
Hi all, I got an output for one input file and I am able to store it in an Excel file but I m unable to store the outputs of 5 or 6 different data files into the same sheet at different locations.
I m using the following lines to store the output of one specific file into an Excel sheet.
xlswrite('C:\Documents and Settings\ototemp-u\My Documents\MATLAB\filenamenew1.xlsx', t(record2),'Sheet1','A2');
xlswrite('C:\Documents and Settings\ototemp-u\My Documents\MATLAB\filenamenew1.xlsx', Z2(record2),'Sheet1','B2');
xlswrite('C:\Documents and Settings\ototemp-u\My Documents\MATLAB\filenamenew1.xlsx', surfacearea1,'Sheet1','C2');
xlswrite('C:\Documents and Settings\ototemp-u\My Documents\MATLAB\filenamenew1.xlsx', surfacearea2,'Sheet1','D2');
Can anyone help me in storing outputs for 5 or 6 different files into same excel sheet at different locations. So that when the file opens i can see all the ouputs displayed in one sheet.
  3 Comments
santosh
santosh on 23 Mar 2011
yes I got the following output displayed in excel sheet
time voltage surfacearea1 surfacearea2
-0.00000 0.008042888 128.7363433 -102.6392393
0.0000012 0.664704232
0.0000256 0.924939582
0.0000276 0.274450029
0.0000336 0.224029065
0.0000352 -0.449776046
0.0000598 -0.769207036
0.0000618 -0.035030136
the cyclist
the cyclist on 23 Mar 2011
What are the sizes of the arrays you are writing? Maybe they are not the sizes you expect? Maybe surfacearea1 and surfacearea2 are accidentally scalar instead of vector?

Sign in to comment.

Accepted Answer

Matt Tearle
Matt Tearle on 23 Mar 2011
Do you know Sandeep by any chance? What I suggested to him should work for you as well (seeing as it's the same problem).
  4 Comments
Walter Roberson
Walter Roberson on 23 Mar 2011
With the exact same account name? ototemp-u ? I suppose it is possible, but it seemed unlikely.
Matt Tearle
Matt Tearle on 23 Mar 2011
I thought that might be some default university public lab setting kind of thing (the "temp" part, in particular). Either way, I'm glad I gave general guidance, rather than exact code :)

Sign in to comment.

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!