Pivot table generataion using lightcellData Provider

Aspose.Cells Product Family
1

hi

how to create pivot table using sheet.
which is generated using LighCellDataProvider.

We get error

could you show some examples on LightCellDataProvider

Thanks & Regards

Ranjith.

2

Hi,

Thanks for your question.

We have forwarded your query and logged it as CELLSJAVA-26713. We will update you asap.

3

hi

Any update on this?

Thanks & Regards
Ranjith

4

Hi,

For your question relating to

Create pivot table with LightCellsDataProvider

LightCellsDataProvider is used to save cell data to the resultant excel file without keeping it in workbook’s data model in memory. For pivot table, you must create it before calling Workbook.save() method. However, to make the generated pivottable works fine, cells data of all PivotFields except Data field must be filled into inner model before creating the pivot table.

For example, to create a pivottable with cell range A1:D100, A1:D1 and A1:A100 is for ROW/COLUMN field and B2:D100 is for DATA field, then at least cells of A1:D1 and A1:A100 should be filled into the actual data before creating the pivottable. Cells data of B2:D100 can be left empty, in the save() method it can be saved directly to resultant excel file by LightCellsDataProivder.


5

hi

Thanks for your response.

we generated pivot table using LightCellDataProvider.

at first we add the ROW/COLUMN fields to the sheet.

but this one works only for rows less than 65535.

if the rows are more than 65535.

it throws illegalargumentexception
unknown area: pivot String “=Data!A1:U86441”.

Thanks & Regards

Ranjith.








6

Hi,

By
default for a newly created Workbook without loading data from template
file, its file format type is EXCEL97TO2003. To use row/column exceeds
limit of xls files, please set workbook’s file format type as XLSX first
before using cell references.

Are you sure you want to delete ?
                        <br>
7

hi
thanks
it is working.

could u please tell how light cell data provider is working.

Thanks & Regards

Ranjith.






8

Hi,

Well, LightCellsDataProvider is used to provide cells data when saving workbook. By implementing methods in this interface, user can direct the writer which is the next row/cell to be saved in file, and provide (set) its properties such as styles, values for the writer to save it directly to the destination(file or stream). The row/cell object and its contents will not hold in memory after writing it to the file or stream, so there will be no large number of Row/Cell object exist in memory even for creating a large excel file with many cells.

9

The issues you have found earlier (filed as ) have been fixed in this update. This message was posted using BugNotificationTool from Downloads module by MuzammilKhan