Specifying row and columns in writetable function

조회 수: 41 (최근 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
Giuseppe Inghilterra 2020년 2월 16일
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 CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

제품

Community Treasure Hunt

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

Start Hunting!

Translated by