Export list items in SP list automatically


Badge +8

Hi,

With the latest version of Nintex, is it possible to export list items into a spreadsheet and copy that spreadsheet into a document library?

i would like to schedule this workflow two times a day so that I have an updated version in the document library. 

Please help.

Thank you.


4 replies

Badge +8

Anyone has any insights into this? Please advise

Badge +9

By using Excel web services You can create an Excel workbook, see  

Badge +8

Hi Manfred,

Thank you for your response. Unfortunately, I do not have enterprise version to use excel services. I might have to explore powershell option. I thought the document generation capability in Nintex will have some clean solution but it looks like it doesn't.

Thank you for your help,

Badge +11

Another approach could be to query your list for the information you need and create some csv. This csv can be saved inside a library quite easily. See Vadims post for getting you started (especially the web request action).

Reply