Excel sheets select first row with c#

Question

I want to select excel sheets first row using interop object. How can i do ? ``` xlWorkBook = xlApp.Workbooks.Open(directory, 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "	", false, false, 0, true, 1, 0); xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1); range = xlWorkSheet.UsedRange; var List<string> tempList= range[1,*].Value.ToList(); ``` I want to write similar as abow. How can I write this situation

Accepted Answer

Try:

```
xlWorkSheet.Range("A1", "A1").EntireRow.Value;
```

Excel sheets select first row with c#

Solution

Problem