Adding data to existing excel

58 次查看（过去 30 天）

syahdan edy murad 2018-7-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/409239-adding-data-to-existing-excel

回答： Hazem Kamel 2024-7-25，17:28

Hi, I want to ask a question I want a program where I can add more row data every time I execute this program, but when i execute this code, only row 2 got added, not 3, 4, etc. I want it to stack, every time I run the program

here is the code :

tgl=4;
Jumlah=1;
nama='adawd';
ntgl=3;
nJumlah=3;
nnama='dddd';
A = {'Tanggal','Jumlah Laki-Laki','Nama Video'; tgl,Jumlah,nama};
baru = {ntgl,nJumlah,nnama};
A(end+1,:) = baru;
xlswrite('Masukkan nama file.xls',A);

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

请先登录，再进行评论。

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

采纳的回答

Image Analyst 2018-7-7

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/409239-adding-data-to-existing-excel#answer_327879

You need to use the xlsread() first to determine what the last row of your existing data it. Then use xlswrite's 3rd and 4th arguments to make sure you're writing additional data to the end of the existing data.

14 个评论
显示 12更早的评论隐藏 12更早的评论

Image Analyst 2020-3-22

在 MATLAB Online 中打开

Looks like you'll be overwriting all prior data since your call to xlswrite() does not specify a cell reference so everything will go into cell A1. Thus you're calling xlswrite() way more than is needed. You can call it just once, after the loop where you've stuffed everything into allResults. Something like

            templateFullFileName = fullfile('D:\', 'Excel Results Template.xlsx');  %create new file in selected folder
            thisFullFileName = fullfile('C:\', 'New Report.xlsx'); % place the new file for desired output
            if isfile(templateFullFileName)
                % Copy over template, but only if it exists (so we don't throw an error).
                copyfile(templateFullFileName, thisFullFileName);
            end
            allResults = zeros(6, 4); % Preallocate space for all results.
            xlRow = 1;
            for k = 1 : size(allResults, 1) % k is row number
                % Get new results (a 4 element row vector) by calling the baru() function.
                theseResults = baru; % baru is a set of data as syahdan write
                % Stuff these 4 numbers into row k of allResults.
                allResults(k, :) = theseResults;
            end
            % Now that allResults has been built up, we can export it to 
            % an Excel workbook file called 'New Report.xlsx' into cell A1 of 'Sheet1'.
            xlswrite(thisFullFileName, allResults);

I'd only put it inside the loop if the computation takes a long time (hours) and you want to make sure you at least have something in the workbook in case your program crashes.

halawati cm 2020-3-30

ok, if i have different set of data to write into excel file like this:

data1= [0.1, 0.2, 0.3, 0.4];

data2= [0.5, 0.6, 0.7, 0.8];

data3=[0.9, 0.10, 0.11, 0.12];

the question is:

1-how to write it to the excel file with different set of data?

2-after close the application and run again, how to append the new set of data into the existing excel file without missing the existing data in the file?

tqvm for your response.

Image Analyst 2020-3-30

在 MATLAB Online 中打开

One way to do it would be to first read it in and see what the last row is. Then write to the row below it.

[numbers, strings, raw] = xlsread(filename);
lastRow = size(raw, 1);
nextRow = lastRow + 1;
cellReference = sprintf('A%d', nextRow);
xlswrite(excelFullFileName, data1, 'Sheet1', cellReference);
nextRow = nextRow + 1;
cellReference = sprintf('A%d', nextRow);
xlswrite(excelFullFileName, data2, 'Sheet1', cellReference);
nextRow = nextRow + 1;
cellReference = sprintf('A%d', nextRow);
xlswrite(excelFullFileName, data3, 'Sheet1', cellReference);