PivoteGrid - Export data

[juancitop]

Is posible export to excel ?

Thanks in advance.

[jega]

Is there any help for this ??

I need it too ;-)

Regards
Jesper

[jarry]

The 'toExcel' method is available. Please download a newer version from https://www.jeasyui.com/extension/pivotgrid.php

[jega]

Hi Jarry.

Thanks.

But there is an error. Excel sheet contains double rows

See attachment.

And how to only have selected rows to excel ?

[jarry]

Please download a newer version from https://www.jeasyui.com/extension/pivotgrid.php
To export the selected rows, please try this code.

Code:

var rows = $('#pg').pivotgrid('getSelections')
$('#pg').pivotgrid('toExcel', {
  filename: 'test.xls',
  rows: rows
})

[jega]

Hi Jarry

Using the latest version 1.0.2. Checked that it not is using file from cache.

Same error. exports double rows

Selected rows also exports all rows, and double.

[jarry]

Please make sure the 'rows' passed to the 'toExcel' method is not empty.

Code:

$('#pg').pivotgrid('toExcel', {
  filename: 'test.xls',
  rows: rows
})

[juancitop]

Hi Jarry, thanks for adding export method.
I'm having the same problem, the duplicated values when export, but the same occurs at Totals...

I´m exporting all rows:

Code:

$('#pg').pivotgrid('toExcel', {
				filename: 'pivotgrid.xls',
				worksheet: 'Worksheet',
				caption: 'Caption'
			});

[jarry]

This issue has been fixed. Please download a newer version from https://www.jeasyui.com/extension/pivotgrid.php

[juancitop]

Thanks jarry !!!

There is a problem that persist, please see attached img.

[jega]

Hi Jarry.

Now it works. No double rows

Using this var rows = $('#pg').pivotgrid('getSelections') always take all rows

Changed it to getCheckedNodes and it exports only selected rows. If no rows selected it export all

Maybe you can answer this. Filename = pg.xls

When open exported file in excel, it says

"the file format and file extension of pg.xls do not match. File can be corrupted or......."

I can just push the YES button to open it, and everything is fine


Jesper