Solved

Query Data from Excel?

  • 15 November 2020
  • 2 replies
  • 179 views
A

Hello,

 

I was wondering if there is any way to grab data from existing Excel worksheets and import that into Nintex Workflow Cloud? I see there are a few ways in other Nintex workflow environments such as Sharepoint and Office 365 but not sure about Workflow Cloud. 

 

The data that I will primarily be working with is organized in Excel and is like a table and I need a way to query that data and also be able to manipulate and save that data back into the same worksheet if possible. I see that there is Query Excel Services but not sure if that is available for Nintex Workflow Cloud.

 

I see that some have mentioned that the only way would be using a database for that for Workflow Cloud but not sure if that is 100% true.

 

Thanks in advance.

icon

Best answer by leighburke 26 November 2020, 06:12

View original

2 replies

A

Curious if anyone has any insight regarding this. Thanks

L
Userlevel 5
Badge +13

@Anhthu You could use an RPA bot to work with excel and call from it from your NWC workflow(https://help.nintex.com/en-US/nwc/Content/Designer/Actions/NintexRPA-StartRPAJob.htm). The other option is  you could make your own xtension to connect to the graph api(https://docs.microsoft.com/en-us/graph/api/resources/excel?view=graph-rest-1.0) or another rest api that will do what you need. 

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings