IWorksheetManager.GetColumnPositionFromLetters Method

Function GetColumnPositionFromLetters( _ 
   ByVal columnLetters As String _ 
) As Integer

This language is not supported or no code example is available.

int GetColumnPositionFromLetters( 
   string columnLetters 
)

This language is not supported or no code example is available.

Parameters

columnLetters

string

The letters referencing the column as they are usually used in formulas, in A1 notation.

Return Value

A zero based column position in the worksheet.

Excel, by default, uses a reference format known as A1. This simply means that columns are referred to using letters and rows using numbers. References contain a combination of both the column letter and row number, thereby designating a unique cell.

Example: A returns 0, B returns 1, AA returns 25. Unlike Excel VBA, we use base 0 because SpreadsheetGear uses base 0.

.NET Framework