Sheets in excel file xlswrite and xlsread

I have an xls file with one sheet, I want to create another sheet in it and write in that sheet, How can I do that?

[dpb]

See doc/examples for readtable and writetable and friends...depending upon the content of the data you care to write, writematrix or writecell may be of interest as well.

While it can be done with them, xlsread, xlswrite have been deprecated are are not recommended/discouraged.

[Matt]

writematrix or writecell simply puts data into the excel file. It doesn't force the excel file to calculate. Can you use writematrix or writecell but also force the excel sheet to calcuate and then readcell?

[Cris LaPierre]

I don't believe so. You would need to use ActiveX for Excel to recalulate its equations.

See this answer: https://www.mathworks.com/matlabcentral/answers/2111551-update-an-excel-file-after-each-matlab-calculation

[dpb]

Not definite, but my observation of the behavior of the writeXXXX clan is that if one sets 'UseExcel',1 then Excel will recalculate. I've been writing dynamic "=SUM($D$3:$D$53)" and other formulas with writecell and those get interpreted as the formulas and are evaluated when looking at the workbook or the value is returned if read the cell, not the formula.