how can i export data into excel [.xlsx] via script

[snavuluri]

Hi All,

 Please guide on,  how i can export data into excel [.xlsx] via script.

Regards,

Suresh.

[snavuluri]

Hi Ankur,

       It is a generic/global task, normally from any table list,  we do right click and export in .xlsx. Instead of that activity, just need to do the export data using script. That script can later on will be use in button for or any other. For now let assume for incident list.

Regards,

Suresh. 

[Ankur Bawiskar]

Hi,

then you can use this UI Action on your table

Type - List Banner button

Client Checkbox - true

Onclick - downloadRecords();

Script:

function downloadRecords(){

	var tableName = 'incident';
	g_navigation.open('/' + tableName + 'list.do?CSV&sysparm_view=ess', '_blank');
}

Regards
Ankur

[snavuluri]

Hi Ankur,

     I am able to download into csv file but not getting the data export in excel.

Regards,

Suresh.

[Ankur Bawiskar]

@snavuluri 

So did you use the script I mentioned or you are using some other script?

if other script please share that

Regards
Ankur

[snavuluri]

Hi Ankur,

     Am using the same script as you mentioned. getting the export attackment with empty sheet without any data whick getting zero bytes.

 Regards,

Suresh.