Search code examples
rpaautomationanywhere

Go to a specific cell in csv in a loop

I want to use a loop with the Start loop each row in Automation Anywhere.

If i use the start loop each row in a file, how it is start from a specific Cell.

Thanks.

Solution

  • In Automation Anywhere, Go to specific cell command is not available for CSV file. It's available only for the Excel command Operations.

    The *Read from CSV/Text* command uses Comma delimiter to read individual cell in particular row, you can use Filedata Column(column number) to read specific column data. You can use column number, but not the specific cell id. So we have to use Excel Command to navigate specific cell.

    • Use Excel Open SpreadSheet command to open the csv file.
    • Then Get Cells to Get All Cells in the file.
    • Use Each Row in an Excel Dataset loop command to read each row in a file.
    • Use Go to Cell to go Specific Cell in csv file. B$Counter$ (B1,B2,..)
    • Use Get Cells to get values from Active cell or Specific cell. And assign it to Variable.
    • . .

    Refer below attachment. enter image description here you can use Excel Command operations on particular cell as per your requirements.