I am trying to export RadGrid data into ExcelML format but the resulting spreadsheet is always empty. If I set the format to HTML the data is all there but the HTML content I have in one of the fields is broken over a number of rows. Is there any reason why ExcelML isn't working?
Cheers
Peter
View File:
<telerik:radgrid ID="gvHotels" runat="server" OnNeedDataSource="gvHotels_NeedDataSource" GridLines="None" Skin="WebBlue" autogeneratecolumns="true" visible="true">
<MasterTableView DataKeyNames="HotelCode" CommandItemDisplay="None" currentresetpageindexaction="SetPageIndexToFirst" dir="LTR" frame="Border" tablelayout="Auto" allowsorting="True" showfooter="false">
<RowIndicatorColumn Visible="False" currentfilterfunction="NoFilter" filterlistoptions="VaryByDataType">
<HeaderStyle Width="20px" />
</RowIndicatorColumn>
<ExpandCollapseColumn Visible="False" Resizable="False" currentfilterfunction="NoFilter" filterlistoptions="VaryByDataType">
<HeaderStyle Width="20px" />
</ExpandCollapseColumn>
<editformsettings>
<editcolumn currentfilterfunction="NoFilter" filterlistoptions="VaryByDataType">
</editcolumn>
</editformsettings>
<columns>
</columns>
</MasterTableView>
<exportsettings>
<pdf fonttype="Subset" papersize="Letter" />
<excel format="ExcelML" />
<csv columndelimiter="Comma" rowdelimiter="NewLine" />
</exportsettings>
</telerik:radgrid>
Code-Behind File:
protected void gvHotels_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
gvHotels.DataSource =
TraxExporter.GetHotels();
}
protected void cmdExportHotels_Click(object sender, EventArgs e)
{
gvHotels.ExportSettings.ExportOnlyData =
true;
gvHotels.ExportSettings.IgnorePaging =
true;
gvHotels.ExportSettings.OpenInNewWindow =
true;
gvHotels.MasterTableView.ExportToExcel();
}