XLL+ Class Library (7.0)

CXlRef::FromString

Reads a string address into the reference

BOOL FromString(
   const char* psz,
   BOOL bLocalLanguage = FALSE,
   BOOL allowA1 = TRUE,
   BOOL allowRC = TRUE
);
BOOL FromString(
   const wchar_t* psz,
   BOOL bLocalLanguage = FALSE,
   BOOL allowA1 = TRUE,
   BOOL allowRC = TRUE
);
BOOL FromString(
   const char* psz,
   BOOL bLocalLanguage,
   BOOL allowA1,
   BOOL allowRC,
   BOOL& isRC
);
BOOL FromString(
   const wchar_t* psz,
   BOOL bLocalLanguage,
   BOOL allowA1,
   BOOL allowRC,
   BOOL& isRC
);

Parameters

psz

The string address of a cell or a range.

bLocalLanguage

TRUE if the address is in the local language; FALSE for English. This setting as no impact on A1-style addresses. R1C1 format addresses use different letters in different languages: thus the English address "R1C2" is written as "Z1S2" in German. If bLocalLanguage is TRUE, then the local letters are expected.

allowA1

TRUE if the address may be in A1 format, FALSE if A1 format will be rejected.

allowRC

TRUE if the address may be in R1C1 format, FALSE if R1C1 format will be rejected.

psz

The string address of a cell or a range.

isRC

This will be set to TRUE if the fuinction succeeds and the address was in R1C1 format, and will be set to FALSE otherwise.

Return Value

TRUE if the string address is valid; FALSE otherwise.

Remarks

This function translates the cell address given in the parameter to a range.

Requirements

Header: xllplus.h

See Also

CXlRef Class | CXlRef Methods