This project has moved. For the latest updates, please go here.

How to select maximum number of rows and columns

Jun 17, 2013 at 8:37 PM
Hello, I am using this library to create a report in a spreadsheet (and what a fantastic library it has been for me!). What I would like to do now that I have my information in the spreadsheet is to hide all rows and columns around the blocked off range of cells which contain my report information and formatting. From looking around in other posts, I came across the dimension property of a worksheet. Unfortunately, worksheet.dimension.end.column does not provide me with the absolute end of the spreadsheet, but rather what seemed to be my last used cell. The action can be manually done in excel by selecting a cell and pressing ctrl + shift + right arrow for columns and ctrl + shift + down arrow for rows. Any help is greatly appreciated.