public void readXLS(string FilePath) { FileInfo existingFile = new FileInfo(FilePath); using (ExcelPackage package = new ExcelPackage(existingFile)) { //get the first worksheet in the workbook ExcelWorksheet worksheet = package.Workbook.Worksheets[0]; int colCount = worksheet.Dimension.End.Column; //get Column Count int rowCount = worksheet.Dimension.End.Row; //get row count // first row is header for (int row = 2; row <= rowCount; row++) { string Unique_BenID = worksheet.Cells[row, 1].Text.Replace(" ", string.Empty).Replace(" ", string.Empty).Trim(); string StateName = worksheet.Cells[row, 2].Text.Replace(" ", string.Empty).Replace(" ", string.Empty).Trim(); string StateCode = worksheet.Cells[row, 3].Text.Replace(" ", string.Empty).Replace(" ", string.Empty).Trim(); string DistrictName = worksheet.Cells[row, 4].Text.Replace(" ", string.Empty).Replace(" ", string.Empty).Trim(); string DistrictCode = worksheet.Cells[row, 5].Text.Replace(" ", string.Empty).Replace(" ", string.Empty).Trim(); string SubDistrictName = worksheet.Cells[row, 6].Text.Replace(" ", string.Empty).Replace(" ", string.Empty).Trim(); string SubDistrictCode = worksheet.Cells[row, 7].Text.Replace(" ", string.Empty).Replace(" ", string.Empty).Trim(); string VillageName = worksheet.Cells[row, 8].Text.Replace(" ", string.Empty).Replace(" ", string.Empty).Trim(); string VillageCode = worksheet.Cells[row, 9].Text.Replace(" ", string.Empty).Replace(" ", string.Empty).Trim(); string Farmer_Name = worksheet.Cells[row, 10].Text.Replace(" ", string.Empty).Replace(" ", string.Empty).Trim(); string Father_Name = worksheet.Cells[row, 11].Text.Replace(" ", string.Empty).Replace(" ", string.Empty).Trim(); int intreturn = objdataImport.ImportDatatoDatabase(Unique_BenID, StateName, StateCode, DistrictName, DistrictCode, SubDistrictName, SubDistrictCode, VillageName, VillageCode, Farmer_Name, Father_Name); totaldatacount = totaldatacount + intreturn; } } }