Parsing XLS and XLSX (MS Excel) files with Ruby?

Question

Hi.

Are there any gems able to parse XLS and XLSX files? I've found Spreadsheet and ParseExcel, but they both don't understand XLSX format :( Any ideas?

Thank you.

Answer 1

I don't know of any ruby modules capable of parsing XLXS. You might just want to do it yourself. An XLSX file is simply a zip file containing XML documents. Unzip it and take a look, it's pretty easy to parse through.

Answer 2

Just found roo, that might do the job - works for my requirements, reading a basic spreadsheet.