Can anybody help with the steps in video ,How To automate the process of extracting barcode data from the TEC-IT barcode generator website (https://barcode.tec-it.com/en in Linear codes : There are many codes) and create an Excel file with three columns (Code, Data, and Image of Barcode) using UiPath
- Go to web page
https://barcode.tec-it.com/en - Click on Linear codes
- Under linear codes there are sub codes
- I want to create a excel with three coloumns like Code, Data, Barcode for all the subcodes
please share references / information to the video
Hello @Kruthi_BS
You could do as shown below (download at the end), however it might not be the “prettiest” solution.
Download:
Barcode.xaml (20.4 KB)
Barcodes.xlsx (8.1 KB)
Regards
Soren
Thank you for the quick response. I will try this out.
You are welcome.
Yes try it out and let me know if you run into any trouble.
Place the Excel-file in a folder called: C:\test\
Unfortunately I was unable to find a stable image selection of only the barcode, without the surrounding button/box.
Regards
Soren
Hi Soren,
- In assign activity what have created as variable in “value to save tab “?
- After assign activity which activity have you dragged
- I want to creat excel for all the sub codes under linear codes . Do I have to repeat the same options for all the subcodes ?
Hello @Kruthi_BS
I was unsure how your initial input for this proces was.
Do you have an Excel-file with codes/data you need to generate a barcode for or…?
If that is the case, I would read this input Excel-file and iterate the rows, and then input the desired codes/data on the page, before my code “comes in” for the data extraction.
Regards
Soren
Do you need to read (decode) or create bar codes? Any type in particular?
In open browser/application activity URL link is not getting heightened, am I missing something?
Are you using the file that I have attached?
Perhaps check if the property for “Open browser” is set to always or if not open.
ok Thank you ,
Hi Soren,
- In assign activity what have created as variable in “value to save tab “?
- After assign activity, which activity have you dragged?
- I want to create excel for all the sub codes under linear codes . Do I have to repeat the same options for all the subcodes ?
Pls ignore Serial number 1 and serial number 2 .
Pls help me wit the Serial number 3.
Hello @Kruthi_BS
You can download the entire code by clicking here in the post:
What do you mean by “serial number 3” and where can I find this?
Regards
Soren
I want to create excel for all the sub codes under linear codes (You have shown me for code-128, but i want to create excel for code-11, code-2of5Interleaved till telphen alpha) . How can I loop for all the codes ?
Hi Soren,
I Could run and I am able to create excel for “Code-128” .Thanks for your guidance and help.
I want to create excel for all the sub codes under linear codes (You have shown me for code-128, I also want to create excel for code-11, code-2of5Interleaved till telphen alpha) . How can I loop for all the codes ?.
Can you please help me with the steps?.
Regards
Kruthi
Hello @Kruthi_BS
You could create a list of the different codes you want to click, or alternatively an Excel file with the codes listed, that you can then read.
Then you should loop these codes in a For each activity, with a click on the specific code by giving the code as a variable to the selector.
After this you should add my initial code snippet.
I can make your an example on Monday 
Thank you Soren,
Yes please, that would be helpful if you explain with an example.
1 Like
Hello @Kruthi_BS
I have now changed the process to have 2 sheets in the Excel file - Input and Output.
You can fill out the desired Code and Data in Input and the barcode will be deliverede in Output.
Taking the size of the images into consideration, I have changed the row heigh in the Output sheet.
Download code at the bottom.
Example input
Example output
Download here:
Barcode.xaml (27.5 KB)
Barcodes.xlsx (10.4 KB)
Regards
Soren