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

Question

VBBV 2018-7-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/411253-how-can-i-write-data-into-excel-sheet-and-hide-other-unused-rows-and-columns-in-a-sheet

评论： VBBV 2018-7-20

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Walter Roberson 2018-7-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/411253-how-can-i-write-data-into-excel-sheet-and-hide-other-unused-rows-and-columns-in-a-sheet#answer_329563

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/

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

VBBV 2018-7-20

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 ?

请先登录，再进行评论。