How to set column sequence as per the columns set on portal while exporting excel /csv from portal ?

[Virendra K]

Hi All,

Per requirement, I need to export xls/csv file from the portal (snap 2) with the CI list listed (snap 1). I am able to export it but excel file is showing by default column sequence , but client is expecting the sequence as per the portal shows (snap1).  There is HTML code written (snap 3)..

my ask is, How I could set the column list to the exporting excel file as per the column listed on portal ?

snap 1

snap 2

snap 3

@Ankur Bawiskar Please, I seek your help and expertise on this.

Thank you,

Virendra

[Ankur Bawiskar · Accepted solution]

@Virendra K 

the view in your URL is the default view.

so whatever is the column sequence on List Default view, that will come.

You can have a custom list view and add the columns in that sequence as per portal snap

Then in your URL mention view name as that

sysparm_view=myViewName

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Virendra K]

Yes, You are correct..I created a customize view and as you suggested given the name to the URL..Its working as expected.

Thank you very much.