Delete 1st row from excel

[shivaKumarVS]

Actual data starts from 3rd row with header, 1st 2 rows are dummy row

[Emil_Kos]

Hi @shivaKumarVS,

The easiest solution will be start importing the data from the relevant line:

Please see point 7 and change the value to the required value. 

[shivaKumarVS]

That option i am not finding.

1 Record Limit
2 File Format Microsoft Excel 1997-2003 (*.xls) Microsoft Excel 1997-2003 (*.xls)
3 Table or Query `Sheet1$` ...
4 Search SubDirs False False
5 Output File Name as Field No No
6 First Row Contains Data False False
7 Do Not Show % Complete False False

[Emil_Kos · Accepted solution]

Hi @shivaKumarVS,

Please check the alternative solution:

Output:

[shivaKumarVS]

it worked Thanks for reply

i have kept 3+ 

& set the below condtion in inputdata.

6 First Row Contains Data True True

Can you also please help me in deleting the last row.

[OllieClarke]

Hi @shivaKumarVS you can also use a sample tool to skip the first N rows of data.

Hope that helps