writetable to a specified cell range in an excel sheet without printing the table name in the 1st cell

28 次查看（过去 30 天）
Mariam Achraf
Mariam Achraf 2020-9-7
评论： Mariam Achraf 2020-9-7
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

请先登录，再回答此问题。

回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2014b

Community Treasure Hunt

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

Start Hunting!

Translated by