Excel reading

Question

Hello All,

 

Here i am using EPPlus dll and read the excel.

 

below my code:

 

 

public JsonResult UpdateFHSerialNumber(string strExcelPath)

{

    try

   {

         string cell = string.Empty;         

         Stream str = strExcelPath;

         //FileInfo file = new FileInfo(Request.Files["file_Rel_FH_SrNum_Name"].FileName);

         using (ExcelPackage excelPkg = new ExcelPackage())

            {

                     ExcelWorksheet oSheet = excelPkg.Workbook.Worksheets[1];

                     cell = oSheet.Cells[4, 3].Value.ToString();

            }

return Json{ error = read sucessfully});

}

 

in above code i comment fileinfo it's working in local system not working in server.

 

if working with action results it's working. but i need JsonResult so suffering with path

 

 

if i am using action results

 

public ActionResult Index(HttpPostedFileBase file)

 

i get excel file and read easy but i am using Jsonresult i get only path how can i read excel file using path