How to retrieve the excel cell entry one by one in web app using StudioX?

[Vivek_Pandey2 (Vivek Pandey)]

I am in the middle of excel data entry into web browser where it will enter the value and chcek if that exist and if it not then it will create that entry in the web browser.
The Sheet has column A (Item id), Column B (Description), Column C (Service Part - Category)
value always being with 9xxxxxx from row A3 till last row down.
How can we write in studioX so that it can check the part number one by one in system and if not present it will create further in web app.

I am getting an error while, i use the For each excel row (CurrentSheet.Range(String.format(““A3:C{{0}}””, LastRow)):

[ashokkarale]

@Vivek_Pandey2,

You should be using For Each Excel Row Like this:

No need to mention last row. Just specify Sheet name.

Here is sample solution:

Sample Code:

ExcelActivity.zip (60.6 KB)

Thanks,
Ashok

[Vivek_Pandey2 (Vivek Pandey)]

Thanks for the response.

while doing so in IF statement, i am getting an error as below

[ashokkarale]

Put that 9 like “9” in string. It should be string datatype.

[Vivek_Pandey2 (Vivek Pandey)]

Thanks for the response. The error is gone…

Also, the one which you have provided in ZIP file will that scenario would be applicable for Multiple excel sheet with different name varied on weekly basis.

I have tried to make it work in such a way that it will browse for folder and go for the file open it and follow the same columns 1 to check in browser 1st if not found then it will go ahead with creation of new entry.

Let me know, if that logic make sense.

[ashokkarale]

@Vivek_Pandey2,

Do you mean you will have search that code will be available in any of the file in that folder?

[Vivek_Pandey2 (Vivek Pandey)]

Yes, the format would always be same…

[ashokkarale]

Ok, in this case your logic seems good just maintain a variable which will remember if any particular found on the website or not.

If even after iterating all the files part number not found then add logic to create new.

Thanks,
Ashok

[Vivek_Pandey2 (Vivek Pandey)]

I will try to do so and see how it goes…

Thanks for your support @ashokkarale really helpful.

[Vivek_Pandey2 (Vivek Pandey)]

Hello @ashokkarale ,

I tried to reach here but the only issue is that how should I code for in that case.

If there are number like…
Part No. Desc
9XXXXXX-01 Part 1
9XXXXXX-02 Part 2

I want to code is such a way that it will go down with creation of part one by one…