Gridview directly printing or Excel Adjust for printing in A4 size page

See more:

ASP.NET

Hi
in my website i have a gridview and two buttons to save that gridview in Excel and Pdf
i can able to save that one but when i trying to print the saved excel sheet the columns are splitted to the different cells.I tried to adjust the cells but it will be a big process which client didnt accept.
I want either of the fallowing solutions
solution1:while saving the as Excel it has to fit automatically fit for A4 size Landscape printing

OR

solution 2:
I have to provide a print button which prints directly the whole page in Landscape mode

How to do that

I used the fallowing code to print in Excel

Response.ClearContent();
        Response.Buffer = true;
        Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "GOMSNO747.xls"));
        Response.ContentType = "application/ms-excel";
        StringWriter sw = new StringWriter();
        HtmlTextWriter htw = new HtmlTextWriter(sw);
        GridView1.AllowPaging = false;
        GridView1.DataBind();
        //Change the Header Row back to white color
        GridView1.HeaderRow.Style.Add("background-color", "#FFFFFF");
        //Applying stlye to gridview header cells
        for (int i = 0; i < GridView1.HeaderRow.Cells.Count; i++)
        {
            GridView1.HeaderRow.Cells[i].Style.Add("background-color", "#507CD1");
        }
        int j = 1;
        //This loop is used to apply stlye to cells based on particular row
        foreach (GridViewRow gvrow in GridView1.Rows)
        {
            //gvrow.BackColor = Color.White;
            if (j <= GridView1.Rows.Count)
            {
                if (j % 2 != 0)
                {
                    for (int k = 0; k < gvrow.Cells.Count; k++)
                    {
                        gvrow.Cells[k].Style.Add("background-color", "#EFF3FB");
                    }
                }
            }
            j++;
        }
        GridView1.RenderControl(htw);
        Response.Write(sw.ToString());
        Response.End();

my Page Address is:
http://ulchyd.in/GOMSNO747.aspx[^]