There is a perl module (xls2csv) that might accomplish what you want. I have not used it, but it looks like it would work. The only part that might give it fits is if there are any formulas.
George > -----Original Message----- > From: [email protected] [mailto:u2-users- > [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
