On Fri, Jun 25, 2010 at 16:50, Zak B. Elep <[email protected]> wrote: > On Fri, Jun 25, 2010 at 1:30 PM, Ludwig Isaac Lim <[email protected]> wrote: >> Hi: >> >> I'm writing a CGI application in PERL running on HP-UX that needs to >> export >> its query results to an Excel file. >> >> My alternatives are : >> a) export it using perl module Text::CSV, but the set the CGI headers >> to >> Excel via print header(-type => 'application/vnd.ms-excel'); >> b) Use Spreadsheet::WriteExcel to generate excel binary files. >> >> I'm inclined to use method "A" as I've used Text::CSV before, and I see >> that >> Spreadsheet::WriteExcel is dependent on module Win32::OLE (Not sure if >> Win32::OLE will work HP-UX or UNIX / Linux systems). >> >> Thoughts? Anybody here that used Perl CGI and Excel before? Thanks in >> advance > > Task::Kensho[0] lists several modules for Excel parsing (here's a list > straight out of its Makefile.PL): > > feature 'Excel / CSV', > -default => 0, > 'Text::CSV_XS' => 0, > 'Spreadsheet::ParseExcel::Simple' => 0, > 'Spreadsheet::WriteExcel::Simple' => 0, > ;
These may not be available in HP-UX, though. -- Ian Dexter R. Marquez http://feeds.iandexter.net/Coredump _________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List http://lists.linux.org.ph/mailman/listinfo/plug Searchable Archives: http://archives.free.net.ph
