How do I read only one row from the excel sheet?

excel

#1

Hi,

I want to read only one row from excell sheet. and that too without the header
I want to do this for 5 excel files. (read only single row from these files)
Please be quick if possible.

Thanks and Regards,
hacky_wacky


#2

Hi @hacky_wacky,

use read range activity to get the data table.(MyDataTable)
use the below code to get first record alone.
MyDataTable=MyDataTable.AsEnumerable().Take(1).CopyToDataTable()

Regards,
Arivu