MATLAB Answers

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

14 views (last 30 days)
VBBV on 20 Jul 2018
Commented: VBBV 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.

Answers (1)

Walter Roberson
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

VBBV on 20 Jul 2018
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.

Community Treasure Hunt

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

Start Hunting!

Translated by