How can i write data into Excel sheet and hide other unused rows and columns in a sheet ?

I have GUI which will write data into excel worksheet in a defined format so that region can be printed However, it writes the data into sheet, with whole sheet viewable. I would like to write data in specific format, and make/hide the remaining region of worksheet. How can I do it ?

Answer 1

[Walter Roberson]

You will need to work at the ActiveX level to talk to Excel directly. It looks to me as if you would define a Range and then set the Hidden property of the range to true.

https://analysistabs.com/excel-vba/hide-unhide-rows-worksheet/

[VBBV]

how can I implement it using MATLAB GUI script ? The link shows the program statements in Excel VBA. but how to make MATLAB understand those statements say by using a pushbutton callback ?