writetable to a specified cell range in an excel sheet without printing the table name in the 1st cell
조회 수: 17 (최근 30일)
이전 댓글 표시
Hi All,
I am trying to export a specified table to a specific range in a.xls file but do not want the table name to show in the 1st specified cell
I am using this command
writetable (TestNames,filename,'Sheet',2,'Range','D27')
which puts in D27: 'TestNames', but I need in D27 the 1st table value: 'Test_00'
using this command does it but in a new sheet which is not my goal
writetable(T,filename,'Sheet','MyNewSheet','WriteVariableNames',false)
, I can't put instaed 'MyNewSheet' 2 as the 2nd sheet follows a specific format and I am allowed to write starting from D27 to Dxx
is there a way to use the 2nd command but giving a range to it as I was not able to find so
댓글 수: 2
dpb
2020년 9월 7일
Did you not try
writetable(T,filename,'Sheet','MyNewSheet','Range','D27','WriteVariableNames',false)
? You can use all available named options for either file type in conjunction with those of the type of file specifically writing.
답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Data Import from MATLAB에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!