Import data from xlsx into a rails app and export data to xlsx from a rails app

Upload xls, xlsx and csv files and import the data in rails models.

A gem for exporting activerecord data to XLSX files using the axlsx gem.

Chemotion LabIMotion

File package for the metacrunch ETL toolkit.

Library use by 9tq for import/export

Excelsior engine

provides ability to generate excel/xls/xlsx spreadsheets from your lisp code

Cdd is a pure-Ruby library that models the IEC Common Data Dictionary (IEC 61360 / CDD ontology), supports power-type semantics where instances can themselves be used as classes, and imports the Parcel Excel workbook format (both ParcelMaker .xlsx and the legacy 6-file .xls export layout) into a ...

Actionable Agile Metrics and Monte Carlo forecasting engine

Pry helpers

A Ruby gem that integrates seamlessly with Ruby on Rails to generate Excel reports using a simple DSL. Features include streaming, styling, callbacks, and Rails helpers.

Convert Rails database schema to Excel format with each table as a separate sheet in A5:SQL Mk-2 style. Usage: rails_schema_excel -i schema.rb -o out.xlsx

A simple report generator

Generate XLS files using ruby. Rubyxls provides a simple DSL to express anything from simple ruby strings to complex Active Record models. Support for multi-sheet workbooks, chart generation, and formula based cells included.

Load CSV/XLSX, check it, format it and spit it back to the user with a single command.

This gem should help reduce the efforts in the admin panel. It has search, sort and pagination included

Encrypt existing Excel files with Office Open XML password protection. .xlsx files are encrypted directly; .xls files are converted to .xlsx then encrypted.

import & export for active_record with simple_controller

Integrates Axlsx with Tilt