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

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]

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]

it worked thanks alot