LightCellsDataProvider to write multiple worksheets and pivots

[sukesh.kotian]

Hi Team,

How do i use implementation of LightCellsDataProvider to write data to multiple worksheets and create pivot to those worksheets(next to their respective data sheet) using java?

[shakeel.faiz]

@sukesh.kotian

Thanks for considering Aspose APIs.

First populate your worksheet with your data using the LightCells API. For that purpose, please see this article.

• Using LightCells API

Once, you have populated your worksheet(s) with data then create your pivot table. Please see this post in your other thread. It contains the sample code (and screenshot) that explains how you can create your desired pivot table.

Pivot creation issue

@sukesh.kotian Please see the following sample code in Java and C#. The code creates your desired pivot table as shown in the following screenshot. Please download the output Excel file generated by the code and read the comments inside the code for more help. Download Link: Output Pivot Table Excel File–1.zip (203.1 KB) Java //Load the source Excel file Workbook wb = new Workbook(dirPath + "TEST.xlsx"); //Add a new worksheet Worksheet ws = wb.getWorksheets().add("TestSheet"); //Activate …