Exporting the GridView to various file types. I have got the PDF working great and also want to add Excel. When I use the code I get a message that the file I am trying to open is a different file format from the extension I am trying to open. If i click OK it opens and alls is fine. Trying to get rid of this errors so customers and sales staff doesn't see it. Excel is version 2010.
View 1 RepliesI my exporting data through dataset to excel. But one column say awb no having datatype nvarchar contains long int no say : 123456789012345.
Then instead of displaying this no in numeric format(123456789012345) it is displaying in exponent form(1.23457E+19).
Is there any way to stop this i want data in numeric format (like this 123456789012345).
when I used a code of exporting gridview into excel this code worked for a new website which is without masterpage.
my code:
public override void VerifyRenderingInServerForm(Control control) { }
protected void BtnGenerateReport_Click(object sender, EventArgs e)
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition",
"attachment;filename=GridViewExport.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
StringWriter sw = new StringWriter();.....
Now the same code when I copy it in my project having masterpage . there is no compiler error but it is genereating excel file withno data in it but in fact there is data in the grid view at runtime.
I am trying to export my Model to an Excel sheet. I have 31 fields out of which only 29 are exported. Among the 3 fields that I am not able to export 2 are of type Enum and one of DateTime. Their is another DateTime field also, but that is exported properly. Here are few fields of the model :
[EnumDataType(typeof(Suffix)), Display(Name = "Suffix *")]
[Required(ErrorMessage = "Suffix is Required")]
public Suffix NameSuffix { get; set; }
[EnumDataType(typeof(InquiryStatus)), Display(Name = "Status")]
[Required(ErrorMessage = "Status is Required")]
[Code] ....
Among the 4 fields above, NameSuffix, Inquiry_Status & FollowUpDate are not exported. InquiryDate is exported.
My exporting code is :
DataGrid dg = new DataGrid();
dg.DataSource = inqs.ToList<Inquiry>();
dg.DataBind();
string filename = "InquiryList_" + DateTime.Now + ".xls";
Response.ClearContent();
[Code] ....
In the ContentType, I alos tried with ""application/ms-excel";, but that makes no difference.
What can be the error for the above ?
I'm having two grid view and one button on aspx page , on click of export to excel button i want to transfer these grid view data to excel sheet.. My requirement is to trasnfer to same excel file with two sheets(One sheet for one grid view).
View 6 RepliesI have a web page with a gridview control and a button for Exporting to Excel
I get following error when exporting to Excel.
"The file you are trying to open, 'someFileName[1].xls, is in a different format than specified by the file extension. Verify that file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?"
Clicking Yes opens the file. I would like to avoid showing the above error to the users.
Following code is used from the click event. I've left the commented code here to show what I've tried based on results from internet search. I have Microsoft Office Excel 2007 on local PC.
[Code]....
I found a site which indicates they can export a GridView as Word, Excel, PDF, and CSV. The PDF uses an external library (iTEXT), and I have not tested that. [URL] ....
The CSV worked for me as specified. But I am having trouble with the Word and Excel portions. The code for the Word sub is
Code:
Protected Sub btnExportToWord_Click(sender As Object, e As EventArgs) Handles btnExportToWord.Click
Dim s As String
Response.Clear()
Response.Buffer = True
Response.AddHeader("content-disposition", "attachment;filename=GridViewExport.doc")
[Code] ....
The marked line above triggers an error which states
Code:
Control 'MainContent_GridView1' of type 'GridView' must be placed inside a form tag with runat=server.
Note, that the code never gets the Response.Output.Write line, but the file is downloaded, and looks correct.
My real need is to download the excel file, but it has the some behaviour. It fails at a similar RenderControl statement, but does download the file, although Excel indicates it is in a non-standard format (but looks fine when opened. I can upload that code too, but the Word one above is simpler.
I used your code over here [URL]
for creating a csv but the csv that gets created is blank. My gridview gets populated so I don't think any problem with that not getting data from Access database. I also tried the code sample you have on this website and checked my code against yours.
Reference to your reply to a post at
[URL]
I'm able to export Arabic characters now to PDF. The problem is that the Arabic characters are displayed in "reverse" order like shown in the figure below.
I have managed to export a gridview into word but is there a way when i export the gridview into Word that Word opens in landscape?
View 1 RepliesI have created a nested gridview and want to be able to export the gridview to CSV file. When I export it it also exports all the HTML in the file which I do not want. It is fine if i export it to and XLS file though.
I just wondered if anyone has managed to export to CSV with nested gridviews without the HTML getting exported also.
Here is my code
[Code]....
and here is my gridview
[Code]....
I am setting the datasource for the nested repeater here:
[Code]....
I am exporting GridView to Excel but keep on getting a pop up "The file you are trying to open, 'somefile.xls' is in a different format than specidied by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?When I click "yes" the file opens fine. But why I am getting the pop up at the first place.Also as I have Office 2007 on my machine
GridView1.DataSource = dv;
GridView1.DataBind();
Response.Clear();
Response.Buffer = true;
[code]...
I have the following scenario shown below
Label: Name
ID Qty
1 10
2 5
Kindly note, the ID. QTy are currently in a gridview and the Label is a label on top of the gridview. I would like to export both the label and the gridview to excel...how can I do this.
This is an ASP.NET 3.5 project being created with VS2008. One page contains a gridview with six columns. One of the columns displays standard, 17 character , Vehicle Identification Numbers (VIN). The VIN numbers display normally when the page is rendered. However, when the gridview is exported to Excel, the VIN numbers change. For example, in the gridview, the VIN might be 12345678912345678But when the gridview exports into Excel, that same VIN becomes 1.23457E+16The value of that Excel cell changes to 12345678912345600, changing the last two digits from 78 to 00. It does this for every VIN in the gridview table.I did some Googling but couldn't find anything specifically on this issue. Has anyone seen it before? Is there a way to format the column in the gridview so that Excel will accept it as literal text? I tried programmatically adding a style called 'text' to that column but that had no effect on the outcome. All of the other columns are behaving normally.
View 3 RepliesI have boundfiled column inside gridview and made the column as invisible by setting visible="false".
But while exporting the gridview to excel I am getting the Header text alone exported. Wherever the column's visibility is set to false the header text should not be exported. After binding the gridview I have set the column's visiblity to false so it won't export the column values.
The problem is to stop exporting the header text to excel. Let's say column index is 10
public class GridViewExportUtil
{
public static void Export(string fileName, GridView gv)
{
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.AddHeader(
"content-disposition", string.Format("attachment; filename={0}", fileName));
[CODE]...
I am able to save excel sheet from GridView perfectly. However, I need to add one custom column, which will be URL of a file on sever, I am not allowed to add URLs directly in the table (as per company's development policies). I tried pulling URL from web.config however I am not sure where to add that in the following code
<asp:GridView ID="bestpractgrv" runat="server" AutoGenerateColumns="False" CellPadding="3" GridLines="Vertical" Width="100%" BackColor="White" BorderColor="#999999" BorderStyle="None" BorderWidth="1px" PageSize="10" AllowPaging="True" OnPageIndexChanging="OnPaging" DataKeyNames="iID">
<AlternatingRowStyle BackColor="Gainsboro" />
<Columns>
[code]....
I want to export a gridview data to excel; however, my form contains an update panel. I am getting the error message below. Note: the function works without an update Panel.
RegisterForEventValidation can only be called during Render();
private
{
Response.ClearContent();
Response.AddHeader(
Response.ContentType =
[Code].....
In my Webapplication i am trying to export GridView data into PDF format and the application is working fine.But in the resulted PDF file i'm not getting GridView Headers.
View 1 RepliesIn my gridview,the first 5 columns are filled with the values retrived from database on selecting an item dropdown.The last i.e, 6th column(date) is filled with value given in the textbox.
Now I need to export the gridview rows to Excel in which checkbox is checked.But Now With the code i have,Excel is containing the empty date column.Pls correct my code to get the proper filled Excel.
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
fillCollegeNames();
}
private void fillCollegeNames()
[code]....
I have a requirement that i need to remove the columns from gridview which are blank but at remove funtion it gives me error so i make that columns visible false now its working fine but at the time of exporting data from gridview to excel it also export that visible= false columns in spredsheet and i don't want that blank or hidden column in my excel sheet
View 2 RepliesThis is the class file im using to export the datagrid to excel sheet.Problem is i cant able to transfer the image from gridview to excel sheet using this code. What are the modifications i can do for the below code to export the image.
public class ExcelReport { # region Export to excel /// /// Function for Export html report to Excel sheet /// /// File name /// Gridview /// public void ExportToExcel(string fileName, GridView gv) { try { HttpContext.Current.Response.Clear(); HttpContext.Current.Response.AddHeader("content-disposition",
string.Format("attachment; filename={0}", fileName)); HttpContext.Current.Response.ContentType = "application/ms-excel"; using (StringWriter sw = new StringWriter()) { using (HtmlTextWriter htw = new HtmlTextWriter(sw)) { Table table = new Table(); if (gv.HeaderRow
!= null) { //gv.HeaderRow.CssClass = "GridviewStyle"; // gv.HeaderRow.Font.Bold = true; PrepareControlForExport(gv.HeaderRow); table.Rows.Add(gv.HeaderRow); } foreach (GridViewRow row in gv.Rows) { //row.CssClass = "GridviewStyle"; // row.BorderColor = System.Drawing.Color.Blue;
// row.Height = 20; PrepareControlForExport(row); table.Rows.Add(row); } if (gv.FooterRow != null) { PrepareControlForExport(gv.FooterRow); table.Rows.Add(gv.FooterRow); } table.RenderControl(htw); HttpContext.Current.Response.Write(sw.ToString()); HttpContext.Current.Response.Flush();
HttpContext.Current.Response.End(); } } } catch (Exception ex) { throw ex; } } private void PrepareControlForExport(Control control) { for (int i = 0; i < control.Controls.Count; i++) { Control current = control.Controls[i]; if (current is LinkButton) { control.Controls.Remove(current);
control.Controls.AddAt(i, new LiteralControl((current as LinkButton).Text)); } else if (current is ImageButton) { control.Controls.Remove(current); control.Controls.AddAt(i, new LiteralControl((current as ImageButton).AlternateText)); } else if (current is....................................
I finally managed to export a gridview to an excel sheet.
Next, how can I remove the column width and alternatingrowstyle color (or all formatting if it is easier) "programatically" before exporting it to excel?
Demonstration of what I am trying to accomplish:
[Code]....
I am trying to export a gridview that is returned from a search form. The gridview also has paging enabled. In order to export the records from all pages in the gridview I had to turn off paging and do a databind, but instead of only exporting the search results it exports all the records in the gridview.
How can I only export the records from the search results, but also the make sure the records on the different pages export also?
With the code i have below i am able to export only one page of gridview to excel. check and modify it once.so that i can import all the pages of gridview to excel at a time with checked status of checkbox.
protected void btnExporttoExcel_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[5] { new DataColumn("Presentees"), new DataColumn("StudentName"), new DataColumn("ColgRegisterNum"), new DataColumn("CollegeName"), new DataColumn("Date"), });
foreach (GridViewRow row in gvStdntDetails.Rows)
[code]...
I exported some data from a gridview to an Excel with Images.
I need to give a specified height and width for all the rows and text to be aligned centre.