Excel Reading from a not standart column

[Mike987 (Mike)]

Hello, i found online an excel sample and tried to read specific column from it, but it didn’t succeed.
Employee-Management-Sample-Data.xlsx (8.0 KB)

[vrdabberu (Varunraj Dabberu)]

Hi @Mike987

Try Reading the excel in Read Range Workbook by giving Range as "B6".

In For Each row in DataTable please print the values based on column Index or Column Name. In your case you can print in below in either of the ways:

CurrentRow(3).ToString or CurrentRow("Designation").ToString

As per your requirement you wanted to read column D i.e Designation column you will get below as output @Mike987

Regards

[aravindbalineni123 (Aravind Balineni)]

Hi @Mike987

If the error you are getting is “The sheet does not exist” then the issue is you are using the wrong sheet name instead use “Sheet1” here:

and the start range should be B6