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

24 次查看（过去 30 天）

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

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.

Mariam Achraf 2020-9-7

it worked thanks alot

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

R2014b

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

Translated by