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;
}
}
}