MATLAB: Adding Data Already Existing Excel Sheets

adding datadata import excel

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?

Best Answer

Try writematrix

writematrix(M,'Sample.xlsx','Sheet',1,'Range','D3:D6')

Related Solutions

MATLAB: Excel – Clearing Sheet Content

Here's a snippet of code I used to clear the comments.

thisSheet = Excel.ActiveSheet;
% Get a reference to the cell at this row in column A.
cellReference = sprintf('%s%d', columnLetterCode, startingRow);
theCell = thisSheet.Range(cellReference);
% You need to clear any existing comment or else the AddComment method will throw an exception.
theCell.ClearComments();

I imagine it would be

theCell.Clear();

or something similar. Give it a try.

MATLAB: Writematrix error exceeds sheet boundaries error

hi again

the proof is here

you're trying to save in older xls format which is limited to 2^16 = 65536 rows

try with xlsx format (the limit should be 2^20 rows)

>> A = rand(2^17,2);
>> writematrix(A, 'test.xls','Sheet', 1, 'Range','A1');
Error using writematrix (line 175)
The data block starting at cell 'A1' exceeds the sheet boundaries by 65536 row(s) and 0 column(s).
 
>> writematrix(A, 'test.xlsx','Sheet', 1, 'Range','A1');
>>

Best Answer

Related Solutions

MATLAB: Excel – Clearing Sheet Content

MATLAB: Writematrix error exceeds sheet boundaries error

Related Question