How to create new CSV file for every table data scraping from web

Help Activities
, , , ,
1

Hi guys please help me, How to create new CSV file for every table data scraping from web?
for now i can scrape table from web and write to csv, but the data always replace in same collumn and same file, how to create new csv file for each data from web?
Thankyouu

2

Hi @raditiyoyo

Welcome to the community.

You can set up unique name to file like ā€œDataā€ + Now.ToString(ā€œddMMyyyy_HHmmssā€) +ā€œ.csvā€

When you directly specify this path in Write CSV activity, if it throws an exception like: ā€œExpression Activity type ā€˜VisualBasicValue`1ā€™ requires compilation in order to run. Please ensure that the workflow has been compiled.ā€

Then try using an Invoke Code:

The image shows a workflow involving an "Invoke Code" activity to generate a file path name and a "Write CSV" activity to write data to the generated file path with headers included. (Captioned by AI)
The image shows a workflow involving an "Invoke Code" activity to generate a file path name and a "Write CSV" activity to write data to the generated file path with headers included. (Captioned by AI)665Ɨ446 6.25 KB

The Code inside Invoke Code:

filePathName = "Data/Output/CSV_Data_" + DateTime.Now.ToString(ā€œddMMyyyy_HHmmssā€) +ā€œ.csvā€

The Invoke Code Arguments:

The image shows a dialog box titled "Invoked code arguments" with a table containing details about the argument "filePathName," including its direction, type, and value, along with options to create a new argument or confirm/cancel. (Captioned by AI)
The image shows a dialog box titled "Invoked code arguments" with a table containing details about the argument "filePathName," including its direction, type, and value, along with options to create a new argument or confirm/cancel. (Captioned by AI)701Ɨ202 7.04 KB

The Output:
As you can see below, Separate CSV files are generated everytime.

image
image427Ɨ135 2.14 KB

You try any type of dynamic naming convention, to make the file names unique.

If this solves your issue, Do mark it as a solution.
Happy Automation :star_struck:

1 Like
3

Hey @raditiyoyo you can follow these screenshot steps. simply

The image shows a sequence in UiPath Studio for extracting table data from a website and writing it to a CSV file. (Captioned by AI)
The image shows a sequence in UiPath Studio for extracting table data from a website and writing it to a CSV file. (Captioned by AI)645Ɨ511 25.7 KB

cheers

4

still didnt work, In my main sequence there is a read range workbook with an excel file but the file is different from the destination file for write to csv, do they have to be the same?

5

Not necessary. The solution i gave, would create a new file entirely. If there is a file that exists with same name, then it would override, But that is not possible because new file Name is created every time before the Write CSV activity.

Could you tell me what is the exact workflow you are expecting?

6
  1. data scraping from website (table extract)
  2. input data to csv or excel
  3. looping continuously and create new file for each data
7

This is confusing to me:

You will Write the Extracted data to CSV and then Loop through each Data to create new files again?
Looping through what exactly?