¡@

Home 

c# Programming Glossary: columnstring

Convert A to 1 B to 2 … Z to 26 and then AA to 27 AB to 28 (column indexes to column references in Excel)

http://stackoverflow.com/questions/1951517/convert-a-to-1-b-to-2-z-to-26-and-then-aa-to-27-ab-to-28-column-indexes-to

static string ExcelColumnFromNumber int column string columnString decimal columnNumber column while columnNumber 0 decimal currentLetterNumber.. 1 26 char currentLetter char currentLetterNumber 65 columnString currentLetter columnString columnNumber columnNumber currentLetterNumber.. char currentLetterNumber 65 columnString currentLetter columnString columnNumber columnNumber currentLetterNumber 1 26 return columnString..

Fastest function to generate Excel column letters in C#

http://stackoverflow.com/questions/837155/fastest-function-to-generate-excel-column-letters-in-c-sharp

static string ExcelColumnFromNumber int column string columnString decimal columnNumber column while columnNumber 0 decimal.. 1 26 char currentLetter char currentLetterNumber 65 columnString currentLetter columnString columnNumber columnNumber currentLetterNumber.. char currentLetterNumber 65 columnString currentLetter columnString columnNumber columnNumber currentLetterNumber 1 26 return..