A convenient library to convert google spreadSheet to array
Google Sheets API -- simple interface to read/write data and manage sheets
Simple, customizable yet performant spreadsheet for React
Convert Google Spreadsheets to JSON using Javascript
A Complete Microsoft Excel-like JavaScript Spreadsheet for Enterprise Applications
Feature-rich JavaScript Spreadsheet (Excel) control with built-in support for selection, editing, formatting, importing and exporting to Excel
Secure your data exports - encrypt and password protect sensitive CSV and XLSX files
Simple data set export to Excel xlsx file
SheetJS Spreadsheet data parser and writer
Jspreadsheet is a lightweight, vanilla javascript plugin to create amazing web-based interactive data grids with spreadsheet like controls compatible with Excel, Google Spreadsheets and any other spreadsheet software.
Handsontable is a JavaScript Data Grid available for React, Angular and Vue.
Read `.xlsx` files in a web browser or in Node.js
Array manipulation, ordering, searching, summarizing, etc.
HyperFormula is a JavaScript engine for efficient processing of spreadsheet-like data and formulas
Feature-rich JavaScript Spreadsheet (Excel) control with built-in support for selection, editing, formatting, importing and exporting to Excel for React
Format data using ECMA-376 spreadsheet Format Codes
SheetJS Spreadsheet data parser and writer
SpreadJS Designer Component present as a control that could be embedded into your web application easily, and also provided flexible, customizable configuration to achieve your business logic.
Full Excel style number formatting
Feature-rich JavaScript Spreadsheet (Excel) control with built-in support for selection, editing, formatting, importing and exporting to Excel for Angular
Excel Workbook Manager - Read and Write xlsx and csv Files.
React spreadsheet import for xlsx and csv files with column matching and validation
A Spreadsheet Component for Angular
Spreadsheet language support for CodeMirror
A library for manipulating tables as arrays
copy and paste between ruby arrays in irb/rails console and a spreadsheet (tab delimited) and vise versa. Based on irbcp by Ara T. Howard
This module implement [to_spreadsheet | xls] to ActiveRecord::Relation
Work with spreadsheets easily in a native ruby format.
Convert an Array where Array.all? {|e| [OpenStruct,Hash,ActiveRecord::Base].any? { |type| e.kind_of?(type) }} to a Google spreadsheet
Transforming a dataset or array of hashes into a spreadsheet-style array
Transform an Array or Hash into a excel file using the spreadsheet gem.
A library for storing data about an object in spreadsheet-like format (array of hashes).
Makes it easy to import spreadsheets. Handles .csv and .xlsx formats as well as raw 2D arrays
# Excel to Code [](https://travis-ci.org/tamc/excel_to_code) excel_to_c - roughly translate some Excel files into C. excel_to_ruby - roughly translate some Excel files into Ruby. This allows spreadsheets to be: 1. Embedded in other programs, such as web servers, or optimisers 2. Without depending on any Microsoft code For example, running [these commands](examples/simple/compile.sh) turns [this spreadsheet](examples/simple/simple.xlsx) into [this Ruby code](examples/simple/ruby/simple.rb) or [this C code](examples/simple/c/simple.c). # Install Requires Ruby. Install by: gem install excel_to_code # Run To just have a go: excel_to_c <excel_file_name> This will produce a file called excelspreadsheet.c For a more complex spreadsheet: excel_to_c --compile --run-tests --settable <name of input worksheet> --prune-except <name of output worksheet> <excel file name> See the full list of options: excel_to_c --help # Gotchas, limitations and bugs 0. No custom functions, no macros for generating results 1. Results are cached. So you must call reset(), then set values, then read values. 2. It must be possible to replace INDIRECT and OFFSET formula with standard references at compile time (e.g., INDIRECT("A"&"1") is fine, INDIRECT(userInput&"3") is not. 3. Doesn't implement all functions. [See which functions are implemented](docs/Which_functions_are_implemented.md). 4. Doesn't implement references that involve range unions and lists (but does implement standard ranges) 5. Sometimes gives cells as being empty, when excel would give the cell as having a numeric value of zero 6. The generated C version does not multithread and will give bad results if you try. 7. The generated code uses floating point, rather than fully precise arithmetic, so results can differ slightly. 8. The generated code uses the sprintf approach to rounding (even-odd) rather than excel's 0.5 rounds away from zero. 9. Ranges like this: Sheet1!A10:Sheet1!B20 and 3D ranges don't work. Report bugs: <https://github.com/tamc/excel_to_code/issues> # Changelog See [Changes](CHANGES.md). # License See [License](LICENSE.md) # Hacking Source code: <https://github.com/tamc/excel_to_code> Documentation: * [Installing from source](docs/installing_from_source.md) * [Structure of this project](docs/structure_of_this_project.md) * [How does the calculation work](docs/how_does_the_calculation_work.md) * [How to fix parsing errors](docs/How_to_fix_parsing_errors.md) * [How to implement a new Excel function](docs/How_to_add_a_missing_function.md) Some notes on how Excel works under the hood: * [The Excel file structure](docs/implementation/excel_file_structure.md) * [Relationships](docs/implementation/relationships.md) * [Workbooks](docs/implementation/workbook.md) * [Worksheets](docs/implementation/worksheets.md) * [Cells](docs/implementation/cell.md) * [Tables](docs/implementation/tables.md) * [Shared Strings](docs/implementation/shared_strings.md) * [Array formulae](docs/implementation/array_formulae.md)