Export to Virtual folder from excel and Gridview

See more:

C#

ASP.NET

Hi,

i am trying to export a gridview to excel in a dynamic directory which gets created earlier in the code.

but as soon as the code for the export to excel is run it gives error is not a valid path.

i have tried several suggestions but all gives me the same error please see code below

Response.AddHeader("content-disposition",
            "attachment;filename=Stockout_" + lblprevmnthname.Text + @"_" + lblyear.Text + ".xls");
            Response.Charset = "";
            Response.ContentType = "application/vnd.ms-excel";
            StringWriter sw = new StringWriter();
            HtmlTextWriter hw = new HtmlTextWriter(sw);
            GridView1.RenderControl(hw);
            string folderYear = lblyear.Text;
            string folderMonth = lblprevmnthname.Text;
            string serverDirectory = Server.MapPath("~/Monthly/" + folderYear + @"/" + folderMonth + @"/warehouse/" + "Stockout_" + lblprevmnthname.Text + @"_" + lblyear.Text + ".xls");
            var pathwarehouse = Server.MapPath(serverDirectory);
            File.WriteAllText(pathwarehouse, sw.ToString());
            GridView1.AllowPaging = false;
            GridView1.DataBind();