Using: SmartClient_v111p_2017-11-27_PowerEdition
I'm hoping to export formatted data from a listGrid to an Excel file. Currently I'm able to use either exportData or exportClientData to generate csv files. However, with exportAs:"xls" or exportAs:"ooxml" I get back a small Excel file that has no data in it.
The listGrid:
isc.ListGrid.create({
ID:"roomReportGrid",
autoDraw:false,
autoFetchData:true,
dataSource:"roomReport",
canEdit:false,
showFilterEditor:true,
initialCriteria:{active:1},
sortField:"roomNumber",
showGroupSummary:true,
showGroupSummaryInHeader:true,
groupByField:"roomNumber",
groupStartOpen:"all",
showAllRecords:true,
height:550,
width:"100%",
fields:[ .............
The dataSource is a server-side mysql data source, which works well enough to populate the grid with the expected data.
Thanks in advance.
RP
I'm hoping to export formatted data from a listGrid to an Excel file. Currently I'm able to use either exportData or exportClientData to generate csv files. However, with exportAs:"xls" or exportAs:"ooxml" I get back a small Excel file that has no data in it.
The listGrid:
isc.ListGrid.create({
ID:"roomReportGrid",
autoDraw:false,
autoFetchData:true,
dataSource:"roomReport",
canEdit:false,
showFilterEditor:true,
initialCriteria:{active:1},
sortField:"roomNumber",
showGroupSummary:true,
showGroupSummaryInHeader:true,
groupByField:"roomNumber",
groupStartOpen:"all",
showAllRecords:true,
height:550,
width:"100%",
fields:[ .............
The dataSource is a server-side mysql data source, which works well enough to populate the grid with the expected data.
Thanks in advance.
RP
Comment