Skip to main content
shukurs0001
July 25, 2022
Question

Store Excel data in Process variables.

  • July 25, 2022
  • 3 replies
  • 0 views

A person uploaded a excel file which contains name, group e.t.c of him/her. 
I need to save the details in the process variables. 

How can I retrive the data of excel into the process variables?

3 replies

harshitb6843
July 25, 2022

You can use the Excel tools plugin to query the data from the document and then store it in the Map Data type. 
Can you please explain your use case a bit so I can suggest a better approach?

shukurs0001
July 25, 2022

The moment person uploads the excel file, he becomes the user and gets added in the respective group.

harshitb6843
July 25, 2022
he becomes the user

isn't he/she already a user as they were able to upload the file? I am not super clear. 
And about being added in the groups, are these group mappings defined in excel?