exportdata xls: Umlaute and dates

[carloParticipant]

Hello Peter,

we are using $(‘#gridAlarms’).jqxGrid(‘exportdata’, ‘xls’, ‘alarms’) to export data to excel.
1. Umlaute are not displayed. If we are using ‘csv’ Umlaute are correct.
2. We have a column of type ‘date’. The grid is showing correct dates like ‘11.11.2013 10::00:00’, but the export displays only blanks, regardless if ‘xls’ or ‘csv’.

Best Regards
Carlo

[Peter StoevKeymaster]

Hi Carlo,

– The last parameter is optional determines the char set. It could be the solution on your case. However, we cannot manipulate how Excel is displaying data.
– Check whether your Date data fields are with type: ‘date’. If they are, then provide a sample.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[carloParticipant]

Hi Peter,

could you please give me a complete example of exportdata with all parameters ? Are the charset strings the same as the html charset strings, e.g. ‘ISO-8859-1’ ?

This is how we fill the grid:

var ngridsource = {
localdata: alarms,
datatype: ‘array’,
datafields:
[
{ name: ‘AlarmID’, type: ‘number’ },
{ name: ‘DateOn’, type: ‘date’ },
{ name: ‘DateOff’, type: ‘date’ },
{ name: ‘DateAck’, type: ‘date’ },
{ name: ‘AlarmText’, type: ‘string’ },
{ name: ‘AlarmGroupDescription’, type: ‘string’ },
{ name: ‘AlarmTypeDescription’, type: ‘string’ }
]
};
var dataAdapter = new $.jqx.dataAdapter(ngridsource);
$(‘#gridAlarms’).jqxGrid({ source: dataAdapter });

[Peter StoevKeymaster]

Hi carlo,

The exportdata method’s charSet parameter sets the HTML Form’s acceptCharset member. As far as I know the default char set is equal to your document’s char set. You can read more about that here – http://www.w3schools.com/tags/att_form_accept_charset.asp

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[Author]

Posts