Posted: 8 Feb 2018 6:54 EST Last activity: 9 Feb 2018 2:47 EST
How can I export Page list contents to Excel
I have a page list which stores some custom warning details. I need to display a button clicking on which entire page list content should be exported to excel. Is there an OOTB activity to get this done.
I have tried using Activity MSOGenerateExcelFile by creating a xslm template with the appropriate columns (not sure if I'm doing anything incorrect here), created a binary file rule, uploaded it and checked Download checkbox. But nothing is getting downloaded.
Surprisingly, when I manually run the wrapper activity (which invokes MSOGenerateExcelFile activity) on the case thread, export and download is happening properly. Not sure why download is not happening upon clicking a button (embedded into table header) which runs the same activity upon click event.
I have initially configured the button to "Run activity" upon click. It didn't work. Activity was getting invoked but download was not happening. Then I used "Refresh section" and in that I've used the same activity. Now, excel file is getting downloaded.
Actually if you use Open URL in Window properly then it should download the excel file properly, for example which i tried in my use case. You should be used Use Page option properly. Anyhow good to see that your issue got resolved after refresh of the section.