Example

The following example converts a column letter to the corresponding column number.

C++

long s;
char buffer[20];

// Set number of sheets
m_Spread.SetSheetCount(2);
// Set specific sheet number
m_Spread.SetSheet(1);
// Use ColLetterToNumber method
s = m_Spread.ColLetterToNumber("D");
// Show result in message box, convert long
_ltoa( s, buffer, 16 );
::MessageBox (NULL, buffer, "message body", MB_OK);

Visual Basic

' Set number of sheets
fpSpread1.SheetCount = 2
' Set specific sheet number
fpSpread1.Sheet = 1
Dim i As Long
' Get column number
i = fpSpread1.ColLetterToNumber("C")
' Show result in immediate window
Debug.Print i