Export grid data to Excel with the extension of .xlsx

[subhani.029@gmail.comParticipant]

Hi guys,

I have jqxGrid and a button to “export to excel”.
we have export predifined funtion for export but its only for .xls and the problem is,
i have more than 1,00,000 rows which is not converting it to excel because the limits of
xsl is 65k only, where as in xslx we can have 1 million rows.

when i have just edited this export function

$("#jqxgrid").jqxGrid('exportdata', 'xls', 'jqxGrid'); 

what i did:
$("#jqxgrid").jqxGrid('exportdata', 'xlsx', 'jqxGrid'); // when i have edited this line... then its not getting export.

can any one please help.

Thanks

[Peter StoevKeymaster]

Hi subhani.029,

The Grid exports to ExcelML format as pointed out on the Documentation which means that “.xls” is the extension. Other supported formats are also documented and .xlsx is not one of them.

Best Regards,
Peter Stoev

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

[yongchen45@gmail.comParticipant]

Hi Peter,

Is there any plan to support .xlsx Excel format in exportdata method?

Thanks
Yong

[Singh_kiatecParticipant]

Hi Peter,

any update to support .xlsx Excel format to exportdata?

Thanks
Singh

[TodorParticipant]

Hello Singh,

The supported formats are ‘xls’, ‘xml’, ‘html’, ‘json’, ‘pdf’, ‘tsv’ or ‘csv’.

Let us know if you need further assistance.

Best Regards,
Todor

jQWidgets Team
https://www.jqwidgets.com

[DeployDuckParticipant]

Hello.
The export to xlsx is after 5 1/2 years still not supported.

The link to :
https://docs.microsoft.com/en-us/archive/blogs/vsofficedeveloper/excel-2007-extension-warning

in the documetation :
https://www.jqwidgets.com/jquery-widgets-documentation/documentation/jqxgrid/jquery-grid-api.htm?search=grid

is broken.

Please informe me, if you plan to upgrade your export-function for excel.

[HristoParticipant]

Hello DeployDuck,

Yes, we support it (the “xlsx” file format) already.
There is the new “exportview” method.
It provides also, the Client-Side exporting.
Please, take a look at this demo:
https://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/dataexportview.htm?light

Best Regards,
Hristo Hristov

jQWidgets team
https://www.jqwidgets.com

[Author]

Posts