Hi
I am downloading a csv file from a web page but couldn’t able to read.
Read range throwing error.
Here is the error:
RemoteException wrapping System.Exception: The CSV file format for resources\Test-download.csv is invalid
at UiPath.CSV.Activities.ReadCsvFile.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.System.Activities.IAsyncCodeActivity.FinishExecution(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)
@KarthikBallary Most Probably the Data in CSV file is not Actually in CSV Format. If you open that File in Notepad, you’ll notice that SL.No and Name are in the Same Column that are separated by tab and also Double Quotes are surrounded. This might be the cause of Read CSV not recognizing the file. If you can correct this format, it would be good. Else we would need to apply some other methods to convert it to a proper CSV.
In my environment, Read CSV can read both “downloadFikterTest.csv” and “New Text Document.csv” without error.
Do you have any error in reading these csv file in your environment?
In generate data table I get only column separartor options by tab, space, new line. But it was better if it was comma. And if I select tab…some rows getting dstrubed
But I have one more issue. Before headers have some description part how to remove it?
if split string—strVar.remove(0, Split(strVar,EnvironmentVariable.newLine)(0).length)
will show empty dt