new row in a excel file

Hello, does somebody know how to insert a new row in a excel already made? I need to insert in that row the results from another function. Thank you

[Johannes Hougaard]

Hi Carmo

If you want to add a new row to the bottom of your excel sheet you can use the function writematrix with the write mode 'append'

new_line = randn(1,9);
writematrix(new_line,'thisisanexcelfile.xlsx','Sheet',sheetno,'WriteMode','append');

Answer 1

[Cameron]

Excel = actxserver('Excel.Application');
set(Excel, 'Visible', 1);
Workbooks = Excel.Workbooks;
Workbook = invoke(Workbooks, 'Add');
Excel.ActiveWorkbook.ActiveSheet.Range("C3").Value = "Row 3"; %on row 3
Excel.ActiveWorkbook.ActiveSheet.Range("C4").Value = "Row 4"; %on row 4
Excel.ActiveWorkbook.ActiveSheet.Range("C4").EntireRow.Insert; %now the text "Row 4" is on C5