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:

Web Forms :: Exporting Entire Page To Excel. Getting An Error?

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

Forms Data Controls :: Getting A Gridview Formatted Right?

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

Forms Data Controls :: Mixture Of Formatted Text Within A Single GridView Cell?

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

Gridview Column Color Doesn't Fill Entire Box

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

Forms Data Controls :: Selecting An Entire Row In GridView?

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

Data Controls :: Passing Entire GridView To Another Page?

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

GridView Making A Single Edit Item Template Take The Entire Row?

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

Forms Data Controls :: How To Disable An Entire Column Of A Gridview

Feb 19, 2010

how can i disable an entire column of a gridview?

View 6 Replies

JQuery :: Attach Event To Gridview Linkbutton Not Entire Row Click?

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

Forms Data Controls :: Make Entire Gridview Updatable?

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

Data Controls :: Passing Entire GridView Instance To Another Page?

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

Forms Data Controls :: Put The Entire Weeks Dates In Gridview By Using The Date Value?

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

Forms Data Controls :: Open Entire Record In Word When Click On Gridview Row?

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

Web Forms :: Exporting A Gridview To Excel?

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

C# - Exporting Gridview To Ms Excel 2007?

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

Forms Data Controls :: Display Formatted Data In Gridview?

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

Forms Data Controls :: Making Entire Row Selectable Instead Of Just The Select Link / Button In Gridview?

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

Web Forms :: Add Dynamic Content To PDF Along With Gridview While Exporting?

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

Exporting Gridview Contents To Excel Spreadsheet?

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

C# - Exporting Data From A Gridview To Different Excel Worksheets?

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

VS 2013 - Exporting GridView As Word File

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

Web Forms :: CSV File Is Blank When Exporting GridView To CSV?

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

Web Forms :: Wrong Encoding While Exporting Gridview To Excel?

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

Data Controls :: Exporting GridView To Various File Types?

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







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