Hi,
I need to export radgrid to CSV and Excel as well as print .One particular column of the grid is a datetime column .But in the grd_DataBound event I am changing the value of that field to either Y or null for business purpose(e.Item.Cells[4].Text = "Y";).
This is only for showing to the user and the column is bound to datetime field.
While exporting CSV exports the Y or null but excel exports the date time value. While print also I am getting Y or null value.
Could anybody please suggest a way to show cell text i.e. ‘Y’ in Excel also …?
grd.ExportSettings.ExportOnlyData =
true
;
grd.ExportSettings.IgnorePaging =
true
;
grd.ExportSettings.Excel.Format = Telerik.Web.UI.GridExcelExportFormat.ExcelML;
grd.ExportSettings.OpenInNewWindow =
true
;
Regards,
Soumya
<
telerik:RadAsyncUpload
ID
=
"RadAsyncUpload1"
runat
=
"server"
MultipleFileSelection
=
"Automatic"
OnClientFileSelected
=
"DoFrameSize"
ForeColor
=
"Black"
>
</
telerik:RadAsyncUpload
>
<
telerik:RadProgressArea
runat
=
"server"
ID
=
"RadProgressArea1"
>
</
telerik:RadProgressArea
>
Dim
btn As New RadButton
btn.ButtonType =
RadButtonType.LinkButton
btn.EnableEmbeddedSkins =
False
btn.Skin = Common.
Constants.SkinDefault
btn.CausesValidation =
False
btn.Text = Common.Resources.
Messages.RibbonVergaderingen
btn.CommandArgument = Common.PadNaarVergaderingenLijstPagina
AddHandler btn.Click, AddressOf btn_Click
Private
Sub btn_Click(ByVal sender As Object, ByVal e As EventArgs)
Me.Presenter.Model.RefererUrl = DirectCast(sender, RadButton).CommandArgument
onclientcollapsed
<
telerik:RadSlidingZone
ID
=
"rszExtraInfo"
runat
=
"server"
ClickToOpen
=
"True"
SlideDirection
=
"Left"
SkinID
=
"Vista"
>
<
telerik:RadSlidingPane
ID
=
"RadSlidingPane1"
Runat
=
"server"
EnableResize
=
"False"
onclientexpanding
=
"FetchExtraInfo"
Title
=
"More Info"
Width
=
"400px"
onclientcollapsed
=
"HideExtraInfo"
>
<
asp:Panel
ID
=
"pnlExtraInfo"
runat
=
"server"
Height
=
"100%"
Width
=
"100%"
>
</
asp:Panel
>
</
telerik:RadSlidingPane
>
</
telerik:RadSlidingZone
>
function
HideExtraInfo(sender) {
document.getElementById(
'<%= pnlExtraInfo.ClientID%>'
).style.display =
'none'
;
}
DataTable
dt = _presenter.GetAllMenu();
radMenu1.DataFieldParentID =
"ParentMenuId";
radMenu1.DataFieldID =
"MenuId";
radMenu1.DataNavigateUrlField =
"Link";
radMenu1.DataTextField =
"MenuName";
radMenu1.DataValueField =
"MenuId";
radMenu1.DataSource = dt;
radMenu1.DataBind();
Please help.
Neel