Question Re: Unable Export File as a Excel using Button (Script) in Technology Q&A

Unable Export File as a Excel using Button (Script)

former_member230933 — Sun, 04 Feb 2024 01:33:10 GMT

Hi Team,

My Requirement is : I have to export from Analytic Designer file/Table to Excel.

I have created Button: Here i wrote script based on SAC Userguide.

Button Script:
ExportToExcel_1.exportReport();

While i run the report and click on Button i didn't see any error/successfull message.

Please guide us how do export as excel file from using with analytic designer. Refer the below screen captures for your reference.

Regards
Veera

Re: Unable Export File as a Excel using Button (Script)

avsalynin — Wed, 22 Sep 2021 06:39:43 GMT

veera.prasad2

Have you added the necessary components for export in the settings of the technical component (ExportToExcel_1)?

Re: Unable Export File as a Excel using Button (Script)

former_member230933 — Wed, 22 Sep 2021 08:13:10 GMT

Hi Aleksey,

Thanks for your prompt reply. It's working fine now.

Regards
Veera

Re: Unable Export File as a Excel using Button (Script)

former_member836140 — Wed, 01 Feb 2023 05:56:55 GMT

Sir avsalynin what does it export? all data of the table? or it is possible to export the filtered data of table ?

Re: Unable Export File as a Excel using Button (Script)

avsalynin — Thu, 02 Feb 2023 09:50:57 GMT

geraldsampayan28 through api and teh component, it exports All.

but if you need to export only table data, you can do this through the standard option in the context menu and there is already the option of all or not all

Re: Unable Export File as a Excel using Button (Script)

DharaneshV — Thu, 03 Oct 2024 13:29:04 GMT

The reason why the excel export for this script isn't working is because the code/script "ExportToExcel.ExportReport()" works blindly on exporting the data. But it doesn't know what data and which data to export. Hence, add the below line of code to showcase/highlight which data to export(in our case we are exporting the Table_1 data).

Script to be used:-

ExportToExcel_1.setWidget(Table_1);
ExportToExcel_1.exportReport();

This worked in my case. Glad if it works in your case.