Hello, I wanted to write a routine in C# that converts a Excel column number
to column letter and vice versa. Any ideas?

Here is a web link to do it with VB6....

http://www.freevbcode.com/ShowCode.asp?ID=4303


Maybe you can take the formula used for this function and convert it to work
with C#...

Mark Ivey

"guest" wrote in message
...
Hello, I wanted to write a routine in C# that converts a Excel column
number
to column letter and vice versa. Any ideas?

Looks like this function only works upto 2 character column names, is there
any generalized function that works for all column names?

I can use that formula and change it to make it work for all column names
but just wondering if someone has already done it so that I dont have to
spend time. I am planning do it in the next 3-4 days, if someone else has
solution for it already well and good, otherwise I will post my solution once
I get to it.



"Mark Ivey" wrote:

Here is a web link to do it with VB6....

http://www.freevbcode.com/ShowCode.asp?ID=4303


Maybe you can take the formula used for this function and convert it to work
with C#...

Mark Ivey

"guest" wrote in message
...
Hello, I wanted to write a routine in C# that converts a Excel column
number
to column letter and vice versa. Any ideas?