This gem allows very efficient writing of CSV style data to XLSX with multiple worksheets.

a module for streaming dynamically generated zip files

Calcsheet reads and writes CSV, XLSX and ODS spreadsheets as streams of rows, with typed cells, configurable limits and no dependency on Rails.

Especially useful if your document is very, very large.