How to create Excel file


#1

Hi guys,

may I ask that how am I able to create a excel file based on the data I have scrapped ?

Thank you!


#2

Hello @jasperlzx, you can write datatable to Excel by using Write to Range Activity (you can use either Excel one or Workbook one depends on your situation).


#3

Hi @jasperlzx,

Yes u can.
After scrap the data convert the string value to datatable based on you input string.

Then use write range activity to write the data into excel sheet.

You can create the excel file dynamically.

Regards,
Arivu


#4

@arivu96 can you help me on this, i tried by using find children activity but i am not getting any output.
“1. Navigate to http://www.contextures.com/xlSampleData01.html
2. Retrieve a date from user
3. Output the corresponding region and total
4. Don’t use Web Scraping wizard.”