How To Check Whether a Sheet Exists?

[fauder]

I know that XLDocument has a bool operator to check for the result of the open() operation.

What to do for sheets? For example, if worksheetExists( sheet_name ) returns true, does that mean that the sheet opened successfully?

[aral-matrix]

Good question. Never considered because: If you try to get a worksheet from the workbook, you will get an exception if that fails, which you can catch.
But if you create an empty XLWorksheet yourself, indeed, such a method XLSheet::valid() would be helpful before you trigger a segmentation fault (I just tested that e.g. XLSheet::name() has no safeguard when the underlying XML is a null pointer).

I'll implement this once I am done with the current change.

[fauder]

Then, for now at least, the correct way to handle this is to use try-catch when attempting to get a worksheet from a workbook, right?

[aral-matrix]

Yes, you could do it like that when attempting to get a worksheet by name. Or - if unsure - you could iterate over the worksheets by index and test the names.

[aral-matrix]

And with 02f7d42#diff-1875efb653648b982a3e6d1344f92e3947645bac6865095c606a954c7b18d3feR109 you can now access XLWorksheet::valid() to determine whether the underlying XLXmlFile has a link to XML data (or is default initialized with a null pointer).
if XLXmlFile::valid() returns false, invoking any class member functions that access the underlying XML may result in a segmentation fault / undefined behavior.

[aral-matrix]

Patch has been merged into master