Export Grid with row details

[jon74Participant]

Hi all,
I am trying to understand if it is possible to export (HTML and Excel especially) my grid content, rowdetails included.

Thanks in advance

Jonathan

[Peter StoevKeymaster]

Hi,

The Exporter, exports all the cell values in the Grid. Information in the Row Details is not exported. However, in case you wish to export additional data, you may pass an Array of Rows as argument to the “exportdata” method. The default Array which is being exported is the result of the Grid’s “getrows” method.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com/

[jon74Participant]

Thank you for your reply Peter.

By passing the Array of detail rows does it append to the default export or it would export only the rows contained in the array i am passing as parameter?

In that case I should build by myself the array with both cell values in the grid PLUS the rowdetails, correct?

Thanks again
Jonathan

[jon74Participant]

Uhm… I think I am missing something: I cannot retrieve the rowdetails data.

Here is my snippet:

$(“#excelExport”).click(function () {
var rows = $(‘#jqxgrid’).jqxGrid(‘getrows’);
var exportArray = new Array();
for (i=0; i< rows.length; i++){
exportArray.push(rows[i]);
var details = $('#jqxgrid').jqxGrid('getrowdetails', i);
if (details){
exportArray.push(details);
}
}
var exportInfo = $(“#jqxgrid”).jqxGrid(‘exportdata’, ‘xls’, null, true, exportArray);
$(“#dataToExport”).val(exportInfo);
$(“#dataType”).val(“excel”);
$(“#exportDataForm”).submit();
});

var “exportInfo” contains the xml of Excel spreadsheet, but it has only the “getrows” value, but not the “details” ones…

NOTE: var details is always defined as [object Object], but I don’t know how to see its properties. And I don’t have details for all rows, on the opposite I have few rows with details, which is a nested Div showing a warning label…..

[Author]

Posts