conversion to c# from excel function help

[D]

I am trying to do this in C#

Function Num2Let(L As Long) As String
Dim s0 As String, s1 As String, S2 As String, s3 As String
If L > 18278 Then s0 = Chr((Int((L - 18279) / 17576) Mod 26) + 65)
If L > 702 Then s1 = Chr((Int((L - 703) / 676) Mod 26) + 65)
If L > 26 Then S2 = Chr(Num2Let & (Int((L - 27) / 26)) Mod 26 + 65)
s3 = Chr(((L - 1) Mod 26) + 65)
Num2Let = s0 & s1 & S2 & s3
End Function

it takes a long and converts it to the excel header format of AA, BQ DS etc

so far I have this, I commented out the top and worked my way up from the
bottom. I'm not sure what the c# equivalent of Int in excel (which returns
the 210 part of 210.2342) and I don't know what how this is handled
Chr(Num2Let & ( Int((L - 27) / 26) ) % 26 + 65);

Thanks for any help.
public string Num2Let(long L )

{

string s0, s1, S2, s3, final;

/* if(L > 18278)

s0 = Chr((Int((L - 18279) / 17576) % 26) + 65);

if(L > 702)

s1 = Chr((Int((L - 703) / 676) % 26) + 65);

*/

if(L > 26)

S2 = Chr(Num2Let(((L - 27) / 26)) % 26 + 65);

//S2 = Chr(Num2Let & ( Int((L - 27) / 26) ) % 26 + 65);

long x =(((L - 1) % 26) + 65);

char c = (char)x;

s3 = c.ToString();

//final = s0 + s1 + S2 + s3;

return s3;

}

[RCS]

Man, you should make up a book of these and sell them at geek stores, you'd
make a fortune!!

If this doesn't get solved tonight, I'll give it a shot tomorrow - looks
fun!!
"D" <Da**@nothing.net> wrote in message
news:%2***************@TK2MSFTNGP15.phx.gbl...

I am trying to do this in C#

Function Num2Let(L As Long) As String
Dim s0 As String, s1 As String, S2 As String, s3 As String
If L > 18278 Then s0 = Chr((Int((L - 18279) / 17576) Mod 26) + 65)
If L > 702 Then s1 = Chr((Int((L - 703) / 676) Mod 26) + 65)
If L > 26 Then S2 = Chr(Num2Let & (Int((L - 27) / 26)) Mod 26 + 65)
s3 = Chr(((L - 1) Mod 26) + 65)
Num2Let = s0 & s1 & S2 & s3
End Function

it takes a long and converts it to the excel header format of AA, BQ DS
etc

so far I have this, I commented out the top and worked my way up from the
bottom. I'm not sure what the c# equivalent of Int in excel (which returns
the 210 part of 210.2342) and I don't know what how this is handled
Chr(Num2Let & ( Int((L - 27) / 26) ) % 26 + 65);

Thanks for any help.
public string Num2Let(long L )

{

string s0, s1, S2, s3, final;

/* if(L > 18278)

s0 = Chr((Int((L - 18279) / 17576) % 26) + 65);

if(L > 702)

s1 = Chr((Int((L - 703) / 676) % 26) + 65);

*/

if(L > 26)

S2 = Chr(Num2Let(((L - 27) / 26)) % 26 + 65);

//S2 = Chr(Num2Let & ( Int((L - 27) / 26) ) % 26 + 65);

long x =(((L - 1) % 26) + 65);

char c = (char)x;

s3 = c.ToString();

//final = s0 + s1 + S2 + s3;

return s3;

}

[D]

I wish I could but I didn't write it. I found it when I was looking for a
function to convert numbers to excel like headers (AAA, AAB, AAC etc).

I'll post the solution if I figure it out.
"RCS" <rs****@gmail.com> wrote in message
news:Vu*****************@newssvr33.news.prodigy.co m...

Man, you should make up a book of these and sell them at geek stores,
you'd make a fortune!!

If this doesn't get solved tonight, I'll give it a shot tomorrow - looks
fun!!
"D" <Da**@nothing.net> wrote in message
news:%2***************@TK2MSFTNGP15.phx.gbl...

I am trying to do this in C#

Function Num2Let(L As Long) As String
Dim s0 As String, s1 As String, S2 As String, s3 As String
If L > 18278 Then s0 = Chr((Int((L - 18279) / 17576) Mod 26) + 65)
If L > 702 Then s1 = Chr((Int((L - 703) / 676) Mod 26) + 65)
If L > 26 Then S2 = Chr(Num2Let & (Int((L - 27) / 26)) Mod 26 + 65)
s3 = Chr(((L - 1) Mod 26) + 65)
Num2Let = s0 & s1 & S2 & s3
End Function

it takes a long and converts it to the excel header format of AA, BQ DS
etc

so far I have this, I commented out the top and worked my way up from the
bottom. I'm not sure what the c# equivalent of Int in excel (which
returns the 210 part of 210.2342) and I don't know what how this is
handled Chr(Num2Let & ( Int((L - 27) / 26) ) % 26 + 65);

Thanks for any help.
public string Num2Let(long L )

{

string s0, s1, S2, s3, final;

/* if(L > 18278)

s0 = Chr((Int((L - 18279) / 17576) % 26) + 65);

if(L > 702)

s1 = Chr((Int((L - 703) / 676) % 26) + 65);

*/

if(L > 26)

S2 = Chr(Num2Let(((L - 27) / 26)) % 26 + 65);

//S2 = Chr(Num2Let & ( Int((L - 27) / 26) ) % 26 + 65);

long x =(((L - 1) % 26) + 65);

char c = (char)x;

s3 = c.ToString();

//final = s0 + s1 + S2 + s3;

return s3;

}

[Dennis Myrén]

Try this one.
I needed one myself too. Cool!

Do not know if it works yet.

public static string CellIndexToName ( int index )
{
if (0x0 >= index)
return string.Empty;
StringBuilder sb = new StringBuilder(0x5);
if (0x4766 < index)
{
sb.Append((char) ((int) ((int) ((double) (((double) (index - 0x4767)) /
17576)) % 0x1a) + 0x41));
}
if (0x2BE < index)
{
sb.Append((char) ((int) ((int) ((double) (((double) (index - 0x2bf)) /
676)) % 0x1a) + 0x41));
}
if (0x1A < index)
{
sb.Append((char) ((int) ((int) ((double) (((double) (index - 0x1b)) /
26)) % 0x1a) + 0x41));
}
sb.Append((char) (int) (((index - 0x1) % 0x1A) + 0x41));
return sb.ToString();
}
--
Regards,
Dennis JD Myrén
Oslo Kodebureau
"D" <Da**@nothing.net> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...

I wish I could but I didn't write it. I found it when I was looking for a
function to convert numbers to excel like headers (AAA, AAB, AAC etc).

I'll post the solution if I figure it out.
"RCS" <rs****@gmail.com> wrote in message
news:Vu*****************@newssvr33.news.prodigy.co m...

Man, you should make up a book of these and sell them at geek stores,
you'd make a fortune!!

If this doesn't get solved tonight, I'll give it a shot tomorrow - looks
fun!!
"D" <Da**@nothing.net> wrote in message
news:%2***************@TK2MSFTNGP15.phx.gbl...

I am trying to do this in C#

Function Num2Let(L As Long) As String
Dim s0 As String, s1 As String, S2 As String, s3 As String
If L > 18278 Then s0 = Chr((Int((L - 18279) / 17576) Mod 26) + 65)
If L > 702 Then s1 = Chr((Int((L - 703) / 676) Mod 26) + 65)
If L > 26 Then S2 = Chr(Num2Let & (Int((L - 27) / 26)) Mod 26 + 65)
s3 = Chr(((L - 1) Mod 26) + 65)
Num2Let = s0 & s1 & S2 & s3
End Function

it takes a long and converts it to the excel header format of AA, BQ DS
etc

so far I have this, I commented out the top and worked my way up from
the bottom. I'm not sure what the c# equivalent of Int in excel (which
returns the 210 part of 210.2342) and I don't know what how this is
handled Chr(Num2Let & ( Int((L - 27) / 26) ) % 26 + 65);

Thanks for any help.
public string Num2Let(long L )

{

string s0, s1, S2, s3, final;

/* if(L > 18278)

s0 = Chr((Int((L - 18279) / 17576) % 26) + 65);

if(L > 702)

s1 = Chr((Int((L - 703) / 676) % 26) + 65);

*/

if(L > 26)

S2 = Chr(Num2Let(((L - 27) / 26)) % 26 + 65);

//S2 = Chr(Num2Let & ( Int((L - 27) / 26) ) % 26 + 65);

long x =(((L - 1) % 26) + 65);

char c = (char)x;

s3 = c.ToString();

//final = s0 + s1 + S2 + s3;

return s3;

}

[D]

BRILLIANT!!!!!

Works fine for me so far.

Can you tell me why you used hex (0x0 , 0x4766, etc)?

Thanks alot!!!
"Dennis Myrén" <de****@oslokb.no> wrote in message
news:e6**************@TK2MSFTNGP09.phx.gbl...

Try this one.
I needed one myself too. Cool!

Do not know if it works yet.

public static string CellIndexToName ( int index )
{
if (0x0 >= index)
return string.Empty;
StringBuilder sb = new StringBuilder(0x5);
if (0x4766 < index)
{
sb.Append((char) ((int) ((int) ((double) (((double) (index - 0x4767)) /
17576)) % 0x1a) + 0x41));
}
if (0x2BE < index)
{
sb.Append((char) ((int) ((int) ((double) (((double) (index - 0x2bf)) /
676)) % 0x1a) + 0x41));
}
if (0x1A < index)
{
sb.Append((char) ((int) ((int) ((double) (((double) (index - 0x1b)) /
26)) % 0x1a) + 0x41));
}
sb.Append((char) (int) (((index - 0x1) % 0x1A) + 0x41));
return sb.ToString();
}
--
Regards,
Dennis JD Myrén
Oslo Kodebureau
"D" <Da**@nothing.net> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...

I wish I could but I didn't write it. I found it when I was looking for a
function to convert numbers to excel like headers (AAA, AAB, AAC etc).

I'll post the solution if I figure it out.
"RCS" <rs****@gmail.com> wrote in message
news:Vu*****************@newssvr33.news.prodigy.co m...

Man, you should make up a book of these and sell them at geek stores,
you'd make a fortune!!

If this doesn't get solved tonight, I'll give it a shot tomorrow - looks
fun!!
"D" <Da**@nothing.net> wrote in message
news:%2***************@TK2MSFTNGP15.phx.gbl...
I am trying to do this in C#

Function Num2Let(L As Long) As String
Dim s0 As String, s1 As String, S2 As String, s3 As String
If L > 18278 Then s0 = Chr((Int((L - 18279) / 17576) Mod 26) + 65)
If L > 702 Then s1 = Chr((Int((L - 703) / 676) Mod 26) + 65)
If L > 26 Then S2 = Chr(Num2Let & (Int((L - 27) / 26)) Mod 26 + 65)
s3 = Chr(((L - 1) Mod 26) + 65)
Num2Let = s0 & s1 & S2 & s3
End Function

it takes a long and converts it to the excel header format of AA, BQ DS
etc

so far I have this, I commented out the top and worked my way up from
the bottom. I'm not sure what the c# equivalent of Int in excel (which
returns the 210 part of 210.2342) and I don't know what how this is
handled Chr(Num2Let & ( Int((L - 27) / 26) ) % 26 + 65);

Thanks for any help.
public string Num2Let(long L )

{

string s0, s1, S2, s3, final;

/* if(L > 18278)

s0 = Chr((Int((L - 18279) / 17576) % 26) + 65);

if(L > 702)

s1 = Chr((Int((L - 703) / 676) % 26) + 65);

*/

if(L > 26)

S2 = Chr(Num2Let(((L - 27) / 26)) % 26 + 65);

//S2 = Chr(Num2Let & ( Int((L - 27) / 26) ) % 26 + 65);

long x =(((L - 1) % 26) + 65);

char c = (char)x;

s3 = c.ToString();

//final = s0 + s1 + S2 + s3;

return s3;

}

[Dennis Myrén]

So it works? Cool!
Have'nt really got the time to test it properly, just a few times with small
numbers.

There is no particular reason why i use hex instead of decimals, it is just
a matter
of preference, and maybe decimals would be clearer when posting code here.
--
Regards,
Dennis JD Myrén
Oslo Kodebureau
"D" <Da**@nothing.net> wrote in message
news:OG**************@TK2MSFTNGP15.phx.gbl...

BRILLIANT!!!!!

Works fine for me so far.

Can you tell me why you used hex (0x0 , 0x4766, etc)?

Thanks alot!!!
"Dennis Myrén" <de****@oslokb.no> wrote in message
news:e6**************@TK2MSFTNGP09.phx.gbl...

Try this one.
I needed one myself too. Cool!

Do not know if it works yet.

public static string CellIndexToName ( int index )
{
if (0x0 >= index)
return string.Empty;
StringBuilder sb = new StringBuilder(0x5);
if (0x4766 < index)
{
sb.Append((char) ((int) ((int) ((double) (((double) (index - 0x4767))
/ 17576)) % 0x1a) + 0x41));
}
if (0x2BE < index)
{
sb.Append((char) ((int) ((int) ((double) (((double) (index - 0x2bf)) /
676)) % 0x1a) + 0x41));
}
if (0x1A < index)
{
sb.Append((char) ((int) ((int) ((double) (((double) (index - 0x1b)) /
26)) % 0x1a) + 0x41));
}
sb.Append((char) (int) (((index - 0x1) % 0x1A) + 0x41));
return sb.ToString();
}
--
Regards,
Dennis JD Myrén
Oslo Kodebureau
"D" <Da**@nothing.net> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...

I wish I could but I didn't write it. I found it when I was looking for a
function to convert numbers to excel like headers (AAA, AAB, AAC etc).

I'll post the solution if I figure it out.
"RCS" <rs****@gmail.com> wrote in message
news:Vu*****************@newssvr33.news.prodigy.co m...
Man, you should make up a book of these and sell them at geek stores,
you'd make a fortune!!

If this doesn't get solved tonight, I'll give it a shot tomorrow -
looks fun!!
"D" <Da**@nothing.net> wrote in message
news:%2***************@TK2MSFTNGP15.phx.gbl...
>I am trying to do this in C#
>
> Function Num2Let(L As Long) As String
> Dim s0 As String, s1 As String, S2 As String, s3 As String
> If L > 18278 Then s0 = Chr((Int((L - 18279) / 17576) Mod 26) + 65)
> If L > 702 Then s1 = Chr((Int((L - 703) / 676) Mod 26) + 65)
> If L > 26 Then S2 = Chr(Num2Let & (Int((L - 27) / 26)) Mod 26 + 65)
> s3 = Chr(((L - 1) Mod 26) + 65)
> Num2Let = s0 & s1 & S2 & s3
> End Function
>
> it takes a long and converts it to the excel header format of AA, BQ
> DS etc
>
> so far I have this, I commented out the top and worked my way up from
> the bottom. I'm not sure what the c# equivalent of Int in excel (which
> returns the 210 part of 210.2342) and I don't know what how this is
> handled Chr(Num2Let & ( Int((L - 27) / 26) ) % 26 + 65);
>
> Thanks for any help.
>
>
> public string Num2Let(long L )
>
> {
>
> string s0, s1, S2, s3, final;
>
> /* if(L > 18278)
>
> s0 = Chr((Int((L - 18279) / 17576) % 26) + 65);
>
> if(L > 702)
>
> s1 = Chr((Int((L - 703) / 676) % 26) + 65);
>
> */
>
> if(L > 26)
>
> S2 = Chr(Num2Let(((L - 27) / 26)) % 26 + 65);
>
> //S2 = Chr(Num2Let & ( Int((L - 27) / 26) ) % 26 + 65);
>
> long x =(((L - 1) % 26) + 65);
>
> char c = (char)x;
>
> s3 = c.ToString();
>
> //final = s0 + s1 + S2 + s3;
>
> return s3;
>
> }
>
>

[D]

I haven't pushed it to the higher limits but so far it works good.

There is no particular reason why i use hex instead of decimals, it is
just
It looks cooler!

I worked with a guy who always wrote his if's in a similiar fashion although
not hex but put the number first like
this
if ( 1 < x )
versus
if ( x > 1 )
he said the reason was that it was a faster action in the cpu. I don't know
about that but it "sounded good to management."

Thanks again.

"Dennis Myrén" <de****@oslokb.no> wrote in message
news:eL*************@TK2MSFTNGP12.phx.gbl... So it works? Cool!
Have'nt really got the time to test it properly, just a few times with
small numbers.

There is no particular reason why i use hex instead of decimals, it is
just a matter
of preference, and maybe decimals would be clearer when posting code here.
--
Regards,
Dennis JD Myrén
Oslo Kodebureau
"D" <Da**@nothing.net> wrote in message
news:OG**************@TK2MSFTNGP15.phx.gbl...

BRILLIANT!!!!!

Works fine for me so far.

Can you tell me why you used hex (0x0 , 0x4766, etc)?

Thanks alot!!!
"Dennis Myrén" <de****@oslokb.no> wrote in message
news:e6**************@TK2MSFTNGP09.phx.gbl...

Try this one.
I needed one myself too. Cool!

Do not know if it works yet.

public static string CellIndexToName ( int index )
{
if (0x0 >= index)
return string.Empty;
StringBuilder sb = new StringBuilder(0x5);
if (0x4766 < index)
{
sb.Append((char) ((int) ((int) ((double) (((double) (index - 0x4767))
/ 17576)) % 0x1a) + 0x41));
}
if (0x2BE < index)
{
sb.Append((char) ((int) ((int) ((double) (((double) (index - 0x2bf))
/ 676)) % 0x1a) + 0x41));
}
if (0x1A < index)
{
sb.Append((char) ((int) ((int) ((double) (((double) (index - 0x1b)) /
26)) % 0x1a) + 0x41));
}
sb.Append((char) (int) (((index - 0x1) % 0x1A) + 0x41));
return sb.ToString();
}
--
Regards,
Dennis JD Myrén
Oslo Kodebureau
"D" <Da**@nothing.net> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...
I wish I could but I didn't write it. I found it when I was looking for
a function to convert numbers to excel like headers (AAA, AAB, AAC etc).

I'll post the solution if I figure it out.
"RCS" <rs****@gmail.com> wrote in message
news:Vu*****************@newssvr33.news.prodigy.co m...
> Man, you should make up a book of these and sell them at geek stores,
> you'd make a fortune!!
>
> If this doesn't get solved tonight, I'll give it a shot tomorrow -
> looks fun!!
>
>
> "D" <Da**@nothing.net> wrote in message
> news:%2***************@TK2MSFTNGP15.phx.gbl...
>>I am trying to do this in C#
>>
>> Function Num2Let(L As Long) As String
>> Dim s0 As String, s1 As String, S2 As String, s3 As String
>> If L > 18278 Then s0 = Chr((Int((L - 18279) / 17576) Mod 26) + 65)
>> If L > 702 Then s1 = Chr((Int((L - 703) / 676) Mod 26) + 65)
>> If L > 26 Then S2 = Chr(Num2Let & (Int((L - 27) / 26)) Mod 26 +
>> 65)
>> s3 = Chr(((L - 1) Mod 26) + 65)
>> Num2Let = s0 & s1 & S2 & s3
>> End Function
>>
>> it takes a long and converts it to the excel header format of AA, BQ
>> DS etc
>>
>> so far I have this, I commented out the top and worked my way up from
>> the bottom. I'm not sure what the c# equivalent of Int in excel
>> (which returns the 210 part of 210.2342) and I don't know what how
>> this is handled Chr(Num2Let & ( Int((L - 27) / 26) ) % 26 + 65);
>>
>> Thanks for any help.
>>
>>
>> public string Num2Let(long L )
>>
>> {
>>
>> string s0, s1, S2, s3, final;
>>
>> /* if(L > 18278)
>>
>> s0 = Chr((Int((L - 18279) / 17576) % 26) + 65);
>>
>> if(L > 702)
>>
>> s1 = Chr((Int((L - 703) / 676) % 26) + 65);
>>
>> */
>>
>> if(L > 26)
>>
>> S2 = Chr(Num2Let(((L - 27) / 26)) % 26 + 65);
>>
>> //S2 = Chr(Num2Let & ( Int((L - 27) / 26) ) % 26 + 65);
>>
>> long x =(((L - 1) % 26) + 65);
>>
>> char c = (char)x;
>>
>> s3 = c.ToString();
>>
>> //final = s0 + s1 + S2 + s3;
>>
>> return s3;
>>
>> }
>>
>>
>
>