store spreadsheet data in a sqilte db

the spreadsheet files are not reopened when reading them again

cache reads from spreadsheet files in a sqilte db

SunRiseSet is a ruby class calculates the times of the sunrise, solar noon and sunset. It also calculates astronomical, naval and civil twilight times. Not sure of the origin of the algorithm. I have seen a fortran version http://www.srrb.noaa.gov/highlights/sunrise/program.txt a .pl www.mso.anu.edu.au/~brian/grbs/astrosubs.pl and .vb versions for spreadsheets too. All had the same comments, so are of a common origin.

A tool for loading spreadsheet data into ruby objects

Timeless comes with a pomodoro timer, with a standard stopwatch (start, top), semantic tags in notes (projects, clients, activites), and reporting and exporting command. Data is stored in csv and it can be easily imported into a spreadsheet.

A Google Spreadsheet/Excel -> YAML -> Ruby Migration Tool

View spreadsheet files in a text-console.

WebGet spreadsheet_import_export_helpers gem: parsers and prettifiers for spreadsheets

This is a command line utility that takes a local CSV file, creates a new Google Sheet spreadsheet, and then povides a web link to the newly created Google Sheet spreadsheet.

Soroban makes it easy to extract and execute formulas from Excel spreadsheets. It rewrites Excel formulas as Ruby expressions, and allows you to bind named variables to spreadsheet cells to easily manipulate inputs and capture outputs.

A gem to help you convert your google spreadsheet data to json format and load your json to spreadsheet. With this gem, you can choose the worksheet that you want to convert and point the row number you want to convert!

OpenOffice.org oocalc: Fast automated batch-processing of spreadsheets (*.ods) conforming to Open Document Format v1.1. used by e.g. OpenOffice.org and LibreOffice. Please see screenshot and Rdoc-Documentation at http://ruby.homelinux.com/ruby/rods/. You can contact me at rods.ruby@online.de (and tell me about your experiences or drop me a line, if you like it ;-)

Tools using roo to performa actions on multiple spreadsheets

Library to convert spreadsheets, microsoft xl, csv like documents to json

Bring CSVs to live! This gem introduces CSVs as spreadsheets and comes with some database-like features.

Spreadsheet ERB Template for Reports