From: bbiker <renard@...>
Date: 2007-11-02T09:45:32+09:00
Subject: Re: Number to alpha letter

On Nov 1, 1:39 pm, ghotr...@yahoo.com wrote:
> Daniel Waite wrote:
> > 65.chr # 'A'
>
> Thanks Daniel.  I can make this work for me.
>
> Parv
> --
> Posted viahttp://www.ruby-forum.com/.

Are you on Windows? .. it is fairly easy to copy the contents on an
array to an Excel using win32ole.

An alternate method, change the array into in a csv file either with a
script or with csv/fastercsv. You can then open the file with Excel.

There's also a gem 'roo' which can create and write an excel sheet on
any platform.  My understanding is that it does not support formulas,
however this does not seem to be your requirement.

By the way, I don't understand why you need to transform numbers to
characters in order to copy an array to an excel sheet.

If by chance, you want to change numeric column notation to alpha
column notation, then I have a ruby methods that do the conversions...
num2alpha and alpha2num. You can also use numeric notation (RC) as
well as alpha notation.

In Excel, rows and columns are 1-based, not 0-based as in an array.
This can be a gotcha!

Let me know if this is what you need?  either on line or off line.

renard@nc.rr.com