Webdev.webserver.exe was blocked to delete the file

Hi Anand

    Thanks for ur reply i m using EPPLUS Dll and i already dispose the objects of the excel package but still i got the same error .here i attach my coding for ur reference


 public static void exportToEPPExcelFile(DataTable data)
    {
        try
        {
            string path = ConfigurationManager.AppSettings["attachments"].ToString();


            ExcelPackage ep = new ExcelPackage();

            ExcelWorksheet ews = ep.Workbook.Worksheets.Add("PTP");

            DataTable dt = data;

            int colcnt = dt.Columns.Count;
            int rowcnt = dt.Rows.Count;

            string rowsCellRange = "A2:" + Convert.ToChar('A' + dt.Columns.Count - 1) + dt.Rows.Count * dt.Columns.Count;

            ews.Cells["A1"].LoadFromDataTable(dt, true, OfficeOpenXml.Table.TableStyles.None);

            ews.Cells[1, 1, 1, colcnt].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid;
            ews.Cells[1, 1, 1, colcnt].Style.Fill.BackgroundColor.SetColor(Color.FromArgb(0, 100, 0));
            ews.Cells[1, 1, 1, colcnt].Style.Font.Color.SetColor(Color.White);
            ews.Cells[1, 1, 1, colcnt].Style.Font.Bold = true;
            ews.Cells[1, 1, 1, colcnt].Style.WrapText = true;

            // ews.Cells[1, 1, 1, colcnt].AutoFilter = false;

            ews.Cells[1, 1, 1, colcnt].AutoFitColumns(8);
            //ews.Cells[1, 1, 1, colcnt].AutoFitColumns();
            ews.Cells[1, 1, 1, colcnt].Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;


            //FileInfo fi = new FileInfo( );
            FileInfo fi = new FileInfo(path + @"\report.xlsx");

            if (fi.Exists)
            {
                fi.Delete();
            }

            ep.SaveAs(fi);
            ep.Dispose();

        }
        catch (Exception ex)
        {
            string hh = ex.ToString();
          
           
        }
           


    }






 waiting for ur reply

Hi,

When you create first time xlsx file after that dispose your streamreader and streamwriter object.

if you dont dispose them current file is in open state. thats your application restrict you to delete your file first.

Please mark it as answer . If u satisfied with the suggestion

Regards,
Ravi