All geek questions in one place

Create Dynamic Excel with Java

We predefined the structure of an Excel document with many formulas and macros.

When loading Excel through a Java application, we populate certain cells in Excel with data. After loading, when the user opens Excel , the macros and formulas built into it will read the previously filled data and behave accordingly.

We are now using ExtenXLS to create a Dynamic Excel document in Java. The processor-based license does not support Boxes with a dual-core processor. We are forced to buy more licenses.

Is there any better tool that we can look at, which is either free or a product, and the cost of support is minimal (support is needed), is the license simple?

+3
source share
3 answers

I really enjoyed using the Apache POI Project HSSF library ( http://poi.apache.org/ ) - it was pretty easy to use. I did not use it at such a depth, but it seemed pretty powerful. Also, there is JExcelAPI ( http://sourceforge.net/projects/jexcelapi/ ), which I have not used.

+12
source

Excel, XML . XML , .

+2

I am working on an open source project called XLLoop - this structure allows you to expose POJO functions as Excel functions.

So, instead of filling the excel sheet with data, you can create a function that loads the data and fills it in place.

+2
source

Source: https://habr.com/ru/post/1697364/

More articles:


All Articles