Specifying row and columns in writetable function

42 次查看（过去 30 天）
Deon Hargrove
Deon Hargrove 2020-2-7
回答： Giuseppe Inghilterra 2020-2-16
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?

请先登录，再回答此问题。

回答（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".

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by