Use read/writematrix instead
data=readmatrix('text.xlsx');
writematrix(nan(size(data)),'test.xlsx',"WriteMode",'inplace','Range','A9','UseExcel',1,"PreserveFormat",1)
There are no builtin MATLAB functions that will read/return the textbox you've got stuck in that header region so you've got to blank out the other data that is in the file to do what you want with prepackaged functions.
Be a lot simpler to just create a template workbook and use it to create the new file from...
There are user-written functions on FEX and some have been posted here that use the ActiveX interface and package functions for some low-level operations such as this, but I don't have a specific link at hand...well, let's see -- I do have a utility package I did download some time back I've fiddled with some...let's see what's in it, I forget.
Excel = actxserver('Excel.Application')
d=dir('test.xlsx')
Workbook = Excel.Workbooks.Open(fullfile(d.folder,d.name))
Excel.Range('A9:E34').Select
Excel.Selection.Clear
Excel.ActiveWorkbook.Save
Excel.ActiveWorkbook.Close(false)
delete(Excel); clear Excel
is the basics -- I just used a hardcoded range; you'd have to figure that range out dynamically if not known a priori. There's a function that will return the used range in a sheet that could be used. To use ActiveX, one has to just pore through the VBA help files and find the functions of use and figure out what Excel syntax can be used w/ ActiveX; much that works in VBA doesn't translate over owing to there not being the VBA compiler to translate syntax.
