2

I opened an existing excel file using Roo::Excel. I was also able to modify the content. The problem is I don't know how to save it. Is Roo:Excel only meant for reading? If not, how do I save the changes?

Wand Maker
  • 18,476
  • 8
  • 53
  • 87
Catherine
  • 95
  • 1
  • 10

1 Answers1

1

Documentation says

Roo implements read access for all common spreadsheet types.

Closest to saving, it has export to CSV, sheet.to_csv, that may not work if you want to save as excel.

You may want to look at Which gem support Import/Export to xlsx file in ruby for alternatives.

Community
  • 1
  • 1
Wand Maker
  • 18,476
  • 8
  • 53
  • 87