code to expand columns in excel
===

When i export my data into excel, it loads up the columns but does not expand the columns so that it shows the data without having to double click on the line to expand the columns. is there code i can write so that it will automatically auto adjust so that the cells can show the entire data? i'm using asp.net and c#. the first picture is what it currently looks like.. the second shows what i want it to look like. 

![What it looks like][1]


![What I want it to look like][2]


  [1]: http://i.stack.imgur.com/m2OqQ.png


  [2]: http://i.stack.imgur.com/CLwoy.png

    protected void Button1_Click(object sender, EventArgs e)
    {
        Response.Clear();
        Response.Buffer = true;

        DataSet dataSet = new DataSet();

        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ISALog1ConnectionString"].ToString());
        SqlCommand cmd = new SqlCommand("exec ProxyReport", conn);
        cmd.CommandTimeout = 200;
        SqlDataAdapter ad = new SqlDataAdapter(cmd);
        ad.Fill(dataSet);

        GridView1.DataSource = dataSet.Tables[0];
        GridView1.DataBind();
        GridView2.DataSource = dataSet.Tables[1];
        GridView2.DataBind();
        GridView3.DataSource = dataSet.Tables[2];
        GridView3.DataBind();

        dataSet.Tables[0].TableName = "1";
        dataSet.Tables[1].TableName = "2";
        dataSet.Tables[2].TableName = "3";

        int count = 3;

        ExcelPackage pack = new ExcelPackage();

        
        for (int i = 1; i <= count; i++)
        {
            DataTable table = dataSet.Tables[i.ToString()];
            ExcelWorksheet ws = pack.Workbook.Worksheets.Add("Top" + i);
            ws.Cells["A1"].LoadFromDataTable(table, true);
        }  

                Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
                Response.AddHeader("content-disposition", "attachment;  filename=ExcelExport.xlsx");
                Response.BinaryWrite(pack.GetAsByteArray());
                Response.Flush();
                Response.End();
      }
