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.
Solved! Go 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.