Ruby merging two excel files


#1

Hi! Every one! Could any one help me please! I need example of Ruby code
how to open and merge two excel files and create new excel file from
those two without duplications inside. Thank you very much for the help!


#2

Have a look at

https://github.com/tomiacannondale/wrap_excel
(Windows only)

and

https://github.com/zdavatz/spreadsheet

As for merging two files, you would have to load both files and then
write the data to one spreadsheet, depending on what you mean by
‘merge’.

https://github.com/weshatheleopard/rubyXL
supports .xlsx and .xlsm excel spreadsheets and looks like the best
option to me. The readme contains some code snippets.