How can i store multiple data into same excel file ?

Question

sandeep 2011-3-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/3781-how-can-i-store-multiple-data-into-same-excel-file

Hello all,

I am trying to store multiple data from m-file into same excel file.

my program selects a file and displays the corresponding outputs.

After that I am using the following to store into excel data:

%create the cell array containing the column headers

columnHeader = {'plotted points_time','plotted points_voltage', 'surfacearea1','surfacearea2'};

%write the column headers first

xlswrite('C:\Documents and Settings\ototemp-u\Desktop\myfile.xlsx', columnHeader );

%write the data directly underneath the column headers

xlswrite('C:\Documents and Settings\ototemp-u\Desktop\myfile.xlsx', t(record2),'Sheet1','A2');

xlswrite('C:\Documents and Settings\ototemp-u\Desktop\myfile.xlsx',Z2(record2),'Sheet1','B2');

winopen('C:\Documents and Settings\ototemp-u\Desktop\myfile.xlsx')

I want the program to store data from different selected files into 1 excel sheet.

Please help me out.

Regards,

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Matt Tearle 2011-3-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/3781-how-can-i-store-multiple-data-into-same-excel-file#answer_5443

在 MATLAB Online 中打开

I'm going to assume that the issue is that you want to run this code again later (with different data), so you don't necessarily know, when you run it that second time, how much data is already in the xls file. In that case, a simple fix is to use exist to see if the xls file already exists. If so, use

[~,~,raw] = xlsread(file);
rowoffset = size(raw,1);

to work out how many rows to skip. (Set rowoffset = 0 is the file doesn't exist.)

Then use num2str to make the Excel cell references for writing. Eg

Cref = ['B',num2str(rowoffset+2)];
xlswrite(...,Cref);

2 个评论
显示无隐藏无

sandeep 2011-3-23

My matlab program asks for input file as following:

prompt1={'Enter input file name (without extension [.mat]): '};

fname1 = inputdlg(prompt1);

After selecting this it runs the remaining code and displays output such as surface area, time , voltage. I am storing the values related to these variables in a excel file using xlswrite. When i run the matlab program second time, the output data related to the another input file that I have selected should be stored in the same excel file at different locations .

Thank you.

regards,

Matt Tearle 2011-3-23