Export only some rows to excel

[jmaraisParticipant]

I want to use the exportdata function of the grid to export only a part of the grid. From the documentation I can gather:

var data = $("#jqxgrid").jqxGrid('exportdata', 'xls', 'filename.xls', true, null);

“The fourth parameter is optional and determines the array of rows to be exported.”

This is very unclear and I tried all variations I can can get up with to replace null, but no joy!

If I have, for example 300 rows in the array and I want to export only rows 1-150, or rows 151-300, what should I use in the place of null?

[ivailoParticipant]

Hi jmarais,

Here is a demo with export of the first 150 rows.

Best Regards,
Ivailo Ivanov

jQWidgets Team
http://www.jqwidgets.com

[jmaraisParticipant]

Thanks for the solution, it work perfect. Maybe you add your answer to your help file?

[Author]

Posts