Wrox Home  
Search P2P Archive for: Go

  Return to Index  

pro_perl thread: ISSUE: Data from flat file to excel file


Message #1 by aberardo.castillo@d... on Tue, 12 Feb 2002 21:32:20
Hello Aberardo,

Yes, you can do this using Perl, we've done something similar here.

There's two ways of doing this using CPAN modules, fortunately someone else
has already done the hard work of figuring out Excel's file format. You can:

1. Use DBI by downloading the driver for Excel, called DBD::Excel (N.B.
You'll need to download and install DBI first, if you haven't already). This
allows you database-like access to an Excel spreadsheet.

2. Use Spreadsheet::WriteExcel to write an Excel file format.

The documentation with both these modules is pretty good and they should
install without any problems on most platforms.

Hope this helps.

Toodle Pip

Sam
----------------------------------------------------------------------
       Sam Michel - sam@c...

     Chinwag - http://www.chinwag.com
  ** effective email marketing & publishing **
----------------------------------------------------------------------


> Subject: ISSUE: Data from flat file to excel file
> From: aberardo.castillo@d...
> Date: Tue, 12 Feb 2002 21:32:20
>
> Hi everybody!
>
> I have the next doubt.
>
> Can I migrate information from flat files to MS Excel file using Perl?...
> Is this possible?...
> Could somebody give me some idea about it...
>
> I'll appreciate all comments.
>
> Best regards,
> Aberardo.


  Return to Index