protected void btnUpload_Click(object sender, EventArgs e) { string fileName = GeneralUtility.GetExcelFile(xlsxSchol); if (!String.IsNullOrEmpty(fileName)) { var ExcelResult = ExcelPlus.ReadExcel(fileName, 2); DataTable dt = new DataTable(); dt.Columns.Add("ID"); dt.Columns.Add("Firstname"); dt.Columns.Add("Lastname"); dt.Columns.Add("Othername"); dt.Columns.Add("Address"); dt.Columns.Add("Origin"); dt.Columns.Add("LGA"); dt.Columns.Add("DOB"); dt.Columns.Add("Sex"); dt.Columns.Add("GName"); dt.Columns.Add("GAddress"); dt.Columns.Add("GPhone"); dt.Columns.Add("GEmail"); dt.Columns.Add("Relation"); for (int i = 0; i < ExcelResult.Tables[0].Rows.Count; i++) { // string STUDENT_ID = Convert.ToString(ExcelResult.Tables[0].Rows[i][1]); string ID = Convert.ToString(ExcelResult.Tables[0].Rows[i][0]); string Name = Convert.ToString(ExcelResult.Tables[0].Rows[i][1]); string Lastname = Convert.ToString(ExcelResult.Tables[0].Rows[i][2]); string Othername = Convert.ToString(ExcelResult.Tables[0].Rows[i][4]); string Address = Convert.ToString(ExcelResult.Tables[0].Rows[i][5]); string Origin = Convert.ToString(ExcelResult.Tables[0].Rows[i][3]); string LGA = Convert.ToString(ExcelResult.Tables[0].Rows[i][6]); string DOB = Convert.ToString(ExcelResult.Tables[0].Rows[i][7]); string Sex = Convert.ToString(ExcelResult.Tables[0].Rows[i][8]); string GName = Convert.ToString(ExcelResult.Tables[0].Rows[i][9]); string GAddress = Convert.ToString(ExcelResult.Tables[0].Rows[i][10]); string GPhone = Convert.ToString(ExcelResult.Tables[0].Rows[i][11]); string GEmail = Convert.ToString(ExcelResult.Tables[0].Rows[i][12]); string Relation = Convert.ToString(ExcelResult.Tables[0].Rows[i][13]); dt.Rows.Add(ID, Name, Lastname, Othername, Address, Origin, LGA, DOB, Sex, GName, GAddress, GPhone, Relation); } gvResult.DataSource = dt; gvResult.DataBind(); excelDiv.Visible = true; gvResult.HeaderRow.TableSection = TableRowSection.TableHeader; } else { } }
protected void btnUpload_Click(object sender, EventArgs e) { //HttpPostedFileBase file = xlsxSchol.PostedFile. var fileName = GeneralUtility.GetExcelFile(xlsxSchol); if (!String.IsNullOrEmpty(fileName)) { var ExcelResult = ExcelPlus.ReadExcel(fileName, 2); DataTable dt = new DataTable(); dt.Columns.Add("ID"); dt.Columns.Add("Name"); dt.Columns.Add("Address"); dt.Columns.Add("Email"); dt.Columns.Add("MobileNo"); dt.Columns.Add("LGA"); dt.Columns.Add("Type"); dt.Columns.Add("Category"); dt.Columns.Add("DateOfInCorporation"); dt.Columns.Add("PrincipalName"); for (int i = 0; i < ExcelResult.Tables[0].Rows.Count; i++) { // string STUDENT_ID = Convert.ToString(ExcelResult.Tables[0].Rows[i][1]); string ID = Convert.ToString(ExcelResult.Tables[0].Rows[i][0]); string Name = Convert.ToString(ExcelResult.Tables[0].Rows[i][1]); string Address = Convert.ToString(ExcelResult.Tables[0].Rows[i][2]); string Email = Convert.ToString(ExcelResult.Tables[0].Rows[i][4]); string MobileNo = Convert.ToString(ExcelResult.Tables[0].Rows[i][5]); string LGA = Convert.ToString(ExcelResult.Tables[0].Rows[i][3]); string Type = Convert.ToString(ExcelResult.Tables[0].Rows[i][6]); string category = Convert.ToString(ExcelResult.Tables[0].Rows[i][7]); string DateOfInCorporation = Convert.ToString(ExcelResult.Tables[0].Rows[i][8]); string PrincipalName = Convert.ToString(ExcelResult.Tables[0].Rows[i][9]); dt.Rows.Add(ID, Name, Address, Email, MobileNo, LGA, Type, category, DateOfInCorporation, PrincipalName); } gvResult.DataSource = dt; gvResult.DataBind(); excelDiv.Visible = true; } else { } }