Radgrid导出到excel不起作用 [英] Radgrid export to excel is not working
问题描述
虽然我将radgrid数据导出到excel，但是我的代码不能正常工作，我有什么问题请不要帮助我。
.aspx page代码
< Rad：RadGrid ID =GvPVoltrunat =serverAutoGenerateColumns =FalseGridLines =Both
OnItemCommand =GvPVolt_ItemCommand önPageIndexChanged=GvPVolt_PageIndexChangedOnPreRender =GvPVolt_PreRenderAllowSorting =trueAllowPaging =truePageSize =10
GroupingEnabled =trueSkin =OutlookShowGroupPanel =true> ;
< pagerstyle mode =NextPrevAndNumeric>
< mastertableview commanditemdisplay =Topenablenorecordstemplate =true>
<列> < rad：gridboundcolumn datafield =Siteidheaderstyle-font-bold =trueheadertext =Siteidxmlns：rad =＃unknown>
HeaderStyle-HorizontalAlign =CenterItemStyle -HorizontalAlign =Center/>
< rad：gridboundcolumn datafield =Rxdateheaderstyle-font-bold =trueheadertext =Date& Time>
HeaderStyle-HorizontalAlign =LeftItemStyle-HorizontalAlign =Right/>
< rad：gridboundcolumn datafield =RphaseCurrentheaderstyle-font-bold =trueheadertext = R相电流>
HeaderStyle-HorizontalAlign =LeftItemStyle-HorizontalAlign =Left/>
< rad：gridboundcolumn headerstyle-horizontalalign = leftheaderstyle-font-bold =true>
ItemStyle-HorizontalAlign =LeftDataField =YphaseCurrent HeaderText =Y相电流/>
< rad：gridboundcolumn headerstyle-horizontalalign =左headerstyle-font-bold =true>
ItemStyle-HorizontalAlign =RightDataField =BphaseCurrentHeaderText =B相电流/>
< commanditemsettings showexporttoexcelbutton =trueshowrefreshbutton =trueshowaddnewrecordbutton =false>
< exportsettings hidestructurecolumns = trueexcel-format =Html>
< clientsettings allowcolumnsreorder =trueallowdragtogroup =truereordercolumnsonclient =true>
ColumnsReorderMethod =重新排序>
< resizing allowrowresize =falseenablerealtimeresize =Trueresizegridoncolumnresize =True>
AllowColumnResize =True>
.aspx.cs代码
公共部分class Reports_FaultCurrentReport：System.Web.UI.Page
{
protected void Page_Load（object sender，EventArgs e）
{
if（！IsPostBack）
{
BindGraph（）;
}
}
protected void BindGraph（）
{
ds = DataAccessLayer.BindDataQuery（select Siteid，Rxdate，来自tblsitedata1的RphaseCurrent，其中Siteid ='+ Session [Transformer]。ToString（）+'和RphaseCurrent< '+ ViewState [CurrentL] +'和RxDate介于'+ frmTime +'和dateadd（second，-1，'+ tTime +'））;
GvPVolt .DataSource = ds;
GvPVolt.DataBind（）;
}
protected void GvPVolt_PreRender（object sender，EventArgs e）
{
BindGraph（）;
}
protected void GvPVolt_ItemCommand（object sender，GridCommandEventArgs e）
{
if（e.CommandName == RadGrid.ExportToExcelCommandName）
ConfigureExport（）;
}
public void ConfigureExport（）
{
GvPVolt.ExportSettings.ExportOnlyData = false;
GvPVolt.ExportSettings.IgnorePaging = true;
GvPVolt.ExportSettings.OpenInNewWindow = true;
GvPVolt.MasterTableView.ExportToExcel（）;
}
}
While i am exporting the radgrid data to the excel it is not working below is my code,what is the problem i am not getting please help me from this.
.aspx page code
<Rad:RadGrid ID="GvPVolt" runat="server" AutoGenerateColumns="False" GridLines="Both"
OnItemCommand="GvPVolt_ItemCommand" önPageIndexChanged="GvPVolt_PageIndexChanged" OnPreRender="GvPVolt_PreRender" AllowSorting="true" AllowPaging="true" PageSize="10"
GroupingEnabled="true" Skin="Outlook" ShowGroupPanel="true" >
<pagerstyle mode="NextPrevAndNumeric">
<mastertableview commanditemdisplay="Top" enablenorecordstemplate="true">
<columns> <rad:gridboundcolumn datafield="Siteid" headerstyle-font-bold="true" headertext="Siteid" xmlns:rad="#unknown">
HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" />
<rad:gridboundcolumn datafield="Rxdate" headerstyle-font-bold="true" headertext="Date & Time">
HeaderStyle-HorizontalAlign="Left" ItemStyle-HorizontalAlign="Right" />
<rad:gridboundcolumn datafield="RphaseCurrent" headerstyle-font-bold="true" headertext="R-phase Current">
HeaderStyle-HorizontalAlign="Left" ItemStyle-HorizontalAlign="Left" />
<rad:gridboundcolumn headerstyle-horizontalalign="Left" headerstyle-font-bold="true">
ItemStyle-HorizontalAlign="Left" DataField="YphaseCurrent" HeaderText="Y-phase Current" />
<rad:gridboundcolumn headerstyle-horizontalalign="Left" headerstyle-font-bold="true">
ItemStyle-HorizontalAlign="Right" DataField="BphaseCurrent" HeaderText="B-phase Current" />
<commanditemsettings showexporttoexcelbutton="true" showrefreshbutton="true" showaddnewrecordbutton="false">
<exportsettings hidestructurecolumns="true" excel-format="Html">
<clientsettings allowcolumnsreorder="true" allowdragtogroup="true" reordercolumnsonclient="true">
ColumnsReorderMethod="Reorder">
<resizing allowrowresize="false" enablerealtimeresize="True" resizegridoncolumnresize="True">
AllowColumnResize="True">
.aspx.cs code
public partial class Reports_FaultCurrentReport : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindGraph();
}
}
protected void BindGraph()
{
ds = DataAccessLayer.BindDataQuery("select Siteid,Rxdate,RphaseCurrent from tblsitedata1 where Siteid='" + Session["Transformer"].ToString() + "' and RphaseCurrent < '" + ViewState["CurrentL"] + "' and RxDate between '" + frmTime + "' and dateadd( second,-1,'" + tTime + "' )");
GvPVolt.DataSource = ds;
GvPVolt.DataBind();
}
protected void GvPVolt_PreRender(object sender, EventArgs e)
{
BindGraph();
}
protected void GvPVolt_ItemCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == RadGrid.ExportToExcelCommandName)
ConfigureExport();
}
public void ConfigureExport()
{
GvPVolt.ExportSettings.ExportOnlyData = false;
GvPVolt.ExportSettings.IgnorePaging = true;
GvPVolt.ExportSettings.OpenInNewWindow = true;
GvPVolt.MasterTableView.ExportToExcel();
}
}
推荐答案
检查后续行动翼链接
http://www.telerik.com/community/forums/aspnet-ajax/grid/355544-rad-grid-export-to-excel.aspx [ ^ ]
谢谢
Ipsita
Check the following link
http://www.telerik.com/community/forums/aspnet-ajax/grid/355544-rad-grid-export-to-excel.aspx[^]
Thanks
Ipsita
拜访她....
[ ^ ]
或
http://demos.telerik.com/aspnet-ajax/grid/examples/generalfe atures / exports / defaultcs.aspx [ ^ ]
visit her....
[^]
or
http://demos.telerik.com/aspnet-ajax/grid/examples/generalfeatures/exporting/defaultcs.aspx[^]
这篇关于Radgrid导出到excel不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
