topic Export Sharepoint List to Excel in Product Forum

Export Sharepoint List to Excel

VedantGautam — Wed, 27 Oct 2021 07:35:00 GMT

Hello everyone,

I am a newbie on blueprism and I would like your help. I have been trying to export a sharepoint list to an excel workbook through blueprism but no proper method has come up to me after a through search over the internet. Is there a way to get the data? I even tried spying elements but that also doesn't work.

Thanks in advance.

------------------------------
Vedant Gautam
------------------------------

RE: Export Sharepoint List to Excel

ritansh.jatwani — Wed, 27 Oct 2021 11:46:00 GMT

Hi @VedantGautam,

Welcome to BluePrism community !!

In order to get the sharepoint list to an excel please follow the below steps:

1) Spy any one element of the sharepoint list using HTML mode (preferably) or using AA/UIA mode.
2) Use read stage to get the data in collection.
3) Use Create instance action of MS Excel VBO to create an instance of the excel.
4) Use Create workbook action of MS Excel VBO to create a new workbook against the same instance.
5) Use Write collection action of MS Excel VBO to write the Collection value in excel.
6) Use Save as action of MS Excel VBO to save the generated excel to your preferred location.
7) Use Close Workbook/Close Instance action to close the generated excel.

Hope it helps

------------------------------
Ritansh Jatwani Senior Consultant
Consultant
EY
Gurgaon
*If you find this post helpful mark it as best answer
------------------------------

RE: Export Sharepoint List to Excel

PritamPoojari — Thu, 28 Oct 2021 08:02:00 GMT

You may want to consider using Graph API to fetch the sharepoint list instead of the UI, and use the excel VBO as Ritansh mentioned in his post

https://digitalexchange.blueprism.com/dx/entry/3439/solution/microsoft-graph-api---sharepoint

------------------------------
Pritam Poojari
Solution Architect
Capgemini
Europe/London
------------------------------

RE: Export Sharepoint List to Excel

EVIPUTI — Sat, 30 Oct 2021 05:43:00 GMT

Hi @VedantGautam Why dont you simply map Sharepoint folder to be a network drive on your computer and use file manipulation ?

------------------------------
------------------------------
Vipul Tiwari
Senior Process Simplification Developer
Amazon
------------------------------
------------------------------