how export to excel programmatically?

pavel_1111

Hello! Please tell me how to call the export to Excel programmatically? I know that there is a button (excelHtml5 Button). But I do not need to use this button. I need to make export to Excel programmatically on my link. Does API that can do this? Thank you.

allan

No sorry. There is no option to do this since it is a security and privacy issue in the browser. Browser's do not allow files to be generated on the client-side and automatically downloaded without user interaction. Otherwise, any site you visit would be able to create and download files when you visit it!

If you have a user interaction then you could call the action method of the Excel export button from that function which would do it. You would still need to create the Excel button, but you could just not display it.

Allan