Actual data starts from 3rd row with header, 1st 2 rows are dummy row
Hi @shivaKumarVS,Please check the alternative solution:
Output:
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.
That option i am not finding.
1 Record Limit2 File Format Microsoft Excel 1997-2003 (*.xls) Microsoft Excel 1997-2003 (*.xls)3 Table or Query `Sheet1$` ...4 Search SubDirs False False5 Output File Name as Field No No6 First Row Contains Data False False7 Do Not Show % Complete False False
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.
