7 Answers, 1 is accepted
0
Hi Kishore,
You have posted your question under the Telerik Platform forums. Telerik Platform is a modular platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native apps. It can help you solve the challenges of designing, building, connecting, testing, deploying, managing, publishing, and measuring your applications.
However, looking at the question you posted it seems you're either using a UI component from one of our DevTools suites or our Reporting tools. Can you please provide us with more details about the component you're using and the platform it is targeting - ASP.NET AJAX, WPF, etc. Any additional information as well as code snippets describing your issue will be highly appreciated as they will help us better understand your case and issue.
Also, please make sure to post your questions in the respective forums in order to receive relevant response to your queries from the respective community or support specialists.
Regards,
Tina Stancheva
Telerik
You have posted your question under the Telerik Platform forums. Telerik Platform is a modular platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native apps. It can help you solve the challenges of designing, building, connecting, testing, deploying, managing, publishing, and measuring your applications.
However, looking at the question you posted it seems you're either using a UI component from one of our DevTools suites or our Reporting tools. Can you please provide us with more details about the component you're using and the platform it is targeting - ASP.NET AJAX, WPF, etc. Any additional information as well as code snippets describing your issue will be highly appreciated as they will help us better understand your case and issue.
Also, please make sure to post your questions in the respective forums in order to receive relevant response to your queries from the respective community or support specialists.
Regards,
Tina Stancheva
Telerik
Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.
0
Kishore
Top achievements
Rank 1
answered on 23 Apr 2014, 12:02 PM
my question was on telerik radgrid.
0
Hello Kishore,
Thank you for contacting us.
Could you please elaborate a little bit more on your scenario? Which export format you are using? I would appreciate if you could provide your code declaration and the related code behind in order to investigate the cause for this issue further.
Regards,
Kostadin
Telerik
Thank you for contacting us.
Could you please elaborate a little bit more on your scenario? Which export format you are using? I would appreciate if you could provide your code declaration and the related code behind in order to investigate the cause for this issue further.
Regards,
Kostadin
Telerik
Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.
0
Kishore
Top achievements
Rank 1
answered on 29 Apr 2014, 12:57 PM
<
telerik:RadGrid
ID
=
"rg_DataBase"
runat
=
"server"
Width
=
"99.5%"
ShowStatusBar
=
"true"
AutoGenerateColumns
=
"False"
PageSize
=
"10"
AllowSorting
=
"True"
AllowMultiRowSelection
=
"False"
AllowPaging
=
"True"
OnDetailTableDataBind
=
"rg_DataBase_DetailTableDataBind"
OnNeedDataSource
=
"rg_DataBase_NeedDataSource"
OnItemDataBound
=
"rg_DataBase_ItemDataBound"
OnPreRender
=
"rg_DataBase_PreRender"
Skin
=
"WebBlue"
OnItemCommand
=
"rg_DataBase_ItemCommand"
OnExcelMLExportRowCreated
=
"rg_DataBase_ExcelMLExportRowCreated"
ShowFooter
=
"false"
>
<
PagerStyle
AlwaysVisible
=
"false"
></
PagerStyle
>
<
MasterTableView
Width
=
"100%"
DataKeyNames
=
"FYIDB_ID"
AllowMultiColumnSorting
=
"True"
CommandItemDisplay
=
"None"
ExpandCollapseColumn-Display
=
"true"
>
<
CommandItemSettings
ShowExportToExcelButton
=
"true"
ShowAddNewRecordButton
=
"false"
>
</
CommandItemSettings
>
<
DetailTables
>
<
telerik:GridTableView
DataKeyNames
=
"FYIDB_ID"
Name
=
"Volumes"
Width
=
"100%"
SkinID
=
"Vista"
ShowFooter
=
"true"
>
<
HeaderStyle
CssClass
=
"MostInnerHeaderStyle"
/>
<
FooterStyle
CssClass
=
"MostInnerHeaderStyle"
/>
<%-- <
ItemStyle
CssClass
=
"MostInnerItemStyle"
/>--%>
<
Columns
>
<
telerik:GridBoundColumn
SortExpression
=
"FYIVOL_VolumeName"
HeaderStyle-HorizontalAlign
=
"Center"
HeaderText
=
"Name"
HeaderButtonType
=
"TextButton"
DataField
=
"FYIVOL_VolumeName"
ItemStyle-HorizontalAlign
=
"Center"
HeaderStyle-Width
=
"10%"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
SortExpression
=
"ETPT_Number"
HeaderStyle-HorizontalAlign
=
"Center"
HeaderText
=
"ETPT"
HeaderButtonType
=
"TextButton"
DataField
=
"ETPT_Number"
UniqueName
=
"ETPT_Number"
ItemStyle-HorizontalAlign
=
"Center"
HeaderStyle-Width
=
"10%"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
SortExpression
=
"SERIAL NUMBER"
HeaderStyle-HorizontalAlign
=
"Center"
HeaderText
=
"Serial#"
HeaderButtonType
=
"TextButton"
DataField
=
"SERIAL NUMBER"
UniqueName
=
"SERIALNUMBER"
ItemStyle-HorizontalAlign
=
"Center"
HeaderStyle-Width
=
"10%"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
SortExpression
=
"Contact_ID"
HeaderStyle-HorizontalAlign
=
"Center"
HeaderText
=
"Received From"
HeaderButtonType
=
"TextButton"
DataField
=
"Contact_ID"
UniqueName
=
"Contact_ID"
ItemStyle-HorizontalAlign
=
"Center"
HeaderStyle-Width
=
"10%"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
SortExpression
=
"FYIVOL_BatesRange"
HeaderStyle-HorizontalAlign
=
"Center"
HeaderText
=
"Bates Range"
HeaderButtonType
=
"TextButton"
DataField
=
"FYIVOL_BatesRange"
UniqueName
=
"FYIVOL_BatesRange"
ItemStyle-HorizontalAlign
=
"Center"
HeaderStyle-Width
=
"15%"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
SortExpression
=
"FYIVOL_DocCount"
HeaderStyle-HorizontalAlign
=
"Center"
HeaderText
=
"Docs"
HeaderButtonType
=
"TextButton"
DataField
=
"FYIVOL_DocCount"
UniqueName
=
"FYIVOL_DocCount"
ItemStyle-HorizontalAlign
=
"Right"
HeaderStyle-Width
=
"10%"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
SortExpression
=
"FYIVOL_PageCount"
HeaderStyle-HorizontalAlign
=
"Center"
HeaderText
=
"Pages"
HeaderButtonType
=
"TextButton"
DataField
=
"FYIVOL_PageCount"
UniqueName
=
"FYIVOL_PageCount"
ItemStyle-HorizontalAlign
=
"Right"
HeaderStyle-Width
=
"10%"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
SortExpression
=
"FYIVOL_DateLoade"
HeaderStyle-HorizontalAlign
=
"Center"
HeaderText
=
"Date Loaded"
HeaderButtonType
=
"TextButton"
DataField
=
"FYIVOL_DateLoade"
UniqueName
=
"FYIVOL_DateLoade"
ItemStyle-HorizontalAlign
=
"Center"
HeaderStyle-Width
=
"10%"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
SortExpression
=
"FYIVOL_Size"
HeaderStyle-HorizontalAlign
=
"Center"
HeaderText
=
"Size"
HeaderButtonType
=
"TextButton"
DataField
=
"FYIVOL_Size"
UniqueName
=
"FYIVOL_Size"
ItemStyle-HorizontalAlign
=
"Right"
HeaderStyle-Width
=
"15%"
FooterStyle-HorizontalAlign
=
"Right"
>
</
telerik:GridBoundColumn
>
<%-- <
telerik:GridCalculatedColumn
HeaderText
=
"Total Price"
UniqueName
=
"Size"
DataType
=
"System.Double"
DataFields
=
"Size"
Expression
=
"{0}"
FooterText
=
"Total : "
Aggregate
=
"Sum"
/>--%>
</
Columns
>
</
telerik:GridTableView
>
</
DetailTables
>
<
Columns
>
<
telerik:GridBoundColumn
SortExpression
=
"FYIDB_Name"
HeaderStyle-HorizontalAlign
=
"Center"
HeaderText
=
"Name"
HeaderButtonType
=
"TextButton"
DataField
=
"FYIDB_Name"
ColumnGroupName
=
"rgcg_Name"
ItemStyle-HorizontalAlign
=
"Center"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
SortExpression
=
"FYIDB_DateCreate"
HeaderStyle-HorizontalAlign
=
"Center"
HeaderText
=
"Date Created"
HeaderButtonType
=
"TextButton"
DataField
=
"FYIDB_DateCreate"
ColumnGroupName
=
"rgcg_Name"
ItemStyle-HorizontalAlign
=
"Center"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
SortExpression
=
"FYIDB_Status"
HeaderStyle-HorizontalAlign
=
"Center"
HeaderText
=
"Status"
HeaderButtonType
=
"TextButton"
DataField
=
"FYIDB_Status"
ColumnGroupName
=
"rgcg_Name"
ItemStyle-HorizontalAlign
=
"Center"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
SortExpression
=
"FYIDB_StatusDateChange"
HeaderStyle-HorizontalAlign
=
"Center"
HeaderText
=
"Status Changed"
HeaderButtonType
=
"TextButton"
DataField
=
"FYIDB_StatusDateChange"
ColumnGroupName
=
"rgcg_Name"
ItemStyle-HorizontalAlign
=
"Center"
>
</
telerik:GridBoundColumn
>
</
Columns
>
</
MasterTableView
>
<
ClientSettings
EnableRowHoverStyle
=
"true"
EnablePostBackOnRowClick
=
"false"
>
<
Selecting
AllowRowSelect
=
"true"
EnableDragToSelectRows
=
"false"
/>
<
Resizing
AllowColumnResize
=
"True"
AllowRowResize
=
"false"
ResizeGridOnColumnResize
=
"true"
ClipCellContentOnResize
=
"false"
EnableRealTimeResize
=
"false"
AllowResizeToFit
=
"true"
/>
</
ClientSettings
>
<
ExportSettings
ExportOnlyData
=
"true"
IgnorePaging
=
"true"
OpenInNewWindow
=
"true"
FileName
=
"Elijah_Hosting_Databases Information"
>
<
Excel
Format
=
"ExcelML"
/>
</
ExportSettings
>
</
telerik:RadGrid
>
hi kastadin,
I am sending the grid design.i want the inner grid total when I export to excel. I am getting total in my application.
0
Hello Kishore,
Please try setting the following format:
This should resolve the issue. Please give it a try and let me know about the result.
Regards,
Eyup
Telerik
Please try setting the following format:
<
Excel
Format
=
"Html"
/>
This should resolve the issue. Please give it a try and let me know about the result.
Regards,
Eyup
Telerik
Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.
0
Kishore
Top achievements
Rank 1
answered on 07 May 2014, 09:03 AM
hi,
Thank you eyup now inner grid footer value is coming but the excel sheet lines disappearing. Is there any to get the excel lines.
Thank you eyup now inner grid footer value is coming but the excel sheet lines disappearing. Is there any to get the excel lines.
0
Hello Kishore,
You can try adding the following logic:
Alternatively, you can check the following post:
http://www.telerik.com/forums/radgrid-doesnt-export-grid-footer-to-excel-excelml#slPUWDfqj02dfZG6VslKDA
Hope this helps.
Regards,
Eyup
Telerik
You can try adding the following logic:
protected
void
rg_DataBase_ItemCommand(
object
sender, GridCommandEventArgs e)
{
if
(e.CommandName == RadGrid.ExportToExcelCommandName)
{
rg_DataBase.GridLines = GridLines.Both;
}
}
Alternatively, you can check the following post:
http://www.telerik.com/forums/radgrid-doesnt-export-grid-footer-to-excel-excelml#slPUWDfqj02dfZG6VslKDA
Hope this helps.
Regards,
Eyup
Telerik
Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.