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