jbaliuka / x4j-analytic Goto Github PK

Dear jpaliuka,

I'm trying to construct a pivot table out of a flat table that has more than 1,048,576 records. The excel has this limit for the number of rows. Any idea for a workaround?

Thanks in advance.

Is it really an open source project?

Dear jbaliuka,

The "PivotReport.xlsx" sample provided in the samples folder works fine and I can open the output file in Excel (Office 2013) without any problem.

But, when I open the sample xlsx template file with Excel (Office 2013) and then I save it, and then I run the samples again, and then I try to open the output file in Excel (Office 2013), I get the following error message:

Removed Part: Part /xl/pivotCache/pivotCacheDefinition1.xml. (Dynamic table cache)
Removed Feature: Dynamic table report of part /xl/pivotTables/pivotTable1.xml (Dynamic Table View)

¿How did you create the PivotReport.xlsx template? ¿What office version did you use?

Thanks in advance.

Hi, Readme sounds very interesting. It's this project alive as the last commit is a year back? Thanks

Dear jpaliuka,

I was wondering if you can provide an example for an xml template to export data in xml. You provided only templates for excel.

Thanks in advance.

Using a template made with Microsoft 365 online excel, I get NullPointerException in com.exigeninsurance.x4j.analytic.xlsx.transform.xlsx.XLSXProcessor.translateSheetName .
Using the same template saved with excel desktop application, it works correctly.

Steps to reproduce:

1. Make a template using online excel of Microsoft 365
2. Fill it using the library
3. The error appears
4. Optional, save a copy of the file using excel desktop application, the error doesn't appear

Cannot send examples because I'm not the owner of the file and are sensitive data used by the customer framework

Is this in a Maven public repo? I was unable to get it for me to try it.

If there's one, it's definitively missing from the documentation.

Dear Juozas,

Does the PDF format support an inline image from template. I can make it work quite well with Excel (Sometimes size is a problem, but I find a workaround). But I just don't see the image in PDF output at all.

Best Wishes,
Isaac