Creating an Excel file with multiple sheets

Question

Do you make this code to create an Excel spreadsheet with two tabs? This only does one presently.

string attachment = string.Empty;
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);

HtmlForm frm = new HtmlForm();
frm.Attributes["runat"] = "server";

attachment = "attachment; filename=MyFile.xls";
GridView1.Parent.Controls.Add(frm);
frm.Controls.Add(GridView1);

Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/ms-excel";

frm.RenderControl(htw);

Response.Write(sw.ToString());

Response.End();

MyFile.xls, does it exist already or is the system supposed to be creating it. If it exists, check what its defaults are, otherwise, look into command line and initialization defaults in excel, there are ways to change what excel defaults new files to — Nevyn
– Nevyn, Commented Feb 4, 2013 at 18:35

Dragan Radivojevic · Accepted Answer · 2013-02-04 18:48:33Z

1

I'm pretty sure you can't do it unless you're using MS Office Interop assemblies for Excel or some library such as Open XML SDK.

Note that you are not creating genuine excel file with the method above but just tricking excel into opening data you sent as if those are genuine excel files. This is why you'll most probably get warning message when opening this in MS Excel.

answered Feb 4, 2013 at 18:48

Dragan Radivojevic

2,0022 gold badges14 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Kurisu · Accepted Answer · 2013-02-04 18:57:27Z

0

There appears to a Microsoft Article detailing how to export data from an application into Excel, although it's a bit dated (2005) http://support.microsoft.com/kb/306023

It appears to cover multiple worksheets, although I've never used these methods myself.

answered Feb 4, 2013 at 18:57

Kurisu

8521 gold badge10 silver badges18 bronze badges

Collectives™ on Stack Overflow

Creating an Excel file with multiple sheets

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related