Using Read CSV File activity returns the error "The CSV file format for is invalid. Line 2 contains more values than the header line."
Resolution
There are two possible approaches.
Approach #1
- Open CSV in Notepad or Notepad++.
- Check the delimiter being used.
- Pass the same delimiter in the Delimiter property of the "Read CSV" activity.
Approach #2
- Replace the "Read CSV" activity, with a "Read Text file" activity and use the .csv file as input and set a string variable for output.
- Use a "Generate Data Table" activity and use the String output from the "Read Text file" activity as input.
Refer to the UiPath Forum posts: