<pre> int rCnt; int cCnt; string workbookPath = "f:\\Test\\TestData.xlsx"; Excel.Application excelApp; Excel.Workbook excelWorkbook; Excel.Sheets excelSheets; Excel.Worksheet excelWorksheet; Excel.Range range; string currentSheet = "DataSet"; excelApp = new Excel.Application(); excelWorkbook = excelApp.Workbooks.Add(workbookPath); excelSheets = excelWorkbook.Sheets; excelWorksheet = (Excel.Worksheet)excelSheets.get_Item(currentSheet); range = excelWorksheet.UsedRange; for (rCnt = 2; rCnt <= range.Rows.Count; rCnt++) { for (cCnt = 1; cCnt <= range.Columns.Count; cCnt++) { Loginname = (string)(range.Cells[rCnt, cCnt] as Excel.Range).Value; Password = (string)(range.Cells[rCnt, cCnt] as Excel.Range).Value; }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)