Specifying row and columns in writetable function
조회 수: 41 (최근 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!