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

RadGrid Export To Excel Issues

1 Answer 82 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Tom
Top achievements
Rank 1
Tom asked on 08 Sep 2010, 08:30 PM
Hello,

I am having some issues with the RadGrid Export To Excel.  I am using the telerik 2010 Q1 RadGrid.  My grid designer code is as follows:

<telerik:RadGrid ID="RadGridResult" runat="server" Skin="Simple" PagerStyle-AlwaysVisible="true" Width="99%" OnNeedDataSource="RadGridResult_NeedDataSource"
     ItemStyle-Wrap="false" HeaderStyle-Wrap="false" AllowSorting="true" AllowPaging="true" PageSize="20" >
    <ClientSettings>
        <Scrolling AllowScroll="true" UseStaticHeaders="true" />
    </ClientSettings>
    <PagerStyle Mode="NumericPages"></PagerStyle>
    <MasterTableView ShowHeader="true" AutoGenerateColumns="false" TableLayout="Auto" ItemStyle-Wrap="false" UseAllDataFields="true"
        HeaderStyle-Wrap="false">
        <NoRecordsTemplate>
            <asp:Label ID="lblMsg" runat="server" Text="No Records found"></asp:Label>
        </NoRecordsTemplate>
        <Columns>
            <telerik:GridBoundColumn DataField="CallerName" HeaderText="Caller's Name" SortExpression="CallerName" UniqueName="CallerName" />
            <telerik:GridBoundColumn DataField="CallRequestorObject.CallRequestorDesc" HeaderText="Requestor Type" SortExpression="CallRequestorObject.CallRequestorDesc" UniqueName="RequestorType" />
            <telerik:GridBoundColumn DataField="Address1" HeaderText="Address" SortExpression="Address1" UniqueName="Address1" />
            <telerik:GridBoundColumn DataField="Address2" HeaderText="Address" SortExpression="Address2" UniqueName="Address2" />
            <telerik:GridBoundColumn DataField="City" HeaderText="City" SortExpression="City" UniqueName="City" />
            <telerik:GridBoundColumn DataField="StateCode" HeaderText="State" SortExpression="StateCode" UniqueName="StateCode" />
            <telerik:GridBoundColumn DataField="Zip" HeaderText="Zip" SortExpression="Zip" UniqueName="Zip" />
            <telerik:GridBoundColumn DataField="FormattedPhone" HeaderText="Phone Number" SortExpression="FormattedPhone" UniqueName="FormattedPhone" />
            <telerik:GridBoundColumn DataField="InquiryTypeObject.InquiryTypeDesc" HeaderText="Nature of Inquiry" SortExpression="InquiryTypeObject.InquiryTypeDesc" UniqueName="InquiryType" />
            <telerik:GridBoundColumn DataField="CallDate" HeaderButtonType="TextButton" HeaderText="Date of Call" SortExpression="CallDate" UniqueName="CallDate" DataFormatString="{0:MM/dd/yyyy hh:mm tt}" />
        </Columns>
    </MasterTableView>
    <ExportSettings>
        <Pdf FontType="Subset" PaperSize="Letter" />
        <Excel Format="ExcelML" />
        <Csv ColumnDelimiter="Comma" RowDelimiter="NewLine" />
    </ExportSettings>
    <ClientSettings>
        <Scrolling AllowScroll="True" />
    </ClientSettings>                            
</telerik:RadGrid>

My run-time code is as follows:

RadGridResult.ExportSettings.ExportOnlyData = true;
RadGridResult.ExportSettings.IgnorePaging = true;
RadGridResult.ExportSettings.OpenInNewWindow = true;
RadGridResult.MasterTableView.ExportToExcel();

When my some of my users (with Excel 2007) attempt to export a grid to Excel, they receive the message:

'C:\Documents and Settings\[username]\Local Settings\Temporary Internet Files\Content.IE5\8ZAR05UB\RadGridExport[1].xls' could not be found.  Check the spelling of the file name, and verify that the file location is correct.

What could be causing this error?

Thanks

1 Answer, 1 is accepted

Sort by
0
Daniel
Telerik team
answered on 13 Sep 2010, 09:45 PM
Hello Tom,

Your code is correct. Could you please ask your users to try to export in another browser since I suppose this is IE-only problem?

Best regards,
Daniel
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Tags
Grid
Asked by
Tom
Top achievements
Rank 1
Answers by
Daniel
Telerik team
Share this question
or