WorksheetColumnName

Obtains an Excel Worksheet column name based on an ordinal position

Syntax:

SELECT SQLHTTP.net.WorksheetColumnName ( @ColumnNumber )

Arguments:

Name	Type	Description
@ColumnNumber	int	The ordinal position of an Excel Worksheet column.

Return Type:

varchar(50)

Sample Usage:


SELECT SQLHTTP.net.WorksheetColumnName(2) AS Column2,
       SQLHTTP.net.WorksheetColumnName(100) AS Column100

SELECT SQLHTTP.net.WorksheetColumnName(2) AS Column2,

SQLHTTP.net.WorksheetColumnName(100) AS Column100

Column2 Column100

------------ ------------

B CV