Tech
Forums
Jobs
Books
Events
Live
Interviews Prep
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
2
Reply
multiple Excel files download
Hareesh Bollepalli
Sep 3 2015 4:08 AM
931
Reply
Hello All
Here I need to download multiple Excel sheets i use for loop. after one iterate loop I got am Exception like below
Server cannot append header after HTTP headers have been sent.
try
{
for(some condition)
{
//some code grid view//
Response.ClearContent();
Response.Buffer = true;
long lnUserID = clsLists.getCurrentUserId();
Response.AddHeader("content-disposition", "attachment; filename=Release-" + ReleaseEMCTSDB.users.SingleOrDefault(u => u.UserId ==
l
nUserID).UserName + "-" + DateTime.Now.ToString() + ".xls");
Response.AppendHeader("Name", "Value");
Response.ContentType = "application/ms-excel";
Response.Charset = "";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
string readergridview = sw.ToString();
gv.RenderControl(htw);
Response.Output.Write(sw.ToString());
Resp onse.Flush();
Response.End();
}
}
try
{
Exception
}
Please help me it is possible to iterate loop
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
Memory
Input string was not in correct format