Hi Telerik Team,
How to Export asp:Repeater including RadHtmlChart and RadGrid to Excel in C# in Code Behind or JQUERY?
I am trying to export some data to Excel and my code is as below:
Regards
Antoine Sweid
How to Export asp:Repeater including RadHtmlChart and RadGrid to Excel in C# in Code Behind or JQUERY?
I am trying to export some data to Excel and my code is as below:
<
asp:Repeater
ID
=
"repeaterStandardQuestion"
runat
=
"server"
OnItemDataBound
=
"repeaterStandardQuestion_ItemDataBound"
>
<
ItemTemplate
>
<
div
style
=
"border: solid"
>
<
table
>
<
tr
>
<
td
>
<
div
style
=
"text-align: left"
>
<
asp:Label
ID
=
"lblTitleStandardQuestion"
runat
=
"server"
/>
</
div
>
<
telerik:RadHtmlChart
runat
=
"server"
ID
=
"radHtmlChartStandardQuestion"
Transitions
=
"true"
Width
=
"400px"
Height
=
"200px"
RegisterWithScriptManager
=
"true"
>
<
PlotArea
>
<
Series
>
<
telerik:BarSeries
Name
=
"Average"
DataFieldY
=
"PercentageAccepted"
>
<
TooltipsAppearance
DataFormatString
=
"{0:##.##}%"
></
TooltipsAppearance
>
<
LabelsAppearance
DataFormatString
=
"{0:##.##}%"
Position
=
"Center"
></
LabelsAppearance
>
<
Appearance
FillStyle-BackgroundColor
=
"LightBlue"
></
Appearance
>
</
telerik:BarSeries
>
</
Series
>
<
XAxis
DataLabelsField
=
"Name"
>
<
MajorGridLines
Visible
=
"false"
/>
<
MinorGridLines
Visible
=
"false"
/>
</
XAxis
>
<
YAxis
MaxValue
=
"100"
>
<
LabelsAppearance
DataFormatString
=
"{0:#}%"
></
LabelsAppearance
>
<
MinorGridLines
Visible
=
"false"
></
MinorGridLines
>
<
MajorGridLines
Visible
=
"false"
/>
</
YAxis
>
</
PlotArea
>
<
Legend
>
<
Appearance
Position
=
"Bottom"
Visible
=
"false"
/>
</
Legend
>
</
telerik:RadHtmlChart
>
</
td
>
<
td
>
<
telerik:RadGrid
ID
=
"radGridStandardQuestion"
runat
=
"server"
AutoGenerateColumns
=
"false"
Width
=
"200px"
>
<
MasterTableView
>
<
Columns
>
<
telerik:GridBoundColumn
DataField
=
"Name"
HeaderText
=
"Answer Choices"
HeaderStyle-Font-Bold
=
"true"
></
telerik:GridBoundColumn
>
<
telerik:GridTemplateColumn
HeaderText
=
"Responses"
HeaderStyle-Font-Bold
=
"true"
>
<
ItemTemplate
>
<%#GetPercentage( Convert.ToDouble(Eval("PercentageAccepted"))) %>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridBoundColumn
DataField
=
"NumberAccepted"
HeaderText
=
""
></
telerik:GridBoundColumn
>
</
Columns
>
</
MasterTableView
>
</
telerik:RadGrid
>
</
td
>
</
tr
>
</
table
>
</
div
>
<
br
/>
</
ItemTemplate
>
</
asp:Repeater
>
Regards
Antoine Sweid