C# - When Exporting Gridview To Xls - The Entire Row Is Formatted
Aug 4, 2010
I have a gridview that I am exporting to an excel file. When I open the excel file, the alternating row color extends to the end of the excel table, but I only want my 6 data columns to be formatted. How can I limit the formatting?
My gridview:
<asp:GridView ID="grdExportable" runat="server" BackColor="White" ForeColor="Black"
Width="1100px" AutoGenerateColumns="False" Visible="False">
<PagerSettings Mode="NumericFirstLast" />
<Columns>
<asp:BoundField DataField="ActivityDateTime" HeaderText="Date/Time" />
<asp:BoundField DataField="TestName" HeaderText="TestName" />
<asp:BoundField DataField="RoundSerialNumber" HeaderText="RoundSerialNumber"/>
<asp:BoundField DataField="RoundType" HeaderText="RoundType"/>
<asp:BoundField DataField="LotNumber" HeaderText="Lot/StockNumber" />
<asp:BoundField DataField="Notes" HeaderText="Notes" />
</Columns>
<SelectedRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#6C0000" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="#CCCCCC"/>
</asp:GridView>
My export method:
private void ExportGridView()
{
string attachment = "attachment; filename=Activity Report.xls";
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
grdExportable.Visible = true;
grdExportable.RenderControl(htw);
grdExportable.Visible = false;
Response.Write(sw.ToString());
Response.End();
}
View 1 Replies
Similar Messages:
Jun 24, 2010
This is an ASP.NET web app built using VS2008. I created a standalone class with a method that exports the entire page, text fields, gridviews, images, everything to an Excel worksheet. It works fine. When I dropped the same class in another web app and tried to call it from a page, I get this error message:
[Code]...
View 8 Replies
Mar 17, 2010
So I have a high level knowledge of setting up data presentation, but I'm doing a simple design with an Access db. Here is currently what I've developed it's not the actual information but it is what I'm looking for.
This is what my current Grid looks like:
Server Name
Environment
Type
Cost this month
Cost overall
abc123
Devlopment
Storage
$100.00
$2,000.00
abc123
Devlopment
Connection
$200.00
$4,200.00
abc123
Devlopment
Backup
$5,000.00
$10,500.00
abc124
QA
Storage
$6,666.67
$14,066.67
abc124
QA
Connection
$9,116.67
$18,316.67
abc124
QA
Backup
$11,566.67
$22,566.67
abc127
UAT
Storage
$14,016.67
$26,816.67
abc128
Prod
Backup
$16,466.67
$31,066.67
abc129
UAT
Connection
$18,916.67
$35,316.67
This is what I am being asked for it to look like where just the server name is up and the type of server it is so the information is easier to read
Can I still do this with a GridView? Or is there some other type of data presentation that might give more freedom.
View 11 Replies
Jun 28, 2010
Using Visual Studio 2008 (but have VWD 2010 available). Desire is populate a cell from a number of database items that have been concatenated together. Exampler would be Smith, John, 2010, Going After an Ideal Solution, 500 pages. Gridview allows me to set the cell format, but for the entire cell. I would like to present this as a mixture.
View 6 Replies
Jan 25, 2011
I have a gridview with certain boxes that are highlighted in green. These boxes should fill the entire box, but I can't seem to trash this 1px border around the edges. I'm using IE7, but FF does it too.
Rendered html
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head><title>
</title><link href="Style/StyleSheet.css" rel="stylesheet" type="text/css" /><link href="App_Themes/Contoso/Style.css" type="text/css" rel="stylesheet" /></head>
<body>
Update
Changed the Serial# template's itemstyle and it fixed the problem.
<ItemStyle Font-Size="Smaller" CssClass="NoMargin NoPadding" />
View 2 Replies
Feb 4, 2010
I am trying to use GridView in my asp.net page. My requirement is to select an entire row by clicking at any place(field) in the row. Is it possible to accomplish this without using Links or buttons for the fields..? I have searched the net but couldnt find any answer. Is it the GridView designed not to allow selection of a row..?
View 2 Replies
Mar 16, 2013
I m having a grid view on web3.aspx page
I am having another page web9.aspx page with a button on it.
On the click of this button i want to display the grid view present on web3.aspx.
View 1 Replies
Jan 6, 2010
I've got this gridview. The gridview uses TemplateFields as the number of fields in the database's table. What I do next is use an ItemTemplate to present the correct column info.
Now, problems rise when the user click's Edit. Since I can only use EditItemTemplate to edit I am resulted with a control in each column. What I really want is to have a single row with no columns so I can easily style the edit mode (having a table with a different layout for example).
Is this possible?
View 1 Replies
Feb 19, 2010
how can i disable an entire column of a gridview?
View 6 Replies
Feb 10, 2011
I have a gridview where, when the user clicks the row, a modal form is shown and values are passed back to the calling function. This works just fine. However, now I have the requirement that instead of clicking the entire row, they want to just click a link button on the row (not the entire row) and get this same functionality. I am new to JQuery and cannot figure out how to select the link button inside the gridview in order to attach my function to it. Also, once I have that figured out, how do I get values from the Link Button's row to pass to my modal form? Here is my jquery function which works fine for the row-click:
$(document).ready(function() {
// set the background color of selected gridview row
$("#<%=gridResults.ClientID%> tr").click(function() {
$(this).css("background-color", "PowderBlue");
[Code].....
I would like to add a field like this to my gridview and attach the above functin to it:
<asp:TemplateField>
<ItemTemplate>
<asp:LinkButton ID="lnkCallModal" runat="server" CausesValidation="False" CommandName="linkPol"
Text="Modal Search" >
</asp:LinkButton>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" Width="10px" />
</asp:TemplateField>
View 4 Replies
Feb 14, 2011
Is it possible to make a gridview so that when it is opened all the records are updatable without having to click on the Edit button? I assume you would have to use the EditItem property and possibly loop through the rows but I'm a newbie and don't know the code.
View 1 Replies
Mar 23, 2013
i want to pass an entire grid view from once page to another without using web user control.
how can we create an instance of the grid view on some other page.
View 1 Replies
Oct 22, 2010
I have a jquery datepicker from which i select starting of the week, how can i put the entire week's dates in gridview by using the date value?
View 1 Replies
Nov 23, 2010
I want to open entire record in Word when i click on Gridview row,is it possible to do as such, provide me the code.
View 2 Replies
Jan 4, 2011
On two of my web forms I have the ability to export a gridview to an excel file. On my local machine. it works. So when I click an image button it gives me the option of opening or saving a gridview as Excel.
However, when I run on the web server. It does not give me the option to open or save, it just opens the gridview as an excel document when the button is clicked.
Even stranger: I have this running on two separate forms. On one form when it opens the gridview as an Excel file it includes a tool bar, so that If a user wishes they could do a 'file', 'save'; However the other one does not have a tool bar?
Ideally I would like them to get the prompt like on the local machine, to open or save.
View 7 Replies
Jan 17, 2011
I am trying to export grid view data into excel 2007 i.e. xlsx format. but its giving error.
i am using following code
protected void Button1_Click(object sender, EventArgs e)
{
Response.Clear();
Response.Buffer = true;
[Code]....
but not working properly and on opening the file it gives following error "Excel cannot open the file 'ChangeRequestList[2].xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file"
View 1 Replies
Feb 4, 2011
I have following database table.
I want following output in gridview
How can i write SQL query for this output?
View 5 Replies
Sep 20, 2010
I have a gridview setup and have the select button enabled. I also have a gridview that doesnt have a select button enabled..
On them both, if its possible, i would like to make the row itself selectable instead of just enabling the select button.
View 2 Replies
Jan 24, 2011
I have written the code for exporting the gridview to PDF but what i need is to add some content to the PDF file before gridview data A sample data is as follows
[Code]....
Can any one tell how to do this
View 1 Replies
Feb 25, 2010
I have a gridvidew (GV2). I want the user to be able to export the contents of this gridview to an excel spreadsheet for offline processing.
Here is my subroutine:
[code]...
On clicking the ExcelButton I get the error message:
Control 'GV2' of type 'GridView' must be placed inside a form tag with runat=server.
The control GV2 is in fact inside:
<form id="form1" runat="server"></form>
View 1 Replies
May 10, 2010
I am binding data from a dataset to a grid and exporting data from the grid to an excel.if the the number of items in the grid is greater than 50000,an error message is displayed.
So i want to split the data and display it in different worksheets in excel.(Am working in a web application)
using this code for exporting to excel
gvExcel.DataSource = DTS;
gvExcel.DataBind();
Response.AddHeader("content-disposition", "attachment; filename= filename.xls");
Response.ContentType = "application/excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
gvExcel.RenderControl(htw);
// Style is added dynamically
Response.Write(style);
Response.Write(sw.ToString());
Response.End();
View 2 Replies
Apr 4, 2015
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.
View 1 Replies
Apr 25, 2012
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.
View 1 Replies
Jul 30, 2010
In my application i have gridview that I export it to excel. When exporting I have the option to select if show the data with images or with no images. The application run well, but when i try export Hebrew data I got gibberish letters. The second thing is that if I select the option "with no images"
Sometimes the Hebrew seems good, and sometime not. Of course I add the Response.ContentEncoding. I thing maybe I should encoding one of this rows
[Code]....
But don't know how. Here is my application printscreen. and this is my code
[Code]....
View 2 Replies
Sep 11, 2012
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 Replies