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

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

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

import & export for active_record with simple_controller

Integrates Axlsx with Tilt

CMS for weby.lv projects.

No need to write logic to generate xls simply pass data and header and get your xls