Read csv from fourth row

Help Forum
#1

Hi,

I am required to read a csv file from fourth row like we read excel file.

Thanks in advance

#2

Hi

Welcome back to UiPath forum

We won’t be able to directly read from 4th row using READ CSV activity

But we can manipulate later with the output we get as datatable

  1. That is use read csv and get the output as dt

  2. Then use a assign activity to skip the first four rows in that datatable
    Like this

dt = dt.AsEnumerable().Skip(4).CopyToDatatable()

Skip(4) – it allows you to set the number of Rows that you want to Skip from DataTable

Hope this would help you resolve this

Cheers @anjankum

1 Like
#3

Thank you for your quick response. Let me elaborate the problem I am facing.
I have a .csv file that has 2 columns in the first row and around 10 entries starting from third row. thus throws the following error while reading :
“Read CSV: The CSV file format for xxx.csv is invalid. Line 3 contains more values than the header line.”

Request your suggestion…

#4

Hmm fine
I’m that case let’s use EXCEL APPLICATION SCOPE and pass that csv filepath as input

And inside the scope use a READ RANGE activity where mention the start cell alone as cell range like “A4”

This will datatable as output

@anjankum

#5

thank you :slight_smile:

#6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.