I dragged the extract table data from activities menu into main sequence and started trying to use Table Extraction in UiPath to scrape data from Amazon for the iPhone 17, including the product URL, price, and ratings. When I click to extract all three fields, i am not being able to export them properly into Excel. I’ve reached the last step, but nothing is showing up in the Excel file. Could someone guide me on what I might be missing?
Hi, @Samip if your extracted data is not showing up in Excel then try adding a Message Box with ExtractDataTable.Rows.Count.ToString to check if you are actually getting any data. Also, make sure you are connecting the data table to Write Range and double-check if Amazon’s page structure changed. This should help you figure out what’s missing. If this still doesn’t work try explaining your issue in more detail like any error messages or screenshots so its easier to help you out!
- First check if there are any selector or table level changes as those would effect the extraction
- after extraction check the dt.rowcount to check if there are rows extracted
- check if any variable with duplicate name in different scopes is present
- check which excel file you are checking is the right one where automation is writing as well
cheers
First ensure that data is extracted or not in the datatable and delete the excel file and let the studio’s write range activity create an excel file and write the data into it.