excel_to_code

excel_to_code copied to clipboard

I want to use the tamc excel_to_code to convert an .xlsm file to code but as clean as my excel workbook is, it keeps bringing a _xlfn.SINGLE error when I...

Alvin-igobwa

Merge Karnov Group's excel-to-code with upstream excel_to_code

1

Adding support for resetting individual sheets Various changes related to named references Changes for references optimized away (zero/nil) Prevent unbounded recursion for hlookup's in same region

andreasDalsgaard

I tried running ``excel_to_ruby`` on a fresh install of Ubuntu 20.0.4 LTS, after installing ruby and bundler, and got the following error: ```$ ruby translate_excel_into_c.rb 09:53 Excel to Code version...

tur-ium

Updates the requirements on [rake](https://github.com/ruby/rake) to permit the latest version. Changelog *Sourced from [rake's changelog](https://github.com/ruby/rake/blob/master/History.rdoc).* > === 13.0.1 > > ==== Bug fixes > > * Fixed bug: Reenabled task...

dependabot[bot]

Implemented EXP, INT, and MONTH functions

2

Wrote test and implementation for the following Excel functions EXP INT MONTH

rankin

e.g.: 'G.20 (data)'!Q1149:'G.20 (data)'!Q

tamc

e.g., SUM(10:10 C:C) Should be equivalent to SUM(C10)

tamc

ExcelToC Should transform ExampleSpreadsheet.xlsx into the desired c code ``` Failure: test_ranges_c3(TestExampleSpreadsheet [/Users/tamc/Documents/github/excel_to_code/spec/commands/excel_to_X_output_actual/c/test_examplespreadsheet.rb:46]: expected but was . ``` ExcelToRuby Should transform ExampleSpreadsheet.xlsx into the desired ruby code ``` test_ranges_c3(TestExampleSpreadsheet [/Users/tamc/Documents/github/excel_to_code/spec/commands/excel_to_X_output_actual/c/test_examplespreadsheet.rb:46]:...

tamc

Any chance of parallelising this?

2

I haven't tried myself yet, but wanted to check whether you'd tried parallelising some of the code, to speed it up on multi-processor machines. I'm already using `command.run_in_memory = true`,...

energynumbers

Freeing memory is very slow

1

With the 2050 pathway calculator example: calculating the pathway takes about 40ms. The reset method that frees allocated memory increases this to 120ms.

tamc