if Excel file uploading on Godadday Server that time Error

if Excel file is uploading that time THis Error Occured Please help me...

I have attached Error please check and Suggest me.

below code is Excel File Uploading

public ActionResult UploadExcel()
{
try
{
int intUploadedFiles = Request.Files.Count;
var files = Request["File"];
HttpPostedFileBase file = Request.Files[0];
var fileName = Path.GetFileName(file.FileName);
if (file != null)
{
string strPath = "/ExcelFilePaySlipUploadMonthly/";
if (!System.IO.Directory.Exists(Server.MapPath(strPath)))
{
System.IO.Directory.CreateDirectory(Server.MapPath(strPath));
}
file = Request.Files[0];
fileName = Path.GetFileName(file.FileName);
System.IO.DirectoryInfo dir = new System.IO.DirectoryInfo(Server.MapPath(strPath));
int count = dir.GetFiles().Length;
fileName = fileName.Substring(0, fileName.IndexOf('.')) + "_" + DateTime.Now.Millisecond + "-" + DateTime.Now.Second + "-" + DateTime.Now.Minute + "-" + DateTime.Now.Hour + "-" + DateTime.Now.Day + "-" + DateTime.Now.Month + "-" + DateTime.Now.Year + "." + fileName.Substring(fileName.IndexOf('.') + 1);
var path = Path.Combine(Server.MapPath(strPath), fileName);
file.SaveAs(path);
var excel = new ExcelQueryFactory(path);
var punr = (from a in excel.Worksheet("PaySlip")
select a).Skip(1);
List lst = (from _data in punr
select new ViewModel.Admin.PaySlip_SalaryData()
{
Month = _data[1],
Year = _data[2],
Location = _data[3],
Emp_Code = _data[4],
Department = _data[5],
Designation = _data[6],
Name = _data[7],
UAN_No = _data[8],
ESIC_No = _data[9],
Bank_Name = _data[10],
Bank_Account_No = _data[11],
Present_Days = _data[12],
Absent_Days = _data[13],
Basic =String.Format("{0:N}",Math.Round(Convert.ToDecimal(_data[14]))),
HRA = String.Format("{0:N}", Math.Round(Convert.ToDecimal(_data[15]))),
CONVEYANCE = String.Format("{0:N}", Math.Round(Convert.ToDecimal(_data[16]))),
Special_Allowance = String.Format("{0:N}", Math.Round(Convert.ToDecimal(_data[17]))),
Gross = String.Format("{0:N}", Math.Round(Convert.ToDecimal(_data[18]))),
PF_Emp = String.Format("{0:N}", Math.Round(Convert.ToDecimal(_data[19]))),
ESIC_Emp = ( _data[20]),
PT = _data[21],
TDS = _data[23],
Variable_Salary = _data[24],
Salary_Advance = _data[25],
LWF = _data[26],
Total_Deduction = String.Format("{0:N}", Math.Round(Convert.ToDecimal(_data[27]))),
Net_salary = String.Format("{0:N}", Math.Round(Convert.ToDecimal(_data[28]))),
PF_Comp = _data[29],
ESIC_Comp = _data[30],
Total_CTC = String.Format("{0:N}", Math.Round(Convert.ToDecimal(_data[31]))),
Leave_Balance_PL = _data[32],
Leave_Balance_GL = _data[33],
Other = String.Format("{0:N}", Math.Round(Convert.ToDecimal(_data[34])))
}).ToList().FindAll(m => !string.IsNullOrEmpty(m.Emp_Code));
TempData["SalList"] = lst;
}
ViewModel.Admin.PaySlip_SalaryData d = new ViewModel.Admin.PaySlip_SalaryData();
return PartialView("UploadExcel", d);
}
catch(IOException e)
{
return View();
}
}

5 Replies

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

Sonu Gupta7y ago
As per attached snap shot i am unable to undertstand exact exception.

You try to increase the file upload size in web.config file, Dot Net by default allow max 4mb.

Code for increase file upload size -
Kalyani Shevale7y ago
I have attached File
Sonu Gupta7y ago
Hi Kalyani.

What are the exception?
Kalyani Shevale7y ago
I have changed Permission of that folder but still not working.
Sonu Gupta7y ago
Hi,

Check the read/write permision on that folder, you want to upload it excel file.