Scrape relative data to data tables to excel file

I have scraped text from pdf and wanted to create a data table and put the that each text in each row. Pls help, thank you :slight_smile:

Use Generate datatable activity. This will convert string to datatable.

In Generate datatable give column seperator as space and row seperator as environment.newline. :grinning:

5 Likes

I used output data table to store it then I used write line to output the data. But the output is not there. I also want to convert it in excel. Thank you.

Hi @rmfeliciano,

In generate datatable, Click generate datatable and use preview options to see the output.

image

Use the Output datatable in Excel Write range to write in excel.