writetable to a specified cell range in an excel sheet without printing the table name in the 1st cell
24 次查看(过去 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!