excel_to_code was created to parse the content of .xlsx files and export their content into other programming mediums.
This allows developers to execute Excel formulas and process the spreadsheet's data without actually having Excel installed.
After the calculations have been finished and cells have been modified, the result can then be printed back to a .xlsx file and saved.
For now, only Ruby and C environments are supported.
excel_to_code can be used for creating Web-based datagrids, running a basic calculations engine online, or for providing Excel-related help on the Web.
What is new in this release:
- Fixed a bug in VLOOKUP when the lookup value is an empty cell.
What is new in version 0.3.15:
- Fixed a bug in VLOOKUP when the lookup value is an empty cell.
What is new in version 0.2.26:
- When pruning cells, now checks for circular references
- Added a better error message if expanding array formula fails
- Now doesn't mistakenly inline sheet specific named references
- Made the array formula expansion more robust to mismatched array sizes
What is new in version 0.2.16:
- Fixed bug in response when LEFT and RIGHT are passed negative values
- Implemented LEN function in C runtime
- Implemented RIGHT function in C runtime
- Inline blanks are treated as empty strings in MID and RIGHT functions
- Fixed a bug in bounds checking when replacing arithmetic on ranges
- Replace comparisons on arrays with arrays of comparisons
- Ruby version of RIGHT now returns a string if index out of bounds
- Removed the special case optimization of the COUNT function. It wasn't right in some cases
What is new in version 0.2.3:
- Implemented the LOWER function in Ruby.
- Removed the run_in_memory option, it no longer does anything.
- Removed the intermediate_directory option, the code no longer needs to write intermediate files.
What is new in version 0.1.18:
- Implemented the CONCATENATE() function.
What is new in version 0.1.11:
- Inline strings now have newlines stripped to be consistent with shared strings (it would be better if they were stripped in neither)
- INDEX now returns zero, not blank, when pointing to an empty cell
- If a range points to a single cell, then that is used rather than a range
- Fixed a bug where a nested sum would return 0 rather than an error in C code
- Implementing the HLOOKUP function
What is new in version 0.1.6:
- named_references_to_keep can now be set to as :all to create getters for all named references.
- named_references_that_can_be_set_at_runtime can now be set to :where_possible to create setters for named references that point to settable cells.
What is new in version 0.1.2:
- Updated the way that command tests are run.
- Merged energynumbers memory freeing code.
What is new in version 0.1.0:
- C version now generates a Shim class that automatically translates between ruby values and excel values.
What is new in version 0.0.12:
- By default, the generated tests for the generated code are more relaxed about how closely numbers match.
- Command line option to generate tests that require an exact match.
Requirements:
- Ruby 1.9.2 or higher
Comments not found