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