Ben, I have been able to use Spreadsheet::ParseExcel with 2000 and XP XL files. I'm not an Excel expert but if I am not mistaken 2000 and XP use the same file structure. The complications might arise with XP 2003, or 97 files. A simple work around would be to open/close all spreadsheets with one version of Excel. For a definite answer I would recommend that you send an email to the modules author (I forget his name) but I found him to be pleasant and responsive when I was using the module and had questions.
Shaun -----Original Message----- From: Benjamin Walkenhorst [mailto:[EMAIL PROTECTED] Sent: Sunday, February 15, 2004 5:25 AM To: [EMAIL PROTECTED] Subject: Extract Data from Excel-files Hello everyone, Finally I get to use perl at work! =) I am to facing the following problem: There is a folder on a file-server in our network which contains 60 - 70 subfolders. Each of these subfolders contains a number of Excel-files (.xls) ranging from zero to maybe five. Each of these files again contains several worksheets, from which I am to extract certain cells (these are at fixed positions) and somehow put these to some nice output format (csv, html, maybe an SQL-database). As of now, I am more concerned about extracting the data. There is a module, Spreadsheet::ParseExcel, which I've tried out, and it seems to work. But the documentation says it can not handle all versions of excel. I am unsure what versions of Excel were used creating these files, probably Excel 2000 and XP. I'm going to try Spreadsheet::ParseExcel first, but if it does not work - what other ways to access Excel-files are there? What reasons could you think of to prefer one way over the other(s)? Thanks for your suggestions, kind regards, Benjamin -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response> -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
