Hello ! This is my first post in UiPath Forum. I’m a newbie and I’m just starting to learn how to do automation.
What I needed:
Successfully fetch the extracted data from Website (Amazon.com product)
List the extracted details (Product Name, Price, Rating, Number of Reviews)
Problems I’m encountering
I’ve created a variable for each of the item and turned it to a Data Table
I don’t know whether I’d use Write Range for Excel or something else …
Thanks a lot! (in advance)
P.S. Solutions with explanations are HIGHLY appreciated, as I’m still learning the basics of UiPath.
EDIT: UPDATE
This forum is now solved Huge thanks to @ashokkarale and @Anon_Robot for helping me deal with my encountered problem…
Update
I used Write Range Workbook as suggested by the first replier.
*Nothing really special about my red blocked field… Haha
I started off with “A3” because my worksheet contains headers.
Output:
Thank you all for contributing! Let’s learn together
Welcome to the Community @JoanneDeGuzman ,
If your datatable column sequence and the excel template sequence is the same, use Write Range - Workbook activity.
This activity is faster than Excel activity as it’s directly interact with file without opening it through Excel.
1 Like
Hi @JoanneDeGuzman ,
There are 2 ways to write a table to excel
Write Range Workbook
Documentation: Activities - Write Range
Pros:
Faster, especially with large datasets.
Doesn’t require Excel to be installed.
Works directly with the file.
Cons:
Limited to data writing; no Excel formatting or application-specific functions.
Write DataTable To Excel
Documentation: Activities - Write DataTable to Excel
Pros:
Allows for interaction with the Excel application.
Enables Excel formatting and application-specific functions.
Cons:
Slower than “Write Range Workbook.”
Requires Excel to be installed.
Requires the Excel Application Scope activity.
In both cases you’d need to download the UiPath.Excel.Activities for the activites to work.
Hope this helps!
1 Like
Thank you for the warm welcome, @ashokkarale !
This worked like a charm Thank you!
1 Like
Hello, @Anon_Robot !
Thank you for replying such insightful feedback. This definitely helped and will help me especially when dealing with more Excel activities soon Thanks again!
Hi @JoanneDeGuzman
Welcome to UiPath
Check below link it’ll helpful.
The UiPath Documentation Portal - the home of all our valuable information. Find here everything you need to guide you in your automation journey in the UiPath ecosystem, from complex installation guides to quick tutorials, to practical business...
Happy Automation!
1 Like
@JoanneDeGuzman ,
Glad to hear! Kindly close the thread by marking my answer as solution.
Forum FAQ - How to mark a post as a solution
This document is part of our beginners guide .
This article will teach you how to properly mark a post as a solution.
We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them.
When is the topic resolved?
The topic can be considered resolved when the topic author has found…
1 Like
Hi, @prashant1603765 !
Thank you for this Very helpful
system
(system)
Closed
March 28, 2025, 7:41am
10
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.