I am scrapping data from a website and want to write the output in an Excel file. After adding data scrapping activity, I add Write CSV as the next subsequent activity. I am not sure what to fill in File path and Data Table columns, to get the desired result. Also would this be enough for doing this? Or there are other activities that need to be added?
File path : is specifying your destination path where you want to save the file
Data Table: is the output from satascrapping activity
Like this you have to specify it.
you can use write CSV and write range as well. have a look at below screenshot,
Thanks a lot, just want to know if I have to create an empty file and save it in the specified location and it will write the scraped the data in it or it will automatically create a file in the specified location and then write the output.
Also do I need to create any variables for the same?
You don’t want to create the empty file. If is not exists , it will create the file automatically . If it is exists, it will overwrite.
To Details :
Its working fine, thanks a lot. Really appreciate the quick response
Can we add serial numbers or Something like no result to each row if the search results no data, like i have a results of 100 to be added in excel and if there is no result for one of the search it should write empty in the row or it should leave the row empty with search number.
because if there is no data for the search it is adding the next search results data to the csv. so if i search for 100 values and found only 80 in that there are only 80 entries in csv for which i’m unable to find which entry has no data.
Please help me.