This project has moved and is read-only. For the latest updates, please go here.

Parse the Excel worksheet name from a cell address

Oct 31, 2012 at 5:54 PM

Presently, I use my own code to parse out the sheet name from cell addresses such as 'sheet1!A1'. The Excel Address class has an internal method that parses the sheet name. 

My questions are:

  1. Is there a public method that parses the cell address to return the sheet name?
  2. Would it make sense to add such functionally, perhaps to the Excel Address or the Excel Cell Address class or expose an existing internal method for this purpose?