IWorksheetManager.GetColumnLettersFromPosition Method

Gets the column letters in A1 notation from column numeric position.
Function GetColumnLettersFromPosition( _ 
ByVal columnPosition As Integer
) As String
This language is not supported or no code example is available.
string GetColumnLettersFromPosition( 
int columnPosition 
)
This language is not supported or no code example is available.

Parameters

columnPosition
int

A zero based column position. Can range from 0 to 16383.

Return Value

string

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

Remarks
 

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: 0 returns A, 1 returns B, 25 returns AA. Unlike Excel VBA, we use base 0 because SpreadsheetGear uses base 0.

Version
 
Available since QDV 7.17.646.

.NET Framework

Supported in: 4.8, 4.7, 4.6, 4.5.2

In this article

Definition