Question

Using MATLAB please help, I've made the Excel File but cannot get the row added through MATLAB

I L U.U.1.10] and vector Y=X; exp(X)]. Save Y as "fprintf and "fclose" commands. 25. Create excel file called 'Sep Excel File.xlsx' which has following: File Date Time Taken Status F32 1-Sep 10 OK F34 3-Sep 120 Fail 656 5-Sep 28 Ok Use MatLab to write a following row to above file. {"F70', '6-Sep', 70, 'OK'}; 1 Use MatLab to read 'Sep Excel File.xlsx' file. When you complete this in-class assignment, type: >>diary off

Answer 1

clc
row1={'F70','6-sep',70,'OK'};
xlswrite('Sep Excel File.xlsx',row,1,'A5')

Excel sheet before writing by Matlab:

Sep Excel File.xlsx - Excel SƏo Home Insert File Page Layout Formulas Data Review View Developer Help Tell me what you want to E F G H I J K F13 2 A 1 File F32 3 F34 4 G56 : * fic B C D Date Time Taker Status 01-Sep 10 OK 03-Sep 120 Failed 05-Sep 28 OK Nm 7 00

Excel sheet after writing by Matlab:

Sep Excel File.xlsx - Excel SS File Home Insert Page Layout Formulas Data Review View Developer Help Tell me what you want to do E13 - X Fac F G H I J K A 1 File 2 F32 3 F34 4 656 F70 B Date 01-Sep 03-Sep 05-Sep 06-Sep C D Time Taker Status 10 OK 120 Failed 28 OK 70 OK 7