MATLAB Answers


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

Asked by Vasishta Bhargava on 20 Jul 2018
Latest activity Commented on by Vasishta Bhargava on 20 Jul 2018
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 ?


Sign in to comment.

1 Answer

Answer by Walter Roberson
on 20 Jul 2018

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.

  1 Comment

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 ?

Sign in to comment.