Bonnie, If working with Perl is an option for you, there is a module you can use to parse xls files: http://search.cpan.org/~dmow/Spreadsheet-XLSX-0.13-withoutworldwriteables/lib/Spreadsheet/XLSX.pm
HTH Drew -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Barber, Bonnie Sent: Wednesday, August 04, 2010 2:13 PM To: [email protected] Cc: Ferguson, Gary Subject: [U2] tool for converting xls spreadsheets to txt files Is there a conversion tool or utility available for converting xls spreadsheets to txt files on a Universe system. We get sales and other files and have to manually open them and save them as txt files, then manually ftp them to a directory on our Unix AIX system before we can process them with our Universe applications. We would to have the system convert these for us so we could automate the processing of these files. Thanks, Bonnie Barber Perseus Distribution | Senior Programmer, J-Cispub 731-988-3135 Direct 800-343-4499 ext. 178 731-988-4452 Fax "Unus pro omnibus, omnes pro uno" _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
