integer to string

Thread view:

Jamie Allison - 28 Jul 2006 12:28 GMT

Hi There,

I want to convert an integer number to a string equivalent for Excel such
that

0 = A,
1 = B,
26=AA,
27=AB,
255=IV,

Anyone any ideas how to do this?

I have it working for A to Z using:

char c = (char) (column + 65);

But once it gets over Z i need to work out how to put them in double
letters.

Thanks in advance.

Jamie

Reply to this Message

Oliver Wong - 28 Jul 2006 15:19 GMT

> Hi There,
>
> I want to convert an integer number to a string equivalent for Excel such
> that

Crosspost, don't multipost:
http://www.cs.tut.fi/~jkorpela/usenet/xpost.html

I answered your question on another newsgroup.

- Oliver

Reply to this Message

Choder Hongwel - 28 Jul 2006 18:08 GMT

>> Hi There,
>>
[quoted text clipped - 3 lines]
> Crosspost, don't multipost:
>http://www.cs.tut.fi/~jkorpela/usenet/xpost.html

"It is considered highly inappropriate to broadcast your message to a
wide selection of newsgroups merely to have more people read it. Note
also that many people automatically ignore articles posted to more
than two or three groups."

Hehehe!! The first sentence almost tempts the reader to do it just
out of spite. The second sentence provides a good argument for doing
exactly what you're hoping to discourage the poster from doing here
(multi-posting rather than crossposting).

I'm not disagreeing with you here Wong, I just find netcopping funny
in general. Makes me giggle and want to piss me self.

Reply to this Message

Oliver Wong - 28 Jul 2006 19:47 GMT

>>> Hi There,
>>>
[quoted text clipped - 17 lines]
> I'm not disagreeing with you here Wong, I just find netcopping funny
> in general. Makes me giggle and want to piss me self.

The page actually makes an appeal to the laziness of the poster:

<quote>
Crossposting is easier than sending separate postings. You don't really need
any other reason.
</quote>

IOW, why should I crosspost instead of multipost? 'Cause it takes less
effort to crosspost.

- Oliver

Reply to this Message

Choder Hongwel - 28 Jul 2006 19:54 GMT

>>>> Hi There,
>>>>
[quoted text clipped - 19 lines]
>
> The page actually makes an appeal to the laziness of the poster:

Which in itself is an admirable strategy, but is based in the
assumption that the user not only wants to widen their audience but is
willing to make tradeoffs of effort resultng in a smaller audience.

Reply to this Message

integer to string

Free Magazines