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

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 commentaires

Can you be more specific about what happens when you do the commands listed there? (I can't do it myself, because xlswrite does not work on a Mac.)
Are you getting anything at all written to the Excel file?
santosh
santosh le 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
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?

Connectez-vous pour commenter.

 Réponse acceptée

Matt Tearle
Matt Tearle le 23 Mar 2011

0 votes

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 commentaires

Using multiple usernames to ask the same question is hard on the people answering questions :(
Maybe it's a class project or something?
With the exact same account name? ototemp-u ? I suppose it is possible, but it seemed unlikely.
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 :)

Connectez-vous pour commenter.

Plus de réponses (0)

Community Treasure Hunt

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

Start Hunting!

Translated by