This is a migrated thread and some comments may be shown as answers.

Export to excel, missing columns

1 Answer 162 Views

Grid

This is a migrated thread and some comments may be shown as answers.

JonathanElsner asked on 28 Jul 2011, 05:08 PM

When I export to excel only one column (UnitSF) is being exported. Any suggestions?
I also found it works for <Excel Format = "Html" />
But NOT for <Excel Format = "ExcelML" />
Note: exporting to pdf exports all columns.

<telerik:RadGrid runat="server" ID="RadGrid1" AllowPaging="True" AllowSorting="True"

AllowFilteringByColumn="True" PageSize="50" AutoGenerateColumns="False" DataSourceID="ds1"

GridLines="None" Height="500px" ShowFooter="True" Skin="WebBlue"

OnExcelMLExportRowCreated="RadGrid1_ExcelMLExportRowCreated"

OnExcelMLExportStylesCreated="RadGrid1_ExcelMLExportStylesCreated"

ShowStatusBar="true">

<ClientSettings>

<ClientEvents OnRowContextMenu="RowContextMenu" />

<Resizing AllowColumnResize="true" AllowResizeToFit="true" ClipCellContentOnResize="false" />

<Scrolling AllowScroll="True" UseStaticHeaders="True" SaveScrollPosition="true" />

</ClientSettings>

<ExportSettings ExportOnlyData="true" IgnorePaging="false" OpenInNewWindow="true">

<Excel Format="ExcelML" />

</ExportSettings>

<SortingSettings SortedBackColor="Red" />

<MasterTableView TableLayout="Fixed" OnDataBinding="MasterTableView_DataBinding"

OverrideDataSourceControlSorting="true" EnableHeaderContextMenu="true" EnableHeaderContextAggregatesMenu="true"

EnableHeaderContextFilterMenu="true" CommandItemDisplay="Bottom">

<PagerStyle Mode="NextPrevNumericAndAdvanced" AlwaysVisible="True" />

<CommandItemSettings ShowAddNewRecordButton="false" ShowExportToPdfButton="true"

ExportToPdfText="Export to PDF" ShowExportToExcelButton="true" />

<Columns>

<telerik:GridCheckBoxColumn DataField="FutureLease" DataType="System.Boolean" FilterControlAltText="Filter FutureLease column"

HeaderText="Future Lease" SortExpression="FutureLease" UniqueName="FutureLease"

HeaderStyle-Width="120px">

</telerik:GridCheckBoxColumn>

<telerik:GridBoundColumn DataField="ShoppingCenterID" FilterControlAltText="Filter ShoppingCenterID column"

HeaderText="Shopping Center ID" SortExpression="ShoppingCenterID" UniqueName="ShoppingCenterID"

HeaderStyle-Width="120px">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ShoppingCenterName" FilterControlAltText="Filter ShoppingCenterName column"

HeaderText="Shopping Center Name" SortExpression="ShoppingCenterName" UniqueName="ShoppingCenterName"

HeaderStyle-Width="120px">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="UnitNumber" FilterControlAltText="Filter UnitNumber column"

HeaderText="Unit #" SortExpression="UnitNumber" UniqueName="UnitNumber" HeaderStyle-Width="120px">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="LeaseNumber" DataType="System.Int32" FilterControlAltText="Filter LeaseNumber column"

HeaderText="Lease Number" SortExpression="LeaseNumber" UniqueName="LeaseNumber"

HeaderStyle-Width="120px">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="UnitSF" DataType="System.Int32" FilterControlAltText="Filter UnitSF column"

HeaderText="UnitSF" SortExpression="UnitSF" UniqueName="UnitSF" DataFormatString="{0:n0}"

Aggregate="Sum" HeaderStyle-Width="120px">

<ItemStyle HorizontalAlign="Right" />

<FooterStyle HorizontalAlign="Right" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="TenantName" FilterControlAltText="Filter TenantName column"

HeaderText="TenantName" SortExpression="TenantName" UniqueName="TenantName" HeaderStyle-Width="120px">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="TenantNumber" DataType="System.Int32" FilterControlAltText="Filter TenantNumber column"

HeaderText="TenantNumber" SortExpression="TenantNumber" UniqueName="TenantNumber"

HeaderStyle-Width="120px">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="LeaseBeginDate" DataType="System.DateTime" FilterControlAltText="Filter LeaseBeginDate column"

HeaderText="Lease Begin Date" SortExpression="LeaseBeginDate" UniqueName="LeaseBeginDate"

DataFormatString="{0:MM/dd/yyyy}" HeaderStyle-Width="120px">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="MoveInDate" DataType="System.DateTime" FilterControlAltText="Filter MoveInDate column"

HeaderText="Move In Date" SortExpression="MoveInDate" UniqueName="MoveInDate"

DataFormatString="{0:MM/dd/yyyy}" HeaderStyle-Width="120px">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="LeaseEndDate" DataType="System.DateTime" FilterControlAltText="Filter LeaseEndDate column"

HeaderText="LeaseEndDate" SortExpression="LeaseEndDate" UniqueName="LeaseEndDate"

DataFormatString="{0:MM/dd/yyyy}" HeaderStyle-Width="120px">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="LeaseStatus" FilterControlAltText="Filter LeaseStatus column"

HeaderText="LeaseStatus" SortExpression="LeaseStatus" UniqueName="LeaseStatus"

HeaderStyle-Width="120px">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="UnitType" FilterControlAltText="Filter UnitType column"

HeaderText="UnitType" SortExpression="UnitType" UniqueName="UnitType" HeaderStyle-Width="120px">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="LastTenantMoveoutDate" DataType="System.DateTime"

FilterControlAltText="Filter LastTenantMoveoutDate column" HeaderText="LastTenantMoveoutDate"

SortExpression="LastTenantMoveoutDate" UniqueName="LastTenantMoveoutDate" DataFormatString="{0:MM/dd/yyyy}"

HeaderStyle-Width="120px">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="LastTenantBaseRent" DataType="System.Decimal"

FilterControlAltText="Filter LastTenantBaseRent column" HeaderText="LastTenantBaseRent"

SortExpression="LastTenantBaseRent" UniqueName="LastTenantBaseRent" HeaderStyle-Width="120px">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="LeaseType" FilterControlAltText="Filter LeaseType column"

HeaderText="LeaseType" SortExpression="LeaseType" UniqueName="LeaseType" HeaderStyle-Width="120px">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ActualMoveoutDate" DataType="System.DateTime"

FilterControlAltText="Filter ActualMoveoutDate column" HeaderText="ActualMoveoutDate"

SortExpression="ActualMoveoutDate" UniqueName="ActualMoveoutDate" DataFormatString="{0:MM/dd/yyyy}"

HeaderStyle-Width="120px">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="TenantSICType" FilterControlAltText="Filter TenantSICType column"

HeaderText="TenantSICType" SortExpression="TenantSICType" UniqueName="TenantSICType"

HeaderStyle-Width="120px">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="LeaseULICode" FilterControlAltText="Filter LeaseULICode column"

HeaderText="LeaseULICode" SortExpression="LeaseULICode" UniqueName="LeaseULICode"

HeaderStyle-Width="120px">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="BaseRentPSF" DataType="System.Decimal" FilterControlAltText="Filter BaseRentPSF column"

HeaderText="BaseRentPSF" SortExpression="BaseRentPSF" UniqueName="BaseRentPSF"

DataFormatString="{0:c2}" HeaderStyle-Width="120px">

<ItemStyle HorizontalAlign="Right" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="CAMPSF" DataType="System.Decimal" FilterControlAltText="Filter CAMPSF column"

HeaderText="CAMPSF" SortExpression="CAMPSF" UniqueName="CAMPSF" DataFormatString="{0:c2}"

HeaderStyle-Width="120px">

<ItemStyle HorizontalAlign="Right" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="TAXPSF" DataType="System.Decimal" FilterControlAltText="Filter TAXPSF column"

HeaderText="TAXPSF" SortExpression="TAXPSF" UniqueName="TAXPSF" DataFormatString="{0:c2}"

HeaderStyle-Width="120px">

<ItemStyle HorizontalAlign="Right" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="INSPSF" DataType="System.Decimal" FilterControlAltText="Filter INSPSF column"

HeaderText="INSPSF" SortExpression="INSPSF" UniqueName="INSPSF" DataFormatString="{0:c2}"

HeaderStyle-Width="120px">

<ItemStyle HorizontalAlign="Right" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="OtherPSF" DataType="System.Decimal" FilterControlAltText="Filter OtherPSF column"

HeaderText="OtherPSF" SortExpression="OtherPSF" UniqueName="OtherPSF" DataFormatString="{0:c2}"

HeaderStyle-Width="120px">

<ItemStyle HorizontalAlign="Right" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="GrossChargesPSF" DataType="System.Decimal" FilterControlAltText="Filter GrossChargesPSF column"

HeaderText="GrossChargesPSF" SortExpression="GrossChargesPSF" UniqueName="GrossChargesPSF"

DataFormatString="{0:c2}" HeaderStyle-Width="120px">

<ItemStyle HorizontalAlign="Right" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="BaseRentAnnual" DataType="System.Decimal" FilterControlAltText="Filter BaseRentAnnual column"

HeaderText="BaseRentAnnual" SortExpression="BaseRentAnnual" UniqueName="BaseRentAnnual"

DataFormatString="{0:c2}" HeaderStyle-Width="120px">

<ItemStyle HorizontalAlign="Right" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="CAMAnnual" DataType="System.Decimal" FilterControlAltText="Filter CAMAnnual column"

HeaderText="CAMAnnual" SortExpression="CAMAnnual" UniqueName="CAMAnnual" DataFormatString="{0:c2}"

HeaderStyle-Width="120px">

<ItemStyle HorizontalAlign="Right" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="TAXAnnual" DataType="System.Decimal" FilterControlAltText="Filter TAXAnnual column"

HeaderText="TAXAnnual" SortExpression="TAXAnnual" UniqueName="TAXAnnual" DataFormatString="{0:c2}"

HeaderStyle-Width="120px">

<ItemStyle HorizontalAlign="Right" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="INSAnnual" DataType="System.Decimal" FilterControlAltText="Filter INSAnnual column"

HeaderText="INSAnnual" SortExpression="INSAnnual" UniqueName="INSAnnual" DataFormatString="{0:c2}"

HeaderStyle-Width="120px">

<ItemStyle HorizontalAlign="Right" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="OtherAnnual" DataType="System.Decimal" FilterControlAltText="Filter OtherAnnual column"

HeaderText="OtherAnnual" SortExpression="OtherAnnual" UniqueName="OtherAnnual"

DataFormatString="{0:c2}" HeaderStyle-Width="120px">

<ItemStyle HorizontalAlign="Right" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="GrossAnnual" DataType="System.Decimal" FilterControlAltText="Filter GrossAnnual column"

HeaderText="GrossAnnual" SortExpression="GrossAnnual" UniqueName="GrossAnnual"

DataFormatString="{0:c2}" HeaderStyle-Width="120px">

<ItemStyle HorizontalAlign="Right" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="LeaseVersion" DataType="System.Int32" FilterControlAltText="Filter LeaseVersion column"

HeaderText="LeaseVersion" SortExpression="LeaseVersion" UniqueName="LeaseVersion"

HeaderStyle-Width="120px">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Division" FilterControlAltText="Filter Division column"

HeaderText="Division" SortExpression="Division" UniqueName="Division" HeaderStyle-Width="120px">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="SuperRegion" FilterControlAltText="Filter SuperRegion column"

HeaderText="SuperRegion" SortExpression="SuperRegion" UniqueName="SuperRegion"

HeaderStyle-Width="120px">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Region" FilterControlAltText="Filter Region column"

HeaderText="Region" SortExpression="Region" UniqueName="Region" HeaderStyle-Width="120px">

</telerik:GridBoundColumn>

<telerik:GridCheckBoxColumn DataField="IsHotTenant" DataType="System.Boolean" FilterControlAltText="Filter IsHotTenant column"

HeaderText="IsHotTenant" SortExpression="IsHotTenant" UniqueName="IsHotTenant"

HeaderStyle-Width="120px">

</telerik:GridCheckBoxColumn>

<telerik:GridBoundColumn DataField="LeaseActivityCode8" FilterControlAltText="Filter LeaseActivityCode8 column"

HeaderText="LeaseActivityCode8" SortExpression="LeaseActivityCode8" UniqueName="LeaseActivityCode8"

HeaderStyle-Width="120px">

</telerik:GridBoundColumn>

<telerik:GridCheckBoxColumn DataField="LeaseHasOptions" DataType="System.Boolean"

FilterControlAltText="Filter LeaseHasOptions column" HeaderText="LeaseHasOptions"

SortExpression="LeaseHasOptions" UniqueName="LeaseHasOptions" HeaderStyle-Width="120px">

</telerik:GridCheckBoxColumn>

<telerik:GridCheckBoxColumn DataField="LeaseHasRentSteps" DataType="System.Boolean"

FilterControlAltText="Filter LeaseHasRentSteps column" HeaderText="LeaseHasRentSteps"

SortExpression="LeaseHasRentSteps" UniqueName="LeaseHasRentSteps" HeaderStyle-Width="120px">

</telerik:GridCheckBoxColumn>

<telerik:GridBoundColumn DataField="LeaseSupplementalDate" DataType="System.DateTime"

FilterControlAltText="Filter LeaseSupplementalDate column" HeaderText="LeaseSupplementalDate"

SortExpression="LeaseSupplementalDate" UniqueName="LeaseSupplementalDate" DataFormatString="{0:MM/dd/yyyy}"

HeaderStyle-Width="120px">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="LeaseULIDescription" FilterControlAltText="Filter LeaseULIDescription column"

HeaderText="LeaseULIDescription" SortExpression="LeaseULIDescription" UniqueName="LeaseULIDescription"

HeaderStyle-Width="120px">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="LeasedSF" DataType="System.Int32" FilterControlAltText="Filter LeasedSF column"

HeaderText="LeasedSF" SortExpression="LeasedSF" UniqueName="LeasedSF" HeaderStyle-Width="120px">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="LeasingAgent" FilterControlAltText="Filter LeasingAgent column"

HeaderText="LeasingAgent" SortExpression="LeasingAgent" UniqueName="LeasingAgent"

HeaderStyle-Width="120px">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ParentTenantName" FilterControlAltText="Filter ParentTenantName column"

HeaderText="ParentTenantName" SortExpression="ParentTenantName" UniqueName="ParentTenantName"

HeaderStyle-Width="120px">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="PropertyManager" FilterControlAltText="Filter PropertyManager column"

HeaderText="PropertyManager" SortExpression="PropertyManager" UniqueName="PropertyManager"

HeaderStyle-Width="120px">

<FilterTemplate>

<telerik:RadComboBox ID="RadComboBoxPropertyManager" DataSourceID="dsPM" DataTextField="Text"

DataValueField="Value" Height="200px" AppendDataBoundItems="true" SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("PropertyManager").CurrentFilterValue %>'

runat="server" OnClientSelectedIndexChanged="PMChanged">

<Items>

<telerik:RadComboBoxItem Text="All" />

</Items>

</telerik:RadComboBox>

<telerik:RadScriptBlock ID="RadScriptBlock1" runat="server">

<script type="text/javascript">

function PMChanged(sender, args) {

var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");

tableView.filter("PropertyManager", args.get_item().get_value(), "EqualTo");

}

</script>

</telerik:RadScriptBlock>

</FilterTemplate>

</telerik:GridBoundColumn>

</Columns>

</MasterTableView>

<PagerStyle AlwaysVisible="True" />

<FilterMenu EnableImageSprites="False">

</FilterMenu>

<HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Default">

</HeaderContextMenu>

</telerik:RadGrid>

Export to excel, missing columns

1 Answer, 1 is accepted