in reply to Excel - usable format
If this is a one-shot conversion, you can manually save each sheet as a CSV (comma-separated value) file, then process them either directly or via File::CSV.
If this is something you'll be doing frequently, consult OLE - Getting all rows from Excel for some example code that'll get you 95% of the way there.
|
|---|