FAQ - Frequently Asked Questions

Re: How To: Make "Export to Excel" always open excel in a separate Window

vsurana — Thu, 01 Oct 2009 12:46:22 GMT

Hello

I have an Excel File that refreshes when it opens.

Now I need to open that File through Asp.net code and then save file and close that file.

then Finally read data into access.

So, how to perform the task, can anyone help.

Please its urgent

thanks in advance

Re: How To: Make "Export to Excel" always open excel in a separate Window

Noonway — Tue, 24 Mar 2009 14:41:08 GMT

I had this same problem with IE being unable to find the file and it took me a couple of hours to figure out that I had disabled DDE in excel to prevent all my excel spreadsheets from opening up in the same window. In Office 2007 click on Excel Options then under Advanced-->General there is an "Ignore other applications that use Dynamic Data Exchange (DDE)" I had that option checked. As soon as I unchecked it, the excel opened right up on the next web call.... Now to get to the formatting.

Re: How To: Make "Export to Excel" always open excel in a separate Window

srinmal — Fri, 05 Sep 2008 19:43:29 GMT

Hello Ryan,

Thanks for the nice post, I have samll query, my webpage where the GridView has master page and because of this I am getting an error syaing that place inside a webform with runat=server error.

Could you please hlep to resolve this? and also could you please send the code of clearcontrols function code in VB

Re: How To: Make "Export to Excel" always open excel in a separate Window

ckmurthy — Thu, 28 Aug 2008 08:34:26 GMT

Hi Ryan,

I am new to asp.net ,i have one requirement ,that is uploading the HTML page into the database and displyng through gridview.

if you have any code plz give me,

how to do this ,plz help me.

Thanks in advance

Re: How To: Make "Export to Excel" always open excel in a separate Window

happylife_80 — Sat, 23 Aug 2008 11:42:32 GMT

Hi Ryan

i want to export my gridview to pdf document, i used iTextSharp library, everything is fine but the problem is that

pdf document did not take the GridView Syle like headerStyle, RowStyle, color, font...etc

and here is my code

Public Shared Sub FromGridView(ByVal Grid As GridView, ByVal ReportName As String)

Dim sw As New StringWriter()

Dim htw As New HtmlTextWriter(sw)

Dim page As New Page

Dim form As New HtmlForm

Dim GridStyle As String

page.Controls.Add(form)

form.Controls.Add(Grid)

form.RenderControl(htw)

GridStyle = sw.ToString()

'Set up the response

HttpContext.Current.Response.Clear()

HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename=" & ReportName & Date.Now.ToShortTimeString & ".pdf")

HttpContext.Current.Response.Charset = ""

HttpContext.Current.Response.ContentType = "application/pdf"

'Create pdf document

Dim PdfDocument As New iTextSharp.text.Document(PageSize.A4)

'Create pdf writer, output directly to OutputStream

Dim writer As pdf.PdfWriter = pdf.PdfWriter.GetInstance(PdfDocument, HttpContext.Current.Response.OutputStream)

PdfDocument.Open()

'Create tempfile to hold the HTML:

'Dim tempFile As String = Path.GetTempFileName()

'Using tempwriter As New StreamWriter(tempFile, False)

' tempwriter.Write(GridStyle)

'End Using

Dim _xmlr As New System.Xml.XmlTextReader(New StringReader(GridStyle))

'Parse the HTML into the document

iTextSharp.text.html.HtmlParser.Parse(PdfDocument, _xmlr)

'Cleanup

PdfDocument.Close()

writer.Close()

'Delete the tempfile:

'File.Delete(tempFile)

writer = Nothing

PdfDocument = Nothing

HttpContext.Current.Response.[End]()

End Sub

can you help me or give me another solution

thanx

Re: How To: Make "Export to Excel" always open excel in a separate Window

jeyaseelan@ajsquare.net — Thu, 14 Aug 2008 07:27:29 GMT

Hai Anubha,

Thanks for your response. I tried this code it's working, i export the records into the excel and open it there is all images with data. if i paste this excel file to another system and open the excel file then there is no image found, could you please tell me why no images will display in another machine?

Re: How To: Make "Export to Excel" always open excel in a separate Window

anubha.saxena — Thu, 14 Aug 2008 07:11:53 GMT

using System;

using System.IO;

using System.Data;

using System.Configuration;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Text;

/// <summary>

/// Summary description for Class3

/// </summary>

public class Class3

{

public Class3()

{

}

public void Convert( DataSet ds, HttpResponse response)

{

//*********Export to Excel**************

//first let's clean up the response.object

response.Clear();

response.Charset = "";

//set the response mime type for excel

response.ContentType = "application/vnd.ms-excel";

//create a string writer

System.IO.StringWriter stringWrite =new System.IO.StringWriter();

//create an htmltextwriter which uses the stringwriter

HtmlTextWriter htmlWrite=new HtmlTextWriter(stringWrite);

//instantiate a datagrid

DataGrid dg=new DataGrid();

//set the datagrid datasource to the dataset passed in

dg.DataSource = ds.Tables[0];

//bind the datagrid

dg.DataBind();

//tell the datagrid to render itself to our htmltextwriter

dg.RenderControl(htmlWrite);

//all that's left is to output the html

response.Write(stringWrite.ToString());

response.End();

}

Re: How To: Make "Export to Excel" always open excel in a separate Window

jeyaseelan@ajsquare.net — Wed, 23 Jul 2008 12:36:30 GMT

Hi to StrongTypes ,

I have some image in the gridview when upload this to excel but there is no images found, may i know why no images uploaded into Excel file? Please give a code lot of days i tried this task.......

Re: How To: Make "Export to Excel" always open excel in a separate Window

maham — Sat, 29 Mar 2008 04:51:59 GMT

Thanx for all of you as i got the solution by marius.poenari.

thanx a lot

Re: How To: Make "Export to Excel" always open excel in a separate Window

marius.poenari — Fri, 28 Mar 2008 13:21:11 GMT

To avoid the IE6-specific problem of the .xls file not being found in the "temporary internet files\Content.IE5" folder, in addition to the snippets presented above, you have to do the following:

Response.ClearHeaders();
Response.CacheControl = "Public";

The idea is that by default the Response had set the "no-store" attribute, and because of this immediatly after open and download the document is deleted from Temporary Internet Files.

So what you have to do is Response.ClearHeaders() before setting your own attributes.

snippet:

                    Response.ClearHeaders();
                    Response.CacheControl = "Public";
                    Response.Charset = "";
                    Response.AddHeader("Content-Disposition", "attachment; filename=file.xls");
                    Response.ContentType = "application/vnd.ms-excel";
                    Response.BinaryWrite(yourExcelStream.ToString());

Re: How To: Make "Export to Excel" always open excel in a separate Window

sanjuvrm — Wed, 19 Mar 2008 10:46:25 GMT

I have implementes above both type writen code but i am geting the error like....

" System.Web.HttpException: Control 'GridView'Test' of type 'GridView' must be placed inside a form tag with runat=server. "

Thanks

Sanjay Verma

Re: How To: Make "Export to Excel" always open excel in a separate Window

maham — Sat, 26 Jan 2008 10:47:16 GMT

I've used the exact code given by u but it gives the error

"Control 'ctl00_ContentPlaceHolder1_SearchBox1_gv_Shops' of type 'GridView' must be placed inside a form tag with runat=server."

i'm using the master page layout and grid is in web user control and placed in side a content page and it has no form tag.

what can i do for this

Please let me know as soon as possible

Thanx

Re: How To: Make "Export to Excel" always open excel in a separate Window

jgreenst — Wed, 23 Jan 2008 15:03:06 GMT

jaishankar2704:
Hi ALL.. Try this, its working.....

Response.Clear();

Response.AddHeader("content-disposition", "attachment;filename=EmployeeProjectReport.xls");

Response.Charset = "";

Response.Cache.SetCacheability(HttpCacheability.NoCache);/p>
Response.ContentType = "application/vnd.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
pnldetail.RenderControl(htmlWrite);

Response.Write(stringWrite.ToString());

Response.End();

The above will work in IE7, but in IE6 if you try to "open" the file rather than save it, you will most likely get the "...xls could not be found" message in Excel because the Excel file will be deleted from the cache before Excel can open it. Remove the following line: Response.Cache.SetCacheability(HttpCacheability.NoCache); and change the content type to the following: Response.ContentType = "application/vnd.ms-excel"; and it will work in IE6 as well as Firefox. Also make sure that you do not have caching disabled in the OutputCache directive of your .aspx file.

Re: How To: Make "Export to Excel" always open excel in a separate Window

davidgreenbe — Fri, 30 Nov 2007 14:23:47 GMT

This is probably not a permissions issue.

I can run the program and let it go to the prompt where it asks to open/save/cancel the spreadsheet. At this point, I can go and look in the temp folder c:\documents and settings\myuser\local settings\temporary internet files\content.ie5 and see my output .xls file that has been successfully created and placed in this folder. If I copy this file somewhere and open it in Excel it looks fine.

Therefore, I would assume the permissions were adequate since the file was created successfully in this folder.

Also, by the way, if I choose the "Save" option, it always works where I can download the file out of the content.ie5 folder and open the .xls file on the local drive so I guess this is a third workaround but obviously less then ideal.

Then, if I choose the "Open" option instead, and I get the error about the missing file, I see where something has erased the .xls from the c:\documents and settings\myuser\local settings\temporary internet files\content.ie5 between the point of clicking on the Open button and the point I get the missing file error.

Once again, I am left with the theory that this is a timing thing where something is trying to clean up the file in the content.ie5 folder before Excel has a chance to grab it.

David

Re: How To: Make "Export to Excel" always open excel in a separate Window

kirit_raja — Thu, 29 Nov 2007 16:58:35 GMT

Did you check permissions on the temporary folder?