Click here to Skip to main content
15,880,608 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
C#
Response.ClearContent();
Response.Buffer = true;
System.IO.StringWriter sw = new System.IO.StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "Summary Report " + _startDate.ToString("m") + " to " + _endDate.ToString("m") + ".xls"));
Response.ContentType = "application/ms-excel";
SummaryGrid.HeaderStyle.BackColor = System.Drawing.Color.LightGray;
SummaryGrid.GridLines = GridLines.Both;
SummaryGrid.RenderControl(htw);
this.ClearControls(TimeEntryGrid);
TimeEntryGrid.AllowPaging = true;
TimeEntryGrid.Columns[7].ItemStyle.Width = 450;
TimeEntryGrid.Columns[7].ItemStyle.HorizontalAlign = HorizontalAlign.Left;
TimeEntryGrid.HeaderStyle.BackColor = System.Drawing.Color.LightGray;
TimeEntryGrid.GridLines = GridLines.Both;
TimeEntryGrid.RenderControl(htw);
Response.Write(sw.ToString());
Response.End()


SummaryGrid and TimeEntryGrid are two Datagrids. I want to separate them into two sheets WITHOUT using any references or libraries while preserving the format of datagrids. How do I split them into two sheets in excel? Or other there any other ways to format the datagrids so that they will not be joined together vertically in one sheet?
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900