Exported excel from DataTable with filter is crashing in Excel 32 bit application
Exported excel from DataTable with filter is crashing in Excel 32 bit application
NSP
Posts: 1Questions: 1Answers: 0
Excel is exported from DataTable using code:
buttons: [
{
extend: 'excelHtml5',
text: '<i class="fa fa-file-excel-o"></i>',
titleAttr: 'Export Excel',
filename: 'Export List',
className: 'excelButton', ...
When it is opened in 64bit application, it works fine and sorting can be done. But in 32bit excel application, it get crashed when sorting is performed.
When generated with disabling filter, it works fine in both 32bit and 64bit Excel application.
autoFilter: false,
Could you please suggest me how to export it as excel which will be compatible with 32bit application with filter enabled.
This discussion has been closed.
Answers
I was aware of an issue with the export crashing for auto filters enabled, but haven't as yet debugged it, as I've not found a way to recreate the issue. This give me somthing t go on, thanks.
Allan