a friend has a corrupt excel file. When you attempt to open it in excel it says "File format is not valid". None of the tricks here work.
The file is Excel 2003 format. She sometimes edits it on excel 2010, but still saves in 2003 format so it works on the home computer. There are no charts or formulas or anything fancy. Just a multi sheet workbook where she records movies, books, restuarants, etc along with variaous comments and stuff.
The data is still in the file. I can extract all the raw ascii looking strings with a perl script. But this has no table layout so is not as useful, gives us a worst case base.
Also using tools such as ExcelFix and Recovery for Excel show most of the data all lined up properly in rows and columns. But she can't really afford to fork out the $1-200 for these tools so we cannot save the data.
Does anyone know of good open source tools or other methods I could use to extract the data from this corrupt file in a meaningful way. Namely still in a table format.