How to write an extracted table in an Excel file

ADITYA_MUKHERJEE · February 13, 2020, 10:39am

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

AshwinS2 · February 13, 2020, 10:41am

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

supermanPunch · February 13, 2020, 10:47am

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

ADITYA_MUKHERJEE · February 13, 2020, 11:17am

supermanPunch · February 13, 2020, 11:20am

@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