Looking for a way to create a report. Long story...

26 views
Skip to first unread message

Pedro Santos

unread,
Jan 14, 2016, 10:25:11 AM1/14/16
to Ruby on Rails: Talk
Basically, I need to generate reports which contains more than 300 tables, over 100 charts and many images. Until now this was done manually in docx, so I was asked to build an RoR app where the user could add all the images and data, and with one button click get the report. Here is the problem. The user wants to be able to download the report, and be able to edit that file manually.
So I looked for gems. Many of them just fill spaces in docx files. At the moment I use axlsx to generate my charts, tables and images, everything is saved into excel file. It works pretty well. I was thinking if there is some kind of format that ruby can edit (insert tables, bar charts, styles...) and the same format could be opened in the office.... why ? because I could open the file and convert it to docx..
I am a little lost. My web app have database ready, just need some way of generating that file for the user. Any tips would be nice. I thought about html reports, but I cant edit them later, or can I ?
Thanks community.

Colin Law

unread,
Jan 14, 2016, 12:26:29 PM1/14/16
to Ruby on Rails: Talk
I believe LibreOffice can open html files, which could then be saved
as doc. I guess the MS equivalent can also do that, but I don't know.
Easy enough to try it.

Colin

Pedro Santos

unread,
Jan 14, 2016, 2:10:27 PM1/14/16
to Ruby on Rails: Talk
Actually LibreOffice don't save html file in doc format. =/

Colin Law

unread,
Jan 14, 2016, 4:18:17 PM1/14/16
to Ruby on Rails: Talk
On 14 January 2016 at 19:10, Pedro Santos <columb...@gmail.com> wrote:
> Actually LibreOffice don't save html file in doc format. =/

Mine does (5.0.2.2 and I am confident it has for all the versions I
have used over a number of years). One of the format options when
saving is "Microsoft Word 97-2003(.doc)". I have just checked by
opening an html file then using File > Save As to save it.

Colin

>>
>>
>> I believe LibreOffice can open html files, which could then be saved
>> as doc. I guess the MS equivalent can also do that, but I don't know.
>> Easy enough to try it.
>>
>> Colin
>
> --
> You received this message because you are subscribed to the Google Groups
> "Ruby on Rails: Talk" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to rubyonrails-ta...@googlegroups.com.
> To post to this group, send email to rubyonra...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/rubyonrails-talk/cbed8cd0-4c5c-456d-9bf6-38a3b1c856f0%40googlegroups.com.
>
> For more options, visit https://groups.google.com/d/optout.
Reply all
Reply to author
Forward
0 new messages