CSV problem when i try to read it


#1

Hello community, my problem is when i try to open a downloaded csv that has a dynamic number throws this error:

Main has thrown an exception

Source: Read CSV

Message: The CSV file format for X:\Descargas\peajes-interurbanos-facturados-0003617963.csv is invalid

Exception Type: Exception

System.Exception: The CSV file format for X:\Descargas\peajes-interurbanos-facturados-0003617963.csv is invalid
at UiPath.Core.Activities.ScopeActivity.OnFaulted(NativeActivityFaultContext faultContext, Exception propagatedException, ActivityInstance propagatedFrom)
at System.Activities.Runtime.FaultCallbackWrapper.Invoke(NativeActivityFaultContext faultContext, Exception propagatedException, ActivityInstance propagatedFrom)
at System.Activities.Runtime.FaultCallbackWrapper.FaultWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)

this is how i send the path:

“X:\Descargas”+excelPrefijo+numFactura+".csv"

translated is:
Read CSV : The CSV file format for X:\Descargas\peajes-interurbanos-facturados-0003617963.csv is invalid

and this csv exits :confused: and if i open this “X:\Descargas\peajes-interurbanos-facturados-0003617963.csv” with the console or something the file is open . Any idea?


#2

By looking the Exception, it is saying File Format is not valid.

Have you tried to open it in Excel or Notepad?


#3

yes when i open it i use excel