On Fri, 2002-07-12 at 00:52, dannyqchen wrote: > Hi, > I am working on Sun Unix system. I want to use Perl to do the following tasks: > > 1) Automatically detect the new spreadsheet files (from StarOffice, could be in .csv >format) in a specified directory. > 2) Locate a specified column in the spreadsheet. > 3) Extract the column, clean it, and save them into a speficifed file. > > Do you know any free source code, in perl, that could be used to fulfil part of >these tasks? > > Thanks a lot, > > Chen
A quick search on CPAN (www.cpan.org) Turns up these modules: For working with MS Excel spreadsheets Spreadsheet::ParseExcel Spreadsheet::ParseExcel::Simple For working with CSV files Text::CSV Text::CSV::XS AnyData::Format::CSV For Working with Open Office/Star Office spreadsheets (they are a collection of zip'ed XML files) Archive::Zip XML::Parser -- Today is Pungenday the 47th day of Confusion in the YOLD 3168 Wibble. Missile Address: 33:48:3.521N 84:23:34.786W -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
