Telerik Forums / UI for ASP.NET AJAX
This is a migrated thread and some comments may be shown as answers.

Export to excel, missing columns

1 Answer 103 Views
Grid
This is a migrated thread and some comments may be shown as answers.
JonathanElsner
Top achievements
Rank 1
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>

1 Answer, 1 is accepted

Sort by
0
JonathanElsner
Top achievements
Rank 1
answered on 28 Jul 2011, 07:21 PM
I got it working by adding
<MasterTableView UseAllDataFields="true">
Tags
Grid
Asked by
JonathanElsner
Top achievements
Rank 1
Answers by
JonathanElsner
Top achievements
Rank 1
Share this question
or