I have extracted data from a pdf in a table format using data scraping. How to write that data in an excel file?
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
@ADITYA_MUKHERJEE Can you show us How is the Format of the Extracted Table from PDF?
@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
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