XLL+ Class Library (7.0)

CXlOper::GetWorksheetNames

Gets the workbook name and sheet name of a CXlOper containing a reference

BOOL GetWorksheetNames(
   CStringA& stBook,
   CStringA& stSheet
) const;
BOOL GetWorksheetNames(
   CStringW& stBook,
   CStringW& stSheet
) const;

Parameters

stBook

The workbook name will be placed into this string argument.

stSheet

The sheet name will be placed into this string argument.

Return Value

TRUE if the function was successful. FALSE if it there was an error parsing the full sheet name.

Remarks

For a CXlOper that contains a reference (either single or multiple) this function retrieves the full worksheet name, and splits it into two parts: workbook and sheet.

The function throws an exception of type CXlBadOperTypeException if the object does not contain a single or multiple reference.

Requirements

Header: xllplus.h

See Also

CXlOper Class | CXlOper Methods | CXlOper::GetSheetName()