Need help in data scrapping

Help Activities
, ,
1

image
image901×311 8.79 KB

this a project which i want to built out of which i have covered the first box. can someone help in building it

2

@Keshav_Shah,

Something you tried or stuck somewhere?

Here is quick guidance for AI

To create 1999 Excel files in a folder using UiPath, you can follow these steps using a combination of activities. Here’s a clear breakdown:

:puzzle_piece: UiPath Activities Needed

  1. Assign
  2. For Each
  3. Excel Process Scope / Use Excel File
  4. Write Cell / Write Range
  5. Create Folder (optional)
  6. Path Exists (optional)

:hammer_and_wrench: Step-by-Step Workflow

1. Set Up the Folder

  • Use “Path Exists” to check if the folder exists.
  • If not, use “Create Folder” to make the target folder (e.g., C:\ExcelFiles1999).

2. Create a Counter List

  • Use an Assign activity:
    fileNumbers = Enumerable.Range(1, 1999).ToList()

3. Loop Through the List

  • Use a For Each activity:
    • Type Argument: Int32
    • Values: fileNumbers

4. Inside the Loop: Create Each Excel File

  • Use “Use Excel File” or “Excel Process Scope” (depending on your UiPath version).
  • Set the file path dynamically:
    filePath = "C:\ExcelFiles1999\File_" + item.ToString + ".xlsx"

5. Write Something in the Excel File

  • Use “Write Cell” or “Write Range” to add content like:
    "This is file number " + item.ToString
    • Write to cell A1.

:white_check_mark: Optional Enhancements

  • Add a Progress Bar or Log Message to track progress.
  • Use Parallel For Each if performance is a concern (but be cautious with Excel operations in parallel).