I'm fairly new to C# but in VBA, I was able to get the last active cell in a column by:
So, how can I do the same in C#? I think I've started on the right foot, but not sure what to do next.
xlApp = new Excel.ApplicationClass();
xlWorkBook = xlApp.Workbooks.Open(strPath + strFile, 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);
Thank you in advance to all the helpers.