How can i write data into Excel sheet and hide other unused rows and columns in a sheet ?
3 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
VBBV
el 20 de Jul. de 2018
Comentada: VBBV
el 20 de Jul. de 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 ?
0 comentarios
Respuesta aceptada
Walter Roberson
el 20 de Jul. de 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.
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!