cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Nintex Newbie

Query Data from Excel?

Jump to solution

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.

Labels: (1)
0 Kudos
Reply
2 Replies
Highlighted
Nintex Newbie

Re: Query Data from Excel?

Jump to solution

Curious if anyone has any insight regarding this. Thanks

0 Kudos
Reply
Highlighted
Nintex Employee
Nintex Employee

Re: Query Data from Excel?

Jump to solution

@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. 

View solution in original post

Reply