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:
My run-time code is as follows:
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
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