Hi, is there a way to emulate a "select all" programatically?

Topics: User Forum
May 19, 2014 at 3:51 PM
As stated in the subject, I need a way by which to select all of the cells in the sheet so that I can change the whole sheet's number format to be text in a programmatic way.
Thanks in advance!
May 19, 2014 at 4:24 PM
You shouldn't need to "select", but just specify the range of cells in a call to getStyle()

The Worksheet's calculateWorksheetDimension() or calculateWorksheetDataDimension() methods should return the range of cells for the worksheet