Export excel Style

[hirehop]

Hello

I wanted to export grid data in excel file with same grid style

could you help me on this?

I wanted as per picture 2

please find the attach pictures

[paramvir]

Most of the grid styles are exported to Excel by default.

Please follow this example:

https://paramquery.com/pro/demos87/export_style

[hirehop]

thank you for your reply

i think it will be change in the grid also
but i wanted it like only style to the excel file

other wise export same as grid with its style
i am sending you my grid picture

[paramvir]

The data in your grid is different from the exported spreadsheet, please clarify.

[hirehop]

data is same but style also need same

[paramvir]

data is same but style also need same

This example: https://paramquery.com/pro/demos87/export_style has both data and style same in grid as well as in exported spreadsheet.

[hirehop]

thank you

right now we have own CSS working on grid but its can not display in the excel , can it possible to give style with out changing grid and make style on excel.

[paramvir]

Yes it's possible to add or modify styles in xlsx without changing the grid styles.

First export grid to 'wb' or workbook format which is a plain object whose format is mentioned here:

https://paramquery.com/pro/api/excel-workbook

Then make changes in the workbook object and export it to spreadsheet with pq.excel.exportWb() method.

[hirehop]

Thank you once again
 its working very good
can we add filter as grid in export excel?

[paramvir]

Exporting filter rules to xlsx is currently not supported.