This question is locked. New answers and comments are not allowed.
Good day!
we have a project with Silverlight3 and bot the latest version of Telerik
we export our grids to excel this way:
public static void ExportToXls(RadGridView grid)
{
SaveFileDialog textDialog = new SaveFileDialog();
textDialog.Filter = "XLS Files | *.csv";
textDialog.DefaultExt = "csv";
bool? result = textDialog.ShowDialog();
if (result == true)
{
System.Text.Encoding ascii = System.Text.Encoding.UTF8;
Encoding enc=Encoding.GetEncoding("cp1251");
string data = ExportExtensions.ToCsv(grid, true);
// data+=@"<script type=""text/javascript"">print();</script>";
data = data.Replace(",", ";");
System.IO.Stream fileStream = textDialog.OpenFile();
byte[] contents = enc.GetBytes(data);
fileStream.Write(contents, 0, contents.Length);
fileStream.Flush();
fileStream.Close();
}
}
but we have no idea how to make export to excel of three-tiered GridView (somthing like this:
<telerikGridView:RadGridView>
<telerikGridView:RadGridView.ChildTableDefinitions>
<telerikGridView:GridViewTableDefinition>
<telerikGridView:GridViewTableDefinition.Relation>
<telerikData:PropertyRelation ParentPropertyName="WorkPlaces" />
</telerikGridView:GridViewTableDefinition.Relation>
</telerikGridView:GridViewTableDefinition>
</telerikGridView:RadGridView.ChildTableDefinitions>
<telerikGridView:RadGridView.HierarchyChildTemplate>
<DataTemplate>
<telerikGridView:RadGridView ItemsSource="{Binding WorkPlaces}" >
<telerikGridView:RadGridView.ChildTableDefinitions>
<telerikGridView:GridViewTableDefinition>
<telerikGridView:GridViewTableDefinition.Relation>
<telerikData:PropertyRelation ParentPropertyName="Licenses" />
</telerikGridView:GridViewTableDefinition.Relation>
</telerikGridView:GridViewTableDefinition>
</telerikGridView:RadGridView.ChildTableDefinitions>
<telerikGridView:RadGridView.HierarchyChildTemplate>
<DataTemplate>
<telerikGridView:RadGridView
ItemsSource="{Binding Licenses}" >
</telerikGridView:RadGridView>
</telerikGridView:RadGridView>
</telerikGridView:RadGridView>
I want to see information of all the Girds in Excel.
How can I make it?
we have a project with Silverlight3 and bot the latest version of Telerik
we export our grids to excel this way:
public static void ExportToXls(RadGridView grid)
{
SaveFileDialog textDialog = new SaveFileDialog();
textDialog.Filter = "XLS Files | *.csv";
textDialog.DefaultExt = "csv";
bool? result = textDialog.ShowDialog();
if (result == true)
{
System.Text.Encoding ascii = System.Text.Encoding.UTF8;
Encoding enc=Encoding.GetEncoding("cp1251");
string data = ExportExtensions.ToCsv(grid, true);
// data+=@"<script type=""text/javascript"">print();</script>";
data = data.Replace(",", ";");
System.IO.Stream fileStream = textDialog.OpenFile();
byte[] contents = enc.GetBytes(data);
fileStream.Write(contents, 0, contents.Length);
fileStream.Flush();
fileStream.Close();
}
}
but we have no idea how to make export to excel of three-tiered GridView (somthing like this:
<telerikGridView:RadGridView>
<telerikGridView:RadGridView.ChildTableDefinitions>
<telerikGridView:GridViewTableDefinition>
<telerikGridView:GridViewTableDefinition.Relation>
<telerikData:PropertyRelation ParentPropertyName="WorkPlaces" />
</telerikGridView:GridViewTableDefinition.Relation>
</telerikGridView:GridViewTableDefinition>
</telerikGridView:RadGridView.ChildTableDefinitions>
<telerikGridView:RadGridView.HierarchyChildTemplate>
<DataTemplate>
<telerikGridView:RadGridView ItemsSource="{Binding WorkPlaces}" >
<telerikGridView:RadGridView.ChildTableDefinitions>
<telerikGridView:GridViewTableDefinition>
<telerikGridView:GridViewTableDefinition.Relation>
<telerikData:PropertyRelation ParentPropertyName="Licenses" />
</telerikGridView:GridViewTableDefinition.Relation>
</telerikGridView:GridViewTableDefinition>
</telerikGridView:RadGridView.ChildTableDefinitions>
<telerikGridView:RadGridView.HierarchyChildTemplate>
<DataTemplate>
<telerikGridView:RadGridView
ItemsSource="{Binding Licenses}" >
</telerikGridView:RadGridView>
</telerikGridView:RadGridView>
</telerikGridView:RadGridView>
I want to see information of all the Girds in Excel.
How can I make it?