AJAX :: Export To Excel With Infragistics UltraWebGridExcelExporter Control?
Oct 11, 2010
I am having a grid with checkboxes corresponding to each row to enable select.There is a dropdownlist populated with several action items and a button which will trigger the selected action from the dropdown.One among the dropdownlist action is "Export to excel".I am using the infragistics UltraWebGridExcelExporter control for this.Both the grid and UltraWebGridExcelExporter is placed inside an AJAX updatepanel.I need the export to excel functionality to work without full page postback.For this I have added a AsyncPostBack Trigger for the button to the updatePanel.But the export to excel is throwing "Sys.WebForms.PageRequestManagerParserErrorException" with this.If I am adding PostBack Trigger for the button, the export to excel is working fine.But the whole page posts back.Is there a way to solve this?
View 1 Replies
Similar Messages:
Jan 22, 2014
I am trying to export excel in accordin as per search result ...
View 1 Replies
Jun 25, 2010
I 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();
}
}
View 1 Replies
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
Aug 30, 2012
i have a gridview control i just want to export to excel i try your code but code execute successfully. but not going to convert to excel
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=GridViewExport.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
[Code].....
View 1 Replies
Nov 10, 2010
I am using AJAX 1.0. I want to export gridview to excel and it should display loading image when user start exporting excel. I usedUpdatePanelbut is gives some JS error message.
View 6 Replies
Jun 3, 2010
I want to export evrything in a page to excel, it's just the graph that does not export. I used WebChart Control graph which I downloaded [URL]. I've been looking around and found that you must use SaveImage(), but I do not have that option.
protected void excel_Click(object sender, EventArgs e)
{
excel.Visible = false;
Response.ContentType = "application/ms-excel";
Response.AddHeader("content-disposition",
"attachment; filename=CashFlow.xls");
}
View 1 Replies
Jul 17, 2015
I 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].....
View 1 Replies
Jul 17, 2015
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 Replies
Jan 24, 2012
The code on one of my aspx pages is giving me this error:
I'm getting this on the code behind for export to excel on one of my pages.
The Controls collection cannot be modified because the control contains code blocks (i.e. <% ... %>).It is referring to this line Me.GridView1.Parent.Controls.Add(frm)
I have this code in the aspx page. I am using two gridviews. I need to have this on the page any way I can fix the code so I can use that export to excel you created?
<% If(Session("PendingClaims"))%>then display gridview1<%Else%>
Then display gridview2<% End If %>
View 1 Replies
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
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
Jul 26, 2010
cannot find any examples of how to lazy load the Infragistics UltraWebTree v6.3I found that the docs on the Infragistics site tend to be limited to the latest version of their controls, but this is a legacy app which I am unable to upgrade. Has anyone got example code or links which demonstrate how to lazy-load nodes in this control?The current implementation that we have loads 1.35MB of html because it is populating the entire tree!!
View 1 Replies
Jul 9, 2010
I need to add the infragistics control to the aspx page...how I can add the infragistics control in aspx page.
View 1 Replies
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
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
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
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
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
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
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
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
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
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
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