RubyGems Navigation menu

excel_to_code 0.3.17

# excel_to_code Converts some excel spreadsheets (.xlsx, not .xls) into some other programming languages (currently ruby or c). This allows the excel spreadsheets to be run programatically, without excel. Its cannonical source is at http://github.com/tamc/excel_to_code # Running excel_to_code To just have a go: ./bin/excel_to_c <excel_file_name> NB:For small spreadsheets this will take a minute or so. For large spreadsheets it is best to run it overnight. for more detail: ./bin/excel_to_c --compile --run-tests --settable <name of input worksheet> --prune-except <name of output worksheet> <excel file name> this should work: ./bin/excel_to_c --help # Testing excel_to_code 1. Make sure you have ruby 1.9.2 or later installed 2. gem install bundler # May need to use sudo 3. bundle 4. rspec spec/* To test the C runtime: 1. cd src/compile/c 2. cc excel_to_c_runtime 3. ./a.out # Hacking excel_to_code There are some how to guides in the doc folder. # Limitations 1. Not tested at all on Windows 2. INDIRECT and OFFSET formula must be convertable at runtime into a standard formula 3. Doesn't implement all functions (see doc/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. 90. Ranges like this: Sheet1!A10:Sheet1!B20 and 3D ranges don't work

Versions:

  1. 0.3.17 - May 14, 2015 (205 KB)
  2. 0.3.16 - May 12, 2015 (203 KB)
  3. 0.3.15 - March 10, 2015 (198 KB)
  4. 0.3.14 - March 10, 2015 (198 KB)
  5. 0.3.13 - March 2, 2015 (198 KB)
Show all versions (74 total)

Authors:

  • Thomas Counsell, Green on Black Ltd

Owners:

138c3122c29a55bd81aedbdabf8dbf3d

Sha 256 checksum:

d27fb55f0960ddc4abdcd0e88bbfbdc40f5b66ad81d57a84b0824b2c2b6eac63

Total downloads 50,547

For this version 137

Show all versions (74 total)

Required Ruby Version: >= 1.9.1

Licenses:

MIT

Gemfile:
= Copy to clipboard Copied!

install:
= Copy to clipboard Copied!

Links: