increment of alphabet like as columns 'A1' to 'B1'...'Z1'

Question

i am exporting my data into Excel Using Open XML. now i want to increment of alphabet like as columns 'A1' to 'B1'...'Z1' 'AA1'.

Sibeesh Venu · Answer

Please read here http://stackoverflow.com/questions/6454242/increment-of-alphabet-in-c-sharp You may get some Idea.

Vulpes · Answer

I've written a couple of C# methods which might help with this: using System; using System.Text.RegularExpressions; class Test { static void Main() { Console.WriteLine(AppDomain.CurrentDomain.BaseDirectory + output.txt); Console.WriteLine(IncrementRow(A14)); // A15 Console.WriteLine(IncrementRow(AB14)); // AB15 Console.WriteLine(IncrementColumn(AB14)); // AC14 Console.WriteLine(IncrementColumn(AZ14)); // BA14 Console.WriteLine(IncrementColumn(AZZ14)); // BAA14 Console.WriteLine(IncrementColumn(ZZZ14)); // AAAA14 Console.ReadKey(); } static string IncrementRow(string cell) { string reg = @^([A-Za-z]+)(\d+)$; Match m = Regex.Match(cell reg); if(!m.Success) { throw new ArgumentException(cell +  is not a valid cell reference); } int rowNumber = int.Parse(m.Groups[2].Value); return m.Groups[1].Value.ToUpper() + (++rowNumber); } static string IncrementColumn(string cell) { string reg = @^([A-Za-z]+)(\d+)$; Match m = Regex.Match(cell reg); if(!m.Success) { throw new ArgumentException(cell +  is not a valid cell reference); } string colLetters = m.Groups[1].Value.ToUpper(); int len = colLetters.Length; char lastLetter = colLetters[len - 1]; if (lastLetter { colLetters = colLetters.Substring(0 len - 1) + (++lastLetter); } else if (Regex.IsMatch(colLetters ^Z+$)) { colLetters = new string('A' len + 1); } else { int base26 = 0; int multiplier = 1; for(int i = len - 1; i >= 0; --i) { base26 += multiplier * (colLetters[i] - 65); multiplier *= 26; } base26++; string temp = ; while(base26 > 0) { temp = (char)(base26 % 26 + 65) + temp; base26 /= 26; } colLetters = temp; } return colLetters + m.Groups[2].Value; } }

increment of alphabet like as columns 'A1' to 'B1',...'Z1',