MATLAB: Insert Values of a Matrix from row 2 using XLSWRITE

excelexport data to excel

Hi.

I am using LXSWRITE to export values of a matrix to Excel file. Suppose that I have a 5*20 matrix. I want Matlab write this matrix from row 2 (because I have an excel template and I don't want change first row of it in overwriting).

What should I do?

Thanks.

Best Answer

A = ones(5,20);
xlswrite('Workbook.xls',A,'Sheet1','A2')

Related Solutions

MATLAB: XLSWRITE

name = inputdlg('Name excel file as: ','Name excel',1);

MATLAB: Color the particular row of the excel sheet

% Connect to Excel
Excel = actxserver('excel.application');
% Get Workbook object
WB = Excel.Workbooks.Open(fullfile(pwd, 'Book1.xlsx'),0,false);
% Set the color of cell "A1" of Sheet 1 to Yellow
WB.Worksheets.Item(1).Range('A1').Interior.ColorIndex = 6;
% Save Workbook
WB.Save();
% Close Workbook
WB.Close();
% Quit Excel
Excel.Quit();

Does this, ofcourse you can change all the values.

Best Answer

Related Solutions

MATLAB: XLSWRITE

MATLAB: Color the particular row of the excel sheet

Related Question