Export To Excel Doesn't Work On IE Under SSL

Jan 12, 2011

I've been trying to fix something on a secure website (https) which is an Export to Excel button that generates a CSV file. It works on Firefox, Chrome , etc... but not in Internet Explorer. I have changed the headers eliminating the no-cache and also edited the IIS http header configuration setting an expiration date of 1 day. I have no idea of what can be going on and how to solve it. Do you guys have any idea of how to fix this stuff ? I've read so many posts and they're all saying the same thing... caching.

UPDATE 1 :

regarding the error I receive, I receive an IE Alert saying "Internet explorer cannot download filename.aspx from [URL]Internet Explorer was not able to open this Internet site. The requested site is either unavailable or cannot be found. Please try again later. As I said, it all works out of SSL (https), but the export to excel button, breaks in https.

UPDATE 2:

I'm using these headers:

Response.ClearContent();
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename=" + name.Trim() + ".csv");
Response.AddHeader("Cache-Control", "no-cache");
Response.AddHeader("Pragma", "public");
Response.AddHeader("Content-Transfer-Encoding", "binary");
Response.AddHeader("Content-Length", "2026");
Response.Charset = "";
//Response.ContentType = "application/vnd.ms-excel";
Response.ContentType = "text/csv";

View 2 Replies


Similar Messages:

SQL Reporting :: Export File Extension / Giving The DisplayName Property But It Doesn't Work?

Dec 2, 2010

I'm generating the rdlc at runtime and I'm using LoadReportDefinition(memorystream) to provide the definition to report viewer. It works fine but when I export it to pdf or excel, the file extension comes in as .xls[1] or .pdf[1].

I have tried giving the DisplayName property but it doesn't work.

View 1 Replies

AJAX :: Export To Excel Button Does Not Work Inside Update Panel Control

Mar 15, 2013

i have gridview and export to excel button inside Update panel, the code i am using to export gridview data to excel is..

public void imgExcelExport_Click(object sender, ImageClickEventArgs e)
{
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "Customers.xls"));
Response.ContentType = "application/ms-excel";

[code]...

View 1 Replies

Forms Data Controls :: GridView Export To Excel Does Not Work When Using The ConfirmButtonExtender In GridView

Apr 1, 2011

I am using Ajax ConfirmButtonExtender Control in GridView for Deleting the Record. I am also Exporting the GridData to Excel using Render Method. But when i click on the Export Button, i am getting below error Extender control 'confirmID' is not a registered extender control. Extender controls must be registered using RegisterExtenderControl() before calling RegisterScriptDescriptors(). Parameter name: extenderControl

View 1 Replies

When Export Grid View Export In Excel It That String Shows In Single Line?

Jul 24, 2010

i have in grid view that grid view have very long string. when i export grid view export in excel it that string shows in single line

View 1 Replies

Web Forms :: Export To Excel Function Errors When Trying To Render The Grid For The Export?

Apr 27, 2010

I have a web form that contains a GridView, which impliments Search in Grid with a TextBox and Button control in the footer. This works as I have it now. I have also implimented a Export to Excel function. The Export to Excel works by itself if the Search in Grid function is not included in the footer.The Export to Excel function errors when trying to render the Grid for the export. Is there a better way to incorporate both functions and accomplish the same thing? Am I missing something simple?

[Code]...

View 21 Replies

Forms Data Controls :: Gridview - Export To Excel And Formatting Excel From Right To Left

Jun 10, 2010

How can I export data from a Gridview to excel and once exported the data should be formatted in right to left (arabic) manner. How can I achieve this?

View 2 Replies

Visual Studio :: Exporting A .rdlc To Excel / Analagous Export Of That Report To Excel?

Nov 2, 2010

I've got an .rdlc report which I print from my .net app (C# Visual Studio 2005), where I use a RemoteReportPrinter object. I give it as parameters the server name, report name, report parameters, etc. Works fine. My question is, I would live to do an analagous export of that report to Excel. Set it up exactly the same, but have it export to Excel rather than print, probably using some other type of object than RemoteReportPrinter.

View 1 Replies

Data Controls :: Export GridView To Excel And Save Excel File To Folder?

Apr 6, 2014

i use this code to export data into word.

Protected Sub Export(sender As Object, e As EventArgs) Handles btn_printexcel.Click
Response.Clear()
Response.Buffer = True

[Code]....

but the export docs will be downloaded into the user computer.

what should i do so that the exported docs is save into the server?

View 1 Replies

Databases :: Export To Excel Multiple Sheets Without COM Interop Or Excel Object?

Feb 18, 2011

i want to export multiple tables in a dataset to excel workbook with each tables as sheets without using COM Interop or Excel Object.

View 2 Replies

Forms Data Controls :: Export Datagrid To Excel Without Excel Component?

Sep 22, 2010

We have the requirement to export the data from the grid excel. We can't install the Excel on the server. The excel generated need to be in the printable format. The excel generated needs to have custom headers, footers, repeatble rows, columns and landscape / portrait orientation style.

View 1 Replies

Forms Data Controls :: Export Gridview To Ms Excel - Set Excel Page Orientation As Landscape

Jan 22, 2010

I am exporting a gridview in MS Excel as mentioned in the following link:

[URL]

I want to set orientation of excel pages as landscape. Is there any way to do that? Any header information to be added for file being exported to set orientation of pages as landscape?

View 2 Replies

Forms Data Controls :: Export To Excel - Desing And Build Big Html Table Into Excel?

Feb 25, 2011

i have table something like this on click of export to excel i need to save that or export that to excel file .can u plz help me how i can do this.one more thing how i can desing and build that big html table into excel is there any simple way i can do the same

View 1 Replies

How To Export Results In Sheet To Excel Without Installing Excel On Server

Sep 22, 2010

We are deveopingawebiste in asp.net. There are tempelates of each aspx page made in the form of excel sheet. Upon completion of the online calculation, the user is to be allowed to export the results to excel and save them. There would be obviously no formulae in such sheet

I do not want to install Excel on theserver and instead want to utilize the Excel installed on the user's computer for this purpose as every user's computer is expected to have Excel installed. Is this possible to do? How to do this?

I am not an expert in this. let me know if you would need any more information or clarification.

View 2 Replies

Export GridView To Excel Without Losing Grid Lines In Excel?

Mar 4, 2010

I have a GridView that I want to export to Excel. When I use the sample code I find online, it exports the content to Excel just fine, but for some reason it also clears out all grid lines outside of my exported table.

For your average excel user this is easy enough to fix, but I need this solution to work for everyone.

So then is there a way to export the data in a GridView into an Excel Workbook so that it looks like it was just typed into Excel? I've pasted the code I am using below, assume that a GridView called toPrint exists and has accurate data.

Response.Clear();
Response.AddHeader("content-disposition", "attachment; filename=" + name + "_Registration_Forms.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
Page.EnableViewState = false;
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
toPrint.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();

EDIT: Found one partial solution. If I export as a comma-delimited list and set the header to be a CSV file, it opens fine and all grid lines (even those outside of the exported data) are showing. The only problem with this of course is having to strip out every comma and newline character from my values before exporting them.

View 1 Replies

Reading An Excel Work Book - OLEDB Or Excel Interop

Mar 22, 2011

I need to read an Excel work book with 2 sheet which have more than 60,000 records. The application is an ASP.Net application so the performance matters.

Which approach should I take? Sohuld I do it using Microsoft.Office.Interop.Excel or should I do it using OLEDB in ADO.Net?

View 3 Replies

How To Export To Excel With Some Excel Manipulation

Jan 29, 2010

i have this website with a gridview and a button that enables to user to export the data from the gridview to excel using this code.

[Code]....

If you would imagine the result of the exported data from gridview (Data Only without any paging...etc...), the intersection of the first Row and First Column is placed in A1 cell of excel to display the table.

what i wish to do is upon exporting i would like to ex. add 2 more rows above the table so that the resulting table intersection of the first row and first column is located in C1 cell.

View 1 Replies

AJAX :: Make This Work For Several Days But It Just Doesn't Work?

Oct 7, 2010

i'm trying to make this work for several days but it just doesn't work.

this is my code:

aspx page:

[Code]....

webservice:

[Code]....

this was downloaded from this website.

the problem is that the page loads fine but no autocomplete occurs.

View 5 Replies

Forms Data Controls :: Export Data To Excel And Set Excel File Column Format?

Sep 1, 2010

i have try to export data to excel using gridview.

I have export it successfully but some data is missing which is due to the column format in the exported excel file is not TEXT .

[Code]....

I need to set the exported excel file column format to TEXT but find no solution on this.

View 2 Replies

Ajax With WCF Work. But Few Miniute After, Doesn't Work

May 11, 2010

I am a new to WCF. I have written ajax to use a web service before, but on this project I am trying to use ajax to WCF.After I build the project and wcf using ajax, I receive the return successfully. But, 10 or more minutes later I don't get a return, the ajax calls the error function, and the fiddler returns nothing.

If I rebuild the project without any source modifying, I receive the return successfully again.

View 2 Replies

Not Able To Export The Excel In IE 8?

Jul 7, 2010

we have wriiten code to export the data in xml and excel file. Its working fine with chrome,firefox, & IE 6.BUt i am facing problem with IE 8.

View 4 Replies

Export From Gridview To Excel

Dec 14, 2010

I want to export gridview to Excel and followed the code from the link below but never get it work. [URL] I used the data as below but after exporting, it became 1234567, 2266998,3388445. They are all missing '0'.

MEMBID (varchar(20))
01234567
02266998
03388445

View 6 Replies

C# - Export Pdf Table To Excel?

Mar 12, 2010

anyone know how to export pdf table to excel using c# and asp.net? if any can you give me a sample code snippet?

View 1 Replies

Export MS Charts To PDF And Excel?

Jan 9, 2010

I need to export a few (could be just one or more than one) Microsoft Charts to a PDF and Excel. It needs to happen on a button click and the charts should be directly exported to a PDF without getting rendered onto a web page.

Environment used: ASP.NET

View 1 Replies

C# - EXPORT Dataset To EXCEL

Feb 12, 2011

I am using the following code to export fields from a database table into excel. What I want to do is be able to write a SQL statement to retrieve fields from multiple tables and export them into excel. This code only allows me to export one table. Also, how can I display a save prompt dialog?

protected void export_Click(object sender, EventArgs e)
{
string sql = null;
string data = null;
string path = save_as.Text;
int i = 0;
int j = 0;
Excel.Application xlApp;
Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet;
object misValue = System.Reflection.Missing.Value;
xlApp = new Excel.ApplicationClass();
xlWorkBook = xlApp.Workbooks.Add(misValue);
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
//connectionString = "data source=servername;initial catalog=databasename;user id=username;password=password;";
SqlConnection cnn = new SqlConnection(GetConnectionString());
cnn.Open();
sql = "SELECT Story, CreationDate FROM Story";
SqlDataAdapter dscmd = new SqlDataAdapter(sql, cnn);
DataSet ds = new DataSet();
dscmd.Fill(ds);
for (i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
{
for (j = 0; j <= ds.Tables[0].Columns.Count - 1; j++)
{
data = ds.Tables[0].Rows[i].ItemArray[j].ToString();
xlWorkSheet.Cells[i + 1, j + 1] = data;
}
}
xlWorkBook.SaveAs(path+".xls", Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
xlWorkBook.Close(true, misValue, misValue);
xlApp.Quit();
releaseObject(xlWorkSheet);
releaseObject(xlWorkBook);
releaseObject(xlApp);
//MessageBox.Show("Excel file created , you can find the file c:\csharp.net-informations.xls");
}
private void releaseObject(object obj)
{
try
{
System.Runtime.InteropServices.Marshal.ReleaseComObject(obj);
obj = null;
}
catch (Exception ex)
{
obj = null;
//MessageBox.Show("Exception Occured while releasing object " + ex.ToString());
}
finally
{
GC.Collect();
}
}

View 2 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved