Unable Export File as a Excel using Button (Script)

[former_member230933]

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

[avsalynin · Accepted solution]

veera.prasad2

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

[former_member230933 · Accepted solution]

Hi Aleksey,

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

Regards
Veera

[DharaneshV]

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.

[former_member836140]

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

[avsalynin]

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