I'm trying to export the contents of a RadGridView to 'xls'.
Everything works fine on my Development machine (Windows 7 & Visual Studio 2010).
Once I deploy the XAP the the server (IIS 7) the "export to excel" is unable to save the xls file to my HDD.
the "SaveAs" Dialog box opens normally, i type the name of the file in "File name", hit Save....but no file is saved.
if i already have an xls file saved to the HDD and i try to rewrite it it will get deleted.
Please note that I'm unable to save an exported xls or csv file even from the demo on http://demos.telerik.com/silverlight/#GridView/Exporting
below is my XAML & code
Any Help is much appreciated
Ghayth
Everything works fine on my Development machine (Windows 7 & Visual Studio 2010).
Once I deploy the XAP the the server (IIS 7) the "export to excel" is unable to save the xls file to my HDD.
the "SaveAs" Dialog box opens normally, i type the name of the file in "File name", hit Save....but no file is saved.
if i already have an xls file saved to the HDD and i try to rewrite it it will get deleted.
Please note that I'm unable to save an exported xls or csv file even from the demo on http://demos.telerik.com/silverlight/#GridView/Exporting
below is my XAML & code
<
telerik:RadGridView
Grid.Row
=
"3"
Name
=
"gvInvalid"
Margin
=
"0,0,0,5"
AutoGenerateColumns
=
"False"
IsReadOnly
=
"True"
ShowGroupPanel
=
"False"
CanUserInsertRows
=
"False"
CanUserDeleteRows
=
"False"
RowIndicatorVisibility
=
"Collapsed"
>
<
telerik:GridViewDataControl.Columns
>
<
telerik:GridViewDataColumn
Header
=
"Cusip/Ticker"
DataMemberBinding
=
"{Binding Cusip__Ticker, Mode=OneTime}"
/>
<
telerik:GridViewDataColumn
Header
=
"Action"
DataMemberBinding
=
"{Binding Action, Mode=OneTime}"
/>
<
telerik:GridViewDataColumn
Header
=
"Transaction ID"
DataMemberBinding
=
"{Binding Transaction_ID, Mode=OneTime}"
/>
<
telerik:GridViewDataColumn
Header
=
"Trade Date"
DataMemberBinding
=
"{Binding Trade_Date, Mode=OneTime}"
/>
<
telerik:GridViewDataColumn
Header
=
"Settlement Date"
DataMemberBinding
=
"{Binding Settlement_Date, Mode=OneTime}"
/>
<
telerik:GridViewDataColumn
Header
=
"Original Face Amount"
DataMemberBinding
=
"{Binding Original_Face_Amount, Mode=OneTime}"
/>
<
telerik:GridViewDataColumn
Header
=
"Face Amount/Shares"
DataMemberBinding
=
"{Binding Face_Amount__Shares, Mode=OneTime}"
/>
<
telerik:GridViewDataColumn
Header
=
"Principal"
DataMemberBinding
=
"{Binding Principal, Mode=OneTime}"
/>
<
telerik:GridViewDataColumn
Header
=
"Accrued Interest"
DataMemberBinding
=
"{Binding Accrued_Interest, Mode=OneTime}"
/>
<
telerik:GridViewDataColumn
Header
=
"Portfolio/Fund"
DataMemberBinding
=
"{Binding Portfolio__Fund, Mode=OneTime}"
/>
<
telerik:GridViewDataColumn
Header
=
"Custodian"
DataMemberBinding
=
"{Binding Custodian, Mode=OneTime}"
/>
<
telerik:GridViewDataColumn
Header
=
"Broker"
DataMemberBinding
=
"{Binding Broker, Mode=OneTime}"
/>
<
telerik:GridViewDataColumn
Header
=
"Amortization Frequency"
DataMemberBinding
=
"{Binding Amortization_Frequency, Mode=OneTime}"
/>
<
telerik:GridViewDataColumn
Header
=
"Amortization End Date"
DataMemberBinding
=
"{Binding Amortization_End_Date, Mode=OneTime}"
/>
<
telerik:GridViewDataColumn
Header
=
"Details"
DataMemberBinding
=
"{Binding Note, Mode=OneTime}"
/>
</
telerik:GridViewDataControl.Columns
>
</
telerik:RadGridView
>
private
void
hlbExportInvalidItems_Click(
object
sender, RoutedEventArgs e)
{
Telerik.Windows.Controls.ExportFormat format = Telerik.Windows.Controls.ExportFormat.Html;
string
extension =
"xls"
;
SaveFileDialog dialog =
new
SaveFileDialog();
dialog.DefaultExt = extension;
dialog.Filter = String.Format(
"{1} files (*.{0})|*.{0}|All files (*.*)|*.*"
, extension,
"Excel"
);
dialog.FilterIndex = 1;
if
(dialog.ShowDialog() ==
true
)
{
using
(Stream stream = dialog.OpenFile())
{
Telerik.Windows.Controls.GridViewExportOptions exportOptions =
new
Telerik.Windows.Controls.GridViewExportOptions();
exportOptions.Format = format;
exportOptions.ShowColumnFooters =
true
;
exportOptions.ShowColumnHeaders =
true
;
exportOptions.ShowGroupFooters =
false
;
gvInvalid.Export(stream, exportOptions);
}
}
}
Any Help is much appreciated
Ghayth