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

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 < 'Z')

{

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;

}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sibeesh Venu11y ago
Please read here
http://stackoverflow.com/questions/6454242/increment-of-alphabet-in-c-sharp
You may get some Idea.
0
Vulpes11y ago
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 < 'Z')
{
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;
}
}

0