Adding Data Already Existing Excel Sheets
显示 更早的评论
Hi,
I created an excel file nade "DATA". There are seven different sheets in it and the firs one is "PAGE1". My code gives numerical data at the end. I want put this data into a spesific row and colomn in the already excisting "DATA" file "PAGE1" sheet. How can I do that?
2 个评论
darova
2020-3-5
Do you want to append data? Or you already know where to write (row and column)?
Onur ALPAY
2020-3-5
采纳的回答
darova
2020-3-5
Try writematrix
writematrix(M,'Sample.xlsx','Sheet',1,'Range','D3:D6')
4 个评论
Onur ALPAY
2020-3-6
darova
2020-3-6
I don't have writematrix. I used xlswrite and cell
A = {'my string'}; % put string in cell
xlswrite('Sample.xlsx',A,'Sheet1','F1')
Moh. Saadat
2020-4-27
Hi, is there any way I can append a row to an existing excel sheet without explicitly specifying the 'Range'?
For instance, I already have:
1 2
5 1
and I need to add another row with [0 3]: instead of using
writematrix(filename, var, 'Range', 'A3:B3');
I want something like
writematrix(filename, var, 'append')
The problem with specifying 'Range' is that the number of columns I will have in my variable is not fixed; that's why specifying the range explicitly becomes more complicated than it should be.
Thanks in advance!
darova
2020-4-27
There is no append option. You can only read the whole matrix
Try this
A = readmatrix('data.xlsx','sheet',1); % read the whole matrix
A = [A; 0 3]; % append data
writematrix('data.xlsx','sheet',1) % write new matrix
更多回答（1 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
