How can i write data into Excel sheet and hide other unused rows and columns in a sheet ?
3 views (last 30 days)
Show older comments
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 ?
0 Comments
Accepted Answer
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.
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!