How to write an extracted table in an Excel file

Help
#1

I have extracted data from a pdf in a table format using data scraping. How to write that data in an excel file?

#2

Hi @ADITYA_MUKHERJEE

Use Generated Data table and set the parameters to comma etc and then use write range

or use output datatable activity and then use write range activity

Thanks
Ashwin S

#3

@ADITYA_MUKHERJEE Can you show us How is the Format of the Extracted Table from PDF?

1 Like
#4

image
image1920×1080 319 KB

#5

@ADITYA_MUKHERJEE Is it Extracting Properly ? If it is Extracting Properly you can Directly Write the Extracted Datatable from DataScraping to an Excel File using Write Range Activity

#6

Hello Aditya,
In this video, I have multiple use cases of UiPath extract data from the Web and write this data in Excel:

0:42 Extract table from a web site and write this data in Excel
2:40 Extract emails from Yahoo Mail and write this data in Excel
5:00 Read Data from Excel search on Google and write back the data in Excel
8:05 Run the process
9:25 Count the repetition of string inside excel table
15:55 Copy only rows that contain a specific string to a new table

Thanks,
Cristian Negulescu