Specifying row and columns in writetable function

I have 2 separate scripts collect data and I want to store said data in one excel file. How can I tell script B to store information in any rows and columns that script A has not occupied?

Also how can I specify which of the 3 sheets the table is generating to use?

Answer 1

[Giuseppe Inghilterra]

Hi,

see https://www.mathworks.com/help/matlab/ref/writetable.html on how to use writetable function.

writetable(T,'myData.xls','Sheet',SheetVariable,'Range',RangeVariable)

In general you can specify in which sheet you want to write your data by defining SheetVariable as index or name of the sheet and where by defining RangeVariable in rectangular shape (example: RangeVariable = 'A1:F5').

Thus if you know table data sizes you can avoid to overwrite "B" on "A".