I am trying to export my repeater to excel and here is my code...
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
string attachment = "attachment; filename=file.xls";
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/vnd.ms-excel";
[code]...
i want to create a asp.net page which consists of repeater control and want to export repeater data in excel.
View 1 Repliesprotected void RunReport(object sender, EventArgs e)
View 4 RepliesI have a repeater control which has an table format that has textboxes in it. I tried the solution at [URL] which works but loses the table format. I have an example below in which I have modified that code and have it so now the table format stays but the values show outside the table and not in the correct columns and rows.
I need to keep the values in the proper location.
<asp:Repeater ID="rptMonthlyReport" runat="server" OnItemDataBound="rptMonthlyReport_ItemDataBound">
<HeaderTemplate>
<header>
<asp:Label ID="lblOne" runat="server">Monthly Performance Report</asp:Label>
</header>
<table id="tblMonthlyReport" border="1">
[code].....
I have a repeater control that is getting exported to excel. Well excel will no longer show the data that was in the textboxes. I've read the article on exporting a gridview having the same problem and how you replace the texboxes with literal contrls. I was wondering if there is an article like it only for a repeater control.
View 1 RepliesI am getting this error Extender control 'cpeProject' is not a registered extender control. Extender controls must be registered using RegisterExtenderControl() before calling RegisterScriptDescriptors(). Parameter name: extenderControl This is the itemtemplete code for repeater in aspx page.
<
ItemTemplate
>
<tr
>
<td
align="left"
style
="width: 15%; font-size: 11px; font-family: Verdana;">
<%
#DataBinder.Eval(Container.DataItem,
"Employee_RollNo"
)%>
</td
>
<td
>
<asp:Panel
ID="pnlProject"
runat
="server">
<asp:LinkButton
ID="LinkButton1"
runat="server"
CommandArgument='<%#Bind("Employee_RollNo") %>'><%#DataBinder.Eval(Container.DataItem,"Full_Name")
%></asp:LinkButton
>
</asp:Panel
>
<asp:Panel
ID="Panel1"
runat
="server">
<cc1:CollapsiblePanelExtender
ID="cpeProject"
ExpandedSize="0"
CollapsedSize
="0"
TargetControlID="pnlSurvery"
ExpandControlID="LinkButton1"
CollapseControlID
="LinkButton1"
SuppressPostBack="true"
runat="server"
Collapsed
="false">
</cc1:CollapsiblePanelExtender
>
</asp:Panel
>
</td
>
<td
align="left"
style
="width: 15%; font-size: 11px; font-family: Verdana;">
<%
#DataBinder.Eval(Container.DataItem,
"Sec_name"
)%>
</td
>
<td
align="left"
style
="width: 15%; font-size: 11px; font-family: Verdana;">
<%
#DataBinder.Eval(Container.DataItem,
"Div_Name"
)%>
</td
>
<td
align="left"
style
="width: 15%; font-size: 11px; font-family: Verdana;">
<%
#DataBinder.Eval(Container.DataItem,
"Grade_Name"
)%>
</td
>
<td
align="left"
style
="width: 15%; font-size: 11px; font-family: Verdana;">
<%
#DataBinder.Eval(Container.DataItem,
"Location"
)%>
</td
>
</tr
>
<tr
class
="ItemTemplate">
<td
colspan="8"
style
="width: 100%">
<asp:Panel
ID="pnlSurvery"
runat="server"
Width="100%"
Height
="100%">
<table
cellpadding
="10">
<tr
>
<td
>
<table
border="0"
cellpadding="0"
cellspacing
="0">
<tr
>
<td
>
<asp:Panel
ID="pnlBehaviour"
runat="server"
Visible
="false">
<table
border
="0">
<tr
>
<td
align="left"
style
="background-color: Navy">
<asp:Label
ID="Label1"
runat="server"
Font-Size="14px"
Font-Bold="True"
ForeColor="white">Functional/Behaviour Report</asp:Label
>
</td
>
</tr
>
<tr
>
<td
>
<asp:GridView
ID="gvBehaviour"
runat="server"
AllowPaging="true"
AutoGenerateColumns
="False"
Font-Size
="medium">
<AlternatingRowStyle
Font-Bold="False"
Font-Italic="False"
Font-Overline
="False"
Font-Strikeout="False"
Font-Underline="False"
BackColor="Lavender"
/>
<Columns
>
<asp:BoundField
DataField="TRAINING_PROGRAMS"
HeaderText="TRAINING_PROGRAMS"
/>
<asp:BoundField
DataField="REMARKS"
HeaderText="REMARKS"
/>
<asp:BoundField
DataField="TIME_PERIOD"
HeaderText="TIME_PERIOD"
/>
<asp:BoundField
DataField="RESPONSIBLE"
HeaderText="RESPONSIBLE"
/>
</Columns
>
<HeaderStyle
Wrap="true"
BackColor="Navy"
Font-Bold="False"
Font-Italic="False"
Font-Overline
="False"
Font-Strikeout="False"
Font-Underline="False"
ForeColor="White"
/>
</asp:GridView
>
</td
>
</tr
>
</table
>
</asp:Panel
>
</td
>
</tr
>
<tr
>
<td
>
<br
/>
<br
/>
<asp:Panel
ID="pnlOther"
runat="server"
Visible
="false">
<table
border
="0">
<tr
>
<td
align="left"
style
="background-color: Navy">
<asp:Label
ID="lblHeading1"
runat="server"
Font-Size="14px"
Font-Bold="True"
ForeColor="white">Other Training Requirements, if any</asp:Label
>
</td
>
</tr
>
<tr
>
<td
>
<asp:GridView
ID="gvOther"
runat="server"
AutoGenerateColumns="False"
Font-Size
="medium">
<AlternatingRowStyle
Font-Bold="False"
Font-Italic="False"
Font-Overline
="False"
Font-Strikeout="False"
Font-Underline="False"
BackColor="Lavender"
/>
<Columns
>
<asp:BoundField
DataField="BT_DESCRIPTION"
HeaderText="TRAINING_PROGRAMS"
/>
<asp:BoundField
DataField="BT_REMARKS"
HeaderText="REMARKS"
/>
<asp:BoundField
DataField="BT_DURATION"
HeaderText="TIME_PERIOD"
/>
<asp:BoundField
DataField="BT_COST"
HeaderText="RESPONSIBLE"
/>
</Columns
>
<HeaderStyle
Wrap="true"
BackColor="Navy"
Font-Bold="False"
Font-Italic="False"
Font-Overline
="False"
Font-Strikeout="False"
Font-Underline="False"
ForeColor="White"
/>
</asp:GridView
>
</td
>
</tr
>
</table
>
</asp:Panel
>
</td
>
</tr
>
<tr
>
<td
>
<asp:Panel
ID="pnlTechnical"
runat="server"
Visible
="false">
<br
/>
<table
>
<tr
>
<td
align="left"
style
="background-color: Navy">
<asp:Label
ID="lblHeading"
runat="server"
Font-Size="14px"
Font-Bold="True"
ForeColor
="white"
Width="503px">Technical Report</asp:Label
>
</td
>
</tr
>
<tr
>
<td
>
<asp:GridView
ID="gvTechnical"
runat="server"
AutoGenerateColumns="False"
Font-Size
="medium">
<AlternatingRowStyle
Font-Bold="False"
Font-Italic="False"
Font-Overline="False"
/>
<Columns
>
<asp:BoundField
DataField="TRAINING_PROGRAMS"
HeaderText="TRAINING_PROGRAMS"
/>
<asp:BoundField
DataField="REMARKS"
HeaderText="REMARKS"
/>
<asp:BoundField
DataField="TIME_PERIOD"
HeaderText="TIME_PERIOD"
/>
<asp:BoundField
DataField="RESPONSIBLE"
HeaderText="RESPONSIBLE"
/>
</Columns
>
<HeaderStyle
Wrap="true"
BackColor="Navy"
Font-Bold="False"
Font-Italic="False"
Font-Overline
="False"
Font-Strikeout="False"
Font-Underline="False"
ForeColor="White"
/>
</asp:GridView
>
</td
>
</tr
>
</table
>
</asp:Panel
>
</td
>
</tr
>
<tr
>
<td
>
<asp:Panel
ID="pnlAssignment"
runat="server"
Visible
="false">
<br
/>
<table
>
<tr
>
<td
align="left"
style
="background-color: Navy">
<asp:Label
ID="Label2"
runat="server"
Font-Size="14px"
Font-Bold="True"
ForeColor
="white"
Width="503px">Assignments/Projects Report</asp:Label
>
</td
>
</tr
>
<tr
>
<td
>
<asp:GridView
ID="gvAssignment"
runat="server"
AutoGenerateColumns="False"
Font-Size
="medium">
<AlternatingRowStyle
Font-Bold="False"
Font-Italic="False"
Font-Overline="False"
/>
<Columns
>
<asp:BoundField
DataField="TRAINING_PROGRAMS"
HeaderText="TRAINING_PROGRAMS"
/>
<asp:BoundField
DataField="REMARKS"
HeaderText="REMARKS"
/>
<asp:BoundField
DataField="TIME_PERIOD"
HeaderText="TIME_PERIOD"
/>
<asp:BoundField
DataField="RESPONSIBLE"
HeaderText="RESPONSIBLE"
/>
</Columns
>
<HeaderStyle
Wrap="true"
BackColor="Navy"
Font-Bold="False"
Font-Italic="False"
Font-Overline
="False"
Font-Strikeout="False"
Font-Underline="False"
ForeColor="White"
/>
</asp:GridView
>
</td
>
</tr
>
</table
>
</asp:Panel
>
</td
>
</tr
>
</table
>
</td
>
</tr
>
</table
>
</asp:Panel
>
</td
>
</tr
>
</ItemTemplate
>
code behind for Exporting it to excel
protected void btnExport_Click(object sender,
EventArgs e)
{
if (Repeater1.Items.Count > 0)
{
// RegisterCollapsibleExtender();
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.Buffer =
true;
HttpContext.Current.Response.ContentType =
"application/vnd.ms-excel";
HttpContext.Current.Response.AddHeader("content-disposition",
"attachment;filename = EDReport.xls");
HttpContext.Current.Response.Charset =
"";
StringWriter sw =
new StringWriter();
HtmlTextWriter htw =
new HtmlTextWriter(sw);
//ScriptManager sm = ScriptManager.GetCurrent(Page);
//sm.RegisterExtenderControl(cpeProject, pnlSurvery);
//sm.RegisterAsyncPostBackControl(LinkButton1);
Repeater1.RenderControl(htw);
HttpContext.Current.Response.Write(sw.ToString());
HttpContext.Current.Response.End();
}
}
Am Saving the file in Excel format which contains Chinese letters using C#.NET.
The excel file saved successfully. But the Chinese words are messed up in excel file.
Code Used to Save is :-
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=" Test.xls");
[Code].....
It shows the exact output in website (脚宽 ). But after saving the file the excel file shows like this (脚宽) .
Ex: 脚宽 ----> 脚宽
I want to export all repeater data in excel file i used following code but it take only first page data means page size 10 it export only 10 record i want to export whole repeater data
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=Detail.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
[Code] ....
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 RepliesI 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]...
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 RepliesI'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 Repliesi 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?
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 RepliesWe 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 RepliesI 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?
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 RepliesWe 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.
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.
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.
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.
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 RepliesI was wondering if it would be possible for you to send me and example (if it's possible) of exporting a panel that contains a repeater control to a pdf using itextsharp. I'm using a panel because i need to also show other data that is not on the repeater.
View 1 RepliesI 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
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
