search

roo-rb / roo

Roo provides an interface to spreadsheets of several sorts.
MIT License
2.78k stars 501 forks source link

Workaround needed for: open html-as-xls file #572

Open estani opened 2 years ago

estani commented 2 years ago

Apparently any html with table can be renamed as "xls" and it will be open in excel directly. Sadly, this seem to be spread in the community as a "simple way" of creating xls files. So now there are well known system exporting data in this manner.

While trying to read the data, this seems impossible. The only solution is to request the sender, to open the file in excel and save it again (or google sheet, or libreoffice, etc). Apparently all programs already know about this and programmed around the bug.

Is there any way to somehow convert those files (simple html with a table with in) to excel in ruby?

Andrew-Max commented 1 year ago

Have this same issue @estani did you ever figure this out?