I am developing a VB.Net application that generates Excel spreadsheets. In each spreadsheet, I want to hide all unused columns and rows so that the user is presented with the minimum area to work with.
For example, one spreadsheet template has columns A-J and rows 1-100. I want to hide all columns from K to whatever the end column is (which is Excel version dependent) and I want to hide all rows from 101 to the end row (which is also Excel version dependent).
What is the best way of doing this.