IronCalc – Open-Source Spreadsheet Engine

Re:IronCalc – Open-Source Spreadsheet Engine by yowlingcat on Saturday November 09, 2024 @06:44PM (#42097616)

Very cool library. I like the goal of Excel support (it truly is an incredible platform). A couple of questions:

1) Any plans for programmatic manipulation of pivot tables? Looking across the Python ecosystem, outside of xlwings (which essentially requires FFI manipulation of a running instance of Excel), nothing else makes it possible. It does look like some .NET Excel libraries support it.

2) Will there be ability to use the engine as library? Would love to use something like this through Python bindings.

[ Parent | on HN ]

Re:IronCalc – Open-Source Spreadsheet Engine by nhatcher on Sunday November 10, 2024 @06:43AM (#42099694)

> 1) Any plans for programmatic manipulation of pivot tables?

As soon as we possibly can

2) Will there be ability to use the engine as library? Would love to use something like this through Python bindings.

That is in place already! It is an MVP, so I haven't published all packages for all architectures but you can compile it from source:

https://github.com/ironcalc/IronCalc/tree/main/bindings/pyth...

https://pypi.org/project/ironcalc/

[ Parent | on HN ]