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

set the export file name and extension of excel

1 Answer 196 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Kevin
Top achievements
Rank 1
Kevin asked on 06 Jun 2011, 02:07 PM
I have followed a lot of the things online but my export filename seems to work but not the extension of the excel file.  It always ends up being aspx and it gives me the trusted file error.  I think I am getting this because it does not like the aspx extension.

 <telerik:RadGrid ID="myRadGrid" runat="server" Width="95%" BorderWidth="1px" CellPadding="6" GridLines="Horizontal" BorderColor="#404040" Skin="Web20" ExportSettings-Excel-Format="Html"
                ExportSettings-FileName="DeployReport" ExportSettings-ExportOnlyData="true"
                ExportSettings-Pdf-AllowPrinting="true"><ExportSettings><Pdf FontType="Subset" PaperSize="Letter" PageTitle="No Show Report" /><Excel Format="html" FileExtension="xls" /></ExportSettings>
                <MasterTableView AutoGenerateColumns="false" HierarchyDefaultExpanded="false" HierarchyLoadMode="ServerBind" BorderColor="#404040" Font-Size="10" Font-Names="Veranda,arial,sans-serif"
                HeaderStyle-HorizontalAlign="Center" GridLines="Horizontal" CommandItemSettings-ShowExportToPdfButton="true" CommandItemDisplay="Top" CommandItemSettings-ShowExportToExcelButton="true"
                CommandItemSettings-ShowAddNewRecordButton="false" CommandItemSettings-ShowRefreshButton="false" CommandItemSettings-ShowExportToWordButton="true">
                <AlternatingItemStyle BackColor="#B0C4DE" />
                <HeaderStyle ForeColor="White" Font-Bold="true" BorderColor="#404040" BorderWidth="1px" />
                    <Columns>
                        <telerik:GridBoundColumn HeaderText="UIC" DataField="strUIC"></telerik:GridBoundColumn>
                        <telerik:GridBoundColumn HeaderText="Att UIC" DataField="AttUIC"></telerik:GridBoundColumn>
                        <telerik:GridBoundColumn HeaderText="Rank" DataField="strRank"></telerik:GridBoundColumn>
                        <telerik:GridBoundColumn HeaderText="Name" DataField="strFullName"></telerik:GridBoundColumn>
                        <telerik:GridBoundColumn HeaderText="SRPType" DataField="strSrpname"></telerik:GridBoundColumn>
                        <telerik:GridBoundColumn HeaderText="IN" DataField="TimeIn"></telerik:GridBoundColumn>
                        <telerik:GridBoundColumn HeaderText="Out" DataField="TimeOut"></telerik:GridBoundColumn>
                        <telerik:GridBoundColumn HeaderText="Process Time" DataField="ProcessTime"></telerik:GridBoundColumn>
                        <telerik:GridBoundColumn HeaderText="Deployable" DataField="deployable"></telerik:GridBoundColumn>
                    </Columns>
                 </MasterTableView>
                </telerik:RadGrid>

1 Answer, 1 is accepted

Sort by
0
Princy
Top achievements
Rank 2
answered on 06 Jun 2011, 03:00 PM
Hello Kevin,

I suppose you have set some Unknown extension and that is why the exported page is opening with  aspx extension.
Please check out the following forum for more on this.

File Extension Not Working for Excel Export

Thanks,
Princy.
Tags
Grid
Asked by
Kevin
Top achievements
Rank 1
Answers by
Princy
Top achievements
Rank 2
Share this question
or