From: "Wagner, David --- Senior Programmer Analyst --- CFS" <david.wag...@fedex.com>
> I have two files which are xml based and double clickable into Excel. > I would like to get the data into a CSV, but when I try to read using > > use Spreadsheet::ParseExcel; > > I get no ouput and no errors. I think you should get errors. Spreadsheet::ParseExcel was created to handle the binary .xls files. > I looked at XML::Simple and followed > the example they had but it generates several thousand lines. I do not know what does the XML look like, but you might be able to convince XML::Rules to skip the stuff you are not interested in and cormat the file to CSV as you go along. Without an example of the XML, there's little we can do. > The > processing occurs in the early AM and I am trying to tie together. I > know if I open in Excel and can do save as, but this is not automation > of the process. I have data from another stream and am trying to pull > in these two files to merge the data into one email verses three as > they are being handled now. You might also use Win32::OLE to start an invisible instance of Excel and tell it to open the files and save them as CSV. Jenda ===== je...@krynicky.cz === http://Jenda.Krynicky.cz ===== When it comes to wine, women and song, wizards are allowed to get drunk and croon as much as they like. -- Terry Pratchett in Sourcery -- To unsubscribe, e-mail: beginners-unsubscr...@perl.org For additional commands, e-mail: beginners-h...@perl.org http://learn.perl.org/
