[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

comp.lang.ruby

Re: Importing from text file to Excel

Li Chen

12/15/2006 4:40:00 PM


--- anon1m0us <anon1m0us@yahoo.com> wrote:

> Hi;
> Below is my code to import from a text file to
> EXCEL. I am encountering
> a few issues.
> 1) the import file is larger than 65,536 which is
> the max Excel can
> have as an input. The file is broken in to two
> files. However, I would
> like to create files based on the alphabit. For
> example, All last name
> from A-J is in one file, and the file should be
> names A-J. The second
> should be from J-W and thrid X-Z.

Use regular expression to get your data into (an)
array(s), sort them, then import into excel

Li


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail...