Import Excel and display in Ag Grid

Question

Hi Guys I want Import Excel and display in Ag Grid with validation show in the grid like non validated rows shown in red. Thanks & Regards

Harshal Limaye · Answer

Try this https://www.ag-grid.com/documentation/javascript/excel-import/

Laxmidhar Sahoo · Answer

hey whether your AG gris has only one column

Ajay Gohil · Answer

@Laxmidhar Sahoo used datatable it's more suitable

Laxmidhar Sahoo · Answer

@Ajay hey The excel has multiple colums .So insted of use list of string use generic class that has multi[ple attribute or use datatable which is more suitable

Ajay Gohil · Answer

hello try this for import excel in c# public JsonResult UploadExcel(HttpPostedFileBase FileUpload) { List string > data = new List string >(); if (FileUpload != null ) { if (FileUpload.FileName.EndsWith( .xls ) || FileUpload.FileName.EndsWith( .xlsx )) { List int > lstint = new List int >(); //FileInfo fileInfo = new FileInfo(pathToExcelFile); ExcelPackage package = new ExcelPackage(FileUpload.InputStream); ExcelWorksheet worksheet = package.Workbook.Worksheets.FirstOrDefault(); int rows = worksheet.Dimension.Rows; int columns = worksheet.Dimension.Columns; for ( int i = 2; i { for ( int j = 1; j { string content = worksheet.Cells[i j].Value.ToString(); if (Convert.ToBoolean(worksheet.Cells[i columns].Value.ToString())) lstint.Add(Convert.ToInt32(content)); break ; /* Do something ...*/ } } return Json(PropertyAgentResource.msgExcelFileImportSuccessfully JsonRequestBehavior.AllowGet); } else { data.Add(PropertyAgentResource.msgOnlyExcelFileFormatIsAllowed); data.ToArray(); return Json(data JsonRequestBehavior.AllowGet); } } else { if (FileUpload == null ) data.Add(PropertyAgentResource.msgPleaseChooseExcelFile); data.ToArray(); return Json(data JsonRequestBehavior.AllowGet); } }