Multi-threading Signup with Excel Data

[sarankavalan]

I explored free version, and all seems good n I learned except one thing.

I am going to sign up a webpage with name, email and password.
I have these data in excel file.

I need to read and fill details from that excel file. I am to do multi-threading of "10".
so, during that time each thread should use unique data from excel.

How can I do it.

[Roy Mustang]

@sarankavalan You cannot use multithreading in Excel, only 1 thread

1. You need to create an onapplication function
   Find out more here from bablosoft https://teletype.in/@bablosoft/functions-in-BAS-en
2. In it, you need to “create a resource” action. In the action settings, there is a “simultaneous use” parameter. Set it to 999
3. Read the Excel document with the “Read cell” action.
4. Get the list that needs to be processed in a Foreach cycle. Be sure to set a delay in the loop using the “Sleep” action.
5. Next, it is your task to fill in the data into the resource. Do this using actions 1) “Parse CSV” and 2) “Add element.”
6. The result will be a filled resource that can be used in BAS logic as usual.

[sarankavalan]

if excel cannot be used.
what is other way to process multi threading and for each thread using unique data without duplicate.

[sarankavalan]

the instruction above you said is bit confusing. for my purpose it is not mandatory to use excel.
I am ok to feed data in any form which is easy to deal.

[Roy Mustang]

@sarankavalan You wrote to me to create logic with Excel, and I wrote to you.

It is best to use resources or the internal BAS database, but if you are a beginner, it is better to use conventional resources.

[pirkhezr]

Multi threading is possible using resources. You have to put your data in a resource. This video can be actually pretty helpful: https://youtu.be/fLggFllTWws?si=9Z1s_Mip63GlLUW6

[sarankavalan]

Thank you so much guys. I finally achieved it