This guide will walk you through the process of creating an RPA bot using UiPath Studio to:
1. Extract data from the Fortune 500 company list.
2. Filter the data to keep only Computer Software companies.
3. Save the filtered data into an Excel file.<\/p>\n
Install UiPath Studio (Community Edition available at [UiPath](https:\/\/www.uipath.com\/start-trial)).
– Install Google Chrome or Microsoft Edge (for web automation).
– Access the Fortune 500 website: https:\/\/www.50pros.com\/fortune500.
– Ensure you have Microsoft Excel installed to verify the output file.<\/p>\n
1. Open UiPath Studio.
2. Click “Process” and name it: Fortune500_Filter.
3. Click Create.<\/p>\n
1. Drag the “Open Browser” activity onto the workflow.
2. Set the URL to: https:\/\/www.50pros.com\/fortune500.
3. Select your preferred browser (Chrome or Edge).<\/p>\n
1. Click “Data Scraping” in the UiPath “Design” tab.
2. Click on the Fortune 500 table on the website.
3. Extract the following columns:
– Rank
– Company Name
– Industry
– Revenue ($B)
4. Save the extracted data into a DataTable variable named companyData.<\/p>\n
1. Drag the “Filter Data Table” activity into the workflow.
2. Set:
– Input DataTable \u2192 companyData
– Condition \u2192 “Industry” = “Computer Software”
– Output DataTable \u2192 filteredData<\/p>\n
1. Drag “Excel Application Scope” activity into the workflow.
– Set File Path to: filtered_companies.xlsx (this will create the file if it doesn\u2019t exist).
2. Inside “Excel Application Scope”, drag the “Write Range” activity.
– Input DataTable \u2192 filteredData
– Sheet Name \u2192 “Sheet1”
– Start Cell \u2192 “A1”
– Check “Add Headers”.<\/p>\n
1. Run the UiPath Workflow.
2. Open filtered_companies.xlsx and check:
– The file exists.
– It contains only Computer Software companies.<\/p>\n
1. Submit the UiPath Workflow File (.xaml).
2. Submit the Excel Output File (filtered_companies.xlsx).<\/p>\n
– If the extracted table structure changes, you may need to adjust column selection.
– If errors occur, use Debug Mode in UiPath to identify and fix issues.
– If the website layout changes, re-run the Da<\/p>\n","protected":false},"excerpt":{"rendered":"
Step-by-Step Guide: Extracting and Filtering Fortune 500 Data Using UiPath Overview This guide will walk you through the process of creating an RPA bot using UiPath Studio to: 1. Extract data from the Fortune 500 company list. 2. Filter the data to keep only Computer Software companies. 3. Save the filtered data into an Excel […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":[],"disciplines":[65],"paper_types":[],"tagged":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/questions\/42311"}],"collection":[{"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/questions"}],"about":[{"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/types\/questions"}],"author":[{"embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/comments?post=42311"}],"version-history":[{"count":0,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/questions\/42311\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/media?parent=42311"}],"wp:term":[{"taxonomy":"disciplines","embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/disciplines?post=42311"},{"taxonomy":"paper_types","embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/paper_types?post=42311"},{"taxonomy":"tagged","embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/tagged?post=42311"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}