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, "\t", 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
There is Rows
property using which you can access first row of particular range:
var firstRow = range.Rows[1];
Try:
xlWorkSheet.Range("A1", "A1").EntireRow.Value;
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With