Hi
I am trying to export RadGrid to Excel but it seems that that for numbers less than 4 digits decimal formatting is not maintained in Excel
my code in MainPage.xaml.cs
and in xaml my code is like
While i have seperate class for Club, Player, Position and a ViewModel.
I am attaching Screenshot for further reference.
Any help would be great
If possible provide some sample
Thanks
I am trying to export RadGrid to Excel but it seems that that for numbers less than 4 digits decimal formatting is not maintained in Excel
my code in MainPage.xaml.cs
public
partial
class
MainPage : UserControl
{
public
MainPage()
{
InitializeComponent();
}
private
void
Button1_Click(
object
sender, RoutedEventArgs e)
{
string
extension =
"xls"
;
SaveFileDialog dialog =
new
SaveFileDialog()
{
DefaultExt = extension,
Filter = String.Format(
"{1} files (*.{0})|*.{0}|All files (*.*)|*.*"
, extension,
"Excel"
),
FilterIndex = 1
};
if
(dialog.ShowDialog() ==
true
)
{
using
(Stream stream = dialog.OpenFile())
{
// MemoryStream ms = new MemoryStream();
clubsGrid.Export(stream,
new
GridViewExportOptions()
{
Format = ExportFormat.Html,
ShowColumnHeaders =
true
,
ShowColumnFooters =
true
,
ShowGroupFooters =
false
,
});
//byte[] header = Encoding.UTF8.GetBytes("Premier League");
//stream.Write(header, 0, header.Length);
//stream.Write(ms.ToArray(), 0, ms.ToArray().Length);
}
}
}
}
and in xaml my code is like
<
UserControl.Resources
>
<
my:MyViewModel
x:Key
=
"MyViewModel"
/>
</
UserControl.Resources
>
<
Grid
x:Name
=
"LayoutRoot"
Background
=
"White"
DataContext
=
"{StaticResource MyViewModel}"
>
<
Grid.RowDefinitions
>
<
RowDefinition
Height
=
"*"
/>
<
RowDefinition
Height
=
"Auto"
/>
</
Grid.RowDefinitions
>
<
Grid.Resources
>
<
DataTemplate
x:Key
=
"RowDetailsTemplate"
>
<
telerik:RadGridView
Name
=
"playersGrid"
ItemsSource
=
"{Binding Players}"
AutoGenerateColumns
=
"False"
>
<
telerik:RadGridView.Columns
>
<
telerik:GridViewDataColumn
DataMemberBinding
=
"{Binding Name}"
/>
<
telerik:GridViewDataColumn
DataMemberBinding
=
"{Binding Number}"
/>
<
telerik:GridViewDataColumn
DataMemberBinding
=
"{Binding Position}"
/>
<
telerik:GridViewDataColumn
DataMemberBinding
=
"{Binding Country}"
/>
</
telerik:RadGridView.Columns
>
</
telerik:RadGridView
>
</
DataTemplate
>
</
Grid.Resources
>
<
telerik:RadGridView
Name
=
"clubsGrid"
ItemsSource
=
"{Binding Clubs}"
AutoGenerateColumns
=
"False"
RowDetailsTemplate
=
"{StaticResource RowDetailsTemplate}"
Margin
=
"5,37,5,5"
Grid.RowSpan
=
"2"
>
<
telerik:RadGridView.Columns
>
<
telerik:GridViewToggleRowDetailsColumn
/>
<
telerik:GridViewDataColumn
DataMemberBinding
=
"{Binding Name}"
/>
<
telerik:GridViewDataColumn
DataMemberBinding
=
"{Binding Established}"
Header
=
"Est."
DataFormatString
=
"{}{0:yyyy}"
/>
<
telerik:GridViewDataColumn
DataMemberBinding
=
"{Binding StadiumCapacity}"
Header
=
"Stadium"
DataFormatString
=
"{}{0:N2}"
/>
</
telerik:RadGridView.Columns
>
</
telerik:RadGridView
>
<
Button
Grid.Row
=
"1"
Content
=
"Export"
Click
=
"Button1_Click"
Margin
=
"5"
HorizontalAlignment
=
"Left"
/>
</
Grid
>
While i have seperate class for Club, Player, Position and a ViewModel.
I am attaching Screenshot for further reference.
Any help would be great
If possible provide some sample
Thanks