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',

Answers (2)