Specifying row and columns in writetable function
33 次查看(过去 30 天)
显示 更早的评论
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?
0 个评论
回答(1 个)
Giuseppe Inghilterra
2020-2-16
Hi,
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".
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
产品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!