I'm able to read a single sheet of an excel file in Outsystem and insert the data in an entity. However, we need to read multiple sheets of an excel file and load its content in different entities.
It would be great if you could please give me a detailed explanation to this and point me to right resources for this.
Thanks for the quick reply.
Can you please explain me how to acheive this iteratively. Actually what we are doing at present:
1.We are passing the full path of the excel sheet to an Outsystem web service. The file exists on the serverand Outsystem has full access to this file.
2.We now are looking for a mechanism in Outsystem that can read the multiple sheets of that excel file iteratively probably and we would also want to upload the data into different entities of different data sheets. I mean I'm looking for kind of For-Each loop to iterate through each sheet or if For-Each is not possible then please share some other strategy that I can use in this scenario
Can you please help me?
The problem I'm facing?