Import Excel and display in Ag Grid

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 <= rows; i++)
{
for(int j = 1; j <= columns; 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);
}
}

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Harshal Limaye5y ago
Try this,

https://www.ag-grid.com/documentation/javascript/excel-import/
+1
Laxmidhar Sahoo6y ago
hey
whether your AG gris has only one column
+1
Ajay Gohil6y ago
@Laxmidhar Sahoo used datatable it's more suitable
+1
Laxmidhar Sahoo6y ago
@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
+1
Ajay Gohil6y ago
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 <= rows; i++)
            {
                for(int j = 1; j <= columns; 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);
    }
}
+1