Hi everyone,
I'm currently looking for a gem able to read/write XLS/XLSX files. I've
spent a lot of time on google and i found nothing fulfilling the above
criteria.
Anyone have an idea ?
Best regards,
Sébastien
Not an easy question.
In fact, there are SEVERAL questions:
1) extract rough data infromation (text/numbers) from Excel files
2) extract precise information (including formatting, charts and so on)
3) create Excel files from scratch
4) edit existing Excel files (open/change/save cycle)
That gives you 4. Then, you can multiply it by 2 (XLS vs XLSX) and you'll
receive approximate number of tasks you need to solve 
If it is not all 8
of them, your life is a bit easier.
Basically, (1), and some part of (2) -- read rough info -- is solved by
gems like roo or spreadsheet
If you need (2) -- full-featured reading, there is recent gem, released by
OnlyOffice: GitHub - ONLYOFFICE/ooxml_parser: Ruby OOXML Parser -- though, I haven't
checked it in real life.
Then, if you need (3) -- creating of files -- for XLSX there are axlsx
and write_xlsx. For XLS my best guess, from real-life experience is
RJB+JExcelApi.
And for (4) -- ...I really don't know. RJB+JExcelApi may work for you or
may not, as well as write_xlsx.
Finally, If you are on Windows, the things became 1000% easier and you can
just use Win23OLE module and do everything you want with your Excel files,
whilst you have MS Office installed.
Hope that helps.
Feel free to ask additional questions, I'm not an expert but have spent
significant amount of time on those matters.
V.
···
2016-06-14 18:42 GMT+03:00 Sébastien Puyet <sebastienpuyet@gmail.com>:
Hi everyone,
I'm currently looking for a gem able to read/write XLS/XLSX files. I've
spent a lot of time on google and i found nothing fulfilling the above
criteria.Anyone have an idea ?
Best regards,
Sébastien
Unsubscribe: <mailto:ruby-talk-request@ruby-lang.org?subject=unsubscribe>
<http://lists.ruby-lang.org/cgi-bin/mailman/options/ruby-talk>
Thinking through (thanks to you), what i really need is read/edit/create
XLSX files. Charts and formatting doesn't matter. The roo gem seems good
for my need.
Thanks for your time Victor !
Sébastien
···
2016-06-14 17:55 GMT+02:00 Victor Shepelev <zverok.offline@gmail.com>:
Not an easy question.
In fact, there are SEVERAL questions:
1) extract rough data infromation (text/numbers) from Excel files
2) extract precise information (including formatting, charts and so on)
3) create Excel files from scratch
4) edit existing Excel files (open/change/save cycle)That gives you 4. Then, you can multiply it by 2 (XLS vs XLSX) and you'll
receive approximate number of tasks you need to solve
of them, your life is a bit easier.Basically, (1), and some part of (2) -- read rough info -- is solved by
gems like roo or spreadsheet
If you need (2) -- full-featured reading, there is recent gem, released by
OnlyOffice: GitHub - ONLYOFFICE/ooxml_parser: Ruby OOXML Parser -- though, I
haven't checked it in real life.
Then, if you need (3) -- creating of files -- for XLSX there are axlsx
and write_xlsx. For XLS my best guess, from real-life experience is
RJB+JExcelApi.
And for (4) -- ...I really don't know. RJB+JExcelApi may work for you or
may not, as well as write_xlsx.Finally, If you are on Windows, the things became 1000% easier and you can
just use Win23OLE module and do everything you want with your Excel files,
whilst you have MS Office installed.Hope that helps.
Feel free to ask additional questions, I'm not an expert but have spent
significant amount of time on those matters.V.
2016-06-14 18:42 GMT+03:00 Sébastien Puyet <sebastienpuyet@gmail.com>:
Hi everyone,
I'm currently looking for a gem able to read/write XLS/XLSX files. I've
spent a lot of time on google and i found nothing fulfilling the above
criteria.Anyone have an idea ?
Best regards,
Sébastien
Unsubscribe: <mailto:ruby-talk-request@ruby-lang.org?subject=unsubscribe>
<http://lists.ruby-lang.org/cgi-bin/mailman/options/ruby-talk>Unsubscribe: <mailto:ruby-talk-request@ruby-lang.org?subject=unsubscribe>
<http://lists.ruby-lang.org/cgi-bin/mailman/options/ruby-talk>