关于datagrid导出excle没有表头的问题

收藏

是用datagrid做导出表格功能，但是表格为多维表头的时候，表头无法导出
例如
前台

<c1datagrid:C1DataGrid.Columns>
<c1datagrid:DataGridTextColumn Header="[定点名称]" Binding="{Binding NAME}" />
<c1datagrid:DataGridNumericColumn Header="[统筹基金（含基本大额）支出预算,全年总预算]" Binding="{Binding aa}" />
<c1datagrid:DataGridNumericColumn Header="[统筹基金（含基本大额）支出预算,当期基本统筹实际支出]" Binding="{Binding bb}" />
<c1datagrid:C1DataGrid.Columns/>
<c1datagrid:C1DataGrid.TopRows>
<c1datagrid:DataGridColumnHeaderRow />
<c1datagrid:DataGridColumnHeaderRow />
</c1datagrid:C1DataGrid.TopRows>

复制代码

后台

public void ExpExcel(C1DataGrid grid,string fileName)
{
var options = new ExcelSaveOptions()
{
FileFormat = ExcelFileFormat.Xlsx,
KeepColumnWidths = true,
KeepRowHeights = true
};
var excelExt = options.FileFormat.ToString();
var dialog = new System.Windows.Controls.SaveFileDialog()
{
DefaultExt = "*." + excelExt,
DefaultFileName = fileName+"_"+DateTime.Now.ToString("yyyyMMdd"),
Filter = "Excel " + excelExt + " (*." + excelExt + ")|*." + excelExt + "|All files (*.*)|*.*",
};
if (dialog.ShowDialog() == false) return;
using (var stream = dialog.OpenFile())
{
grid.Save(stream, options);
}
}

复制代码

但是导出没有表头需要如何解决？
还有个问题这几个属性是做什么用的，是否能有详细的说明文档提供呢？
CollapsibleGroups
CollapsedGroupLevel
CollapseGroupsBelowDetail

gw0506 · gw0506

你用的是WPF的还是Silverlight的？

jim_hujun · jim_hujun

回复 2楼gw0506的帖子

Silverlight的

iceman · iceman

回复 1楼jim_hujun的帖子

1.请参考随机安装 Demo C1DataGrid_Demo2010.5/Merging/HeadersMerging_SL5.xaml 导出多表头。

2.CollapsibleGroups、CollapsedGroupLevel、CollapseGroupsBelowDetail 这几个属性用于设置分组的折叠信息，可以参考在线帮助文档：
http://helpcentral.componentone.com/nethelp/c1datagridsl/

jim_hujun · jim_hujun

回复 4楼iceman的帖子

不知道你是如何实现的我在headersMerging里修改加入导出功能，一样无法导出表头
导出结果如下图

我修改了
Demo C1DataGrid_Demo2010.5/Merging/HeadersMerging_SL5.xaml 和 CS 麻烦你看看

<?xml version="1.0" encoding="utf-8"?>
<UserControl x:Class="C1DataGrid_Demo2010.HeadersMerging"
mc:Ignorable="d"
d:DesignHeight="300"
d:DesignWidth="400"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
xmlns:c1datagrid="clr-namespace:C1.Silverlight.DataGrid;assembly=C1.Silverlight.DataGrid.5"
xmlns:c1="http://schemas.componentone.com/winfx/2006/xaml"
xmlns:local="clr-namespace:C1DataGrid_Demo2010">
<!--
// **********************************************************************************
// Header merging is made by:
// - disabling standard headers (HeadersVisibility=None)
// - adding custom rows/columns for the headers that look and behave like headers
// - standard content cell merging
// **********************************************************************************
-->
<Grid x:Name="LayoutRoot">
<Grid.RowDefinitions>
<RowDefinition Height="Auto" />
<RowDefinition Height="*" />
</Grid.RowDefinitions>
<c1:C1Toolbar c1:C1NagScreen.Nag="True">
<c1:C1ToolbarGroup Header="File Export">
<c1:C1ToolbarStrip>
<c1:C1ToolbarButton x:Name="btnExcel" Click="btnExcel_Click">
<StackPanel Orientation="Horizontal" Margin="4">
<Image Source="/C1DataGrid_Demo2010.5;component/Resources/docexcel.png" />
<TextBlock Text="Excel" VerticalAlignment="Center" Margin="3 0 0 0" />
</StackPanel>
</c1:C1ToolbarButton>
<c1:C1ToolbarButton x:Name="btnPdf" c1:C1NagScreen.Nag="True" >
<StackPanel Orientation="Horizontal" Margin="4">
<Image Source="/C1DataGrid_Demo2010.5;component/Resources/pdf.png" />
<TextBlock Text="Pdf" VerticalAlignment="Center" Margin="3 0 0 0" />
</StackPanel>
</c1:C1ToolbarButton>
<c1:C1ToolbarButton x:Name="btnHtml" c1:C1NagScreen.Nag="True" >
<StackPanel Orientation="Horizontal" Margin="4">
<Image Source="/C1DataGrid_Demo2010.5;component/Resources/html.png" />
<TextBlock Text="Html" VerticalAlignment="Center" Margin="3 0 0 0" />
</StackPanel>
</c1:C1ToolbarButton>
</c1:C1ToolbarStrip>
</c1:C1ToolbarGroup>
<c1:C1ToolbarGroup Header="Printing">
<c1:C1ToolbarStrip>
<c1:C1ToolbarDropDown x:Name="btnHtmlFile">
<c1:C1ToolbarDropDown.Header>
<StackPanel Orientation="Horizontal" Margin="4">
<Image Source="/C1DataGrid_Demo2010.5;component/Resources/print.png" />
<TextBlock Text="Print" VerticalAlignment="Center" Margin="3 0 0 0" />
</StackPanel>
</c1:C1ToolbarDropDown.Header>
<c1:C1ToolbarDropDown.Menu>
<c1:C1ContextMenu>
<c1:C1MenuItem Header="Actual Size..." Tag="ActualSize" c1:C1NagScreen.Nag="True" >
</c1:C1MenuItem>
<c1:C1MenuItem Header="Fit to Page Width..." Tag="PageWidth" c1:C1NagScreen.Nag="True">
</c1:C1MenuItem>
<c1:C1MenuItem Header="Fit to Single Page..." Tag="SinglePage" c1:C1NagScreen.Nag="True">
</c1:C1MenuItem>
</c1:C1ContextMenu>
</c1:C1ToolbarDropDown.Menu>
</c1:C1ToolbarDropDown>
</c1:C1ToolbarStrip>
</c1:C1ToolbarGroup>
<c1:C1ToolbarGroup Header="Clipboard">
<c1:C1ToolbarStrip Overflow="None">
<StackPanel>
<TextBlock Text="Select the cells, Ctrl+C to copy to the Clipboard," FontSize="10" />
<TextBlock Text="Ctrl+V to paste into Excel." FontSize="10" />
</StackPanel>
</c1:C1ToolbarStrip>
</c1:C1ToolbarGroup>
</c1:C1Toolbar>
<c1datagrid:C1DataGrid x:Name="grid" Grid.Row="1" HeadersVisibility="None" AutoGenerateColumns="False" SelectionMode="MultiRange" CanUserAddRows="False" AlternatingRowBackground="White" RowBackground="White" GridLinesVisibility="All" CanUserFreezeColumns="Left" FrozenTopRowsCount="2" FrozenColumnCount="2">
<c1datagrid:C1DataGrid.Columns>
<c1datagrid:DataGridRowHeaderColumn Header="[Country, Continent]" Binding="{Binding Continent}" />
<c1datagrid:DataGridRowHeaderColumn Header="[Country, Name]" Binding="{Binding Country}" />
<c1datagrid:DataGridTextColumn Header="[Final, Champion]" Binding="{Binding First}" />
<c1datagrid:DataGridTextColumn Header="[Final, Runner-up]" Binding="{Binding Second}" />
<c1datagrid:DataGridTextColumn Header="[Semi-Finals, Third]" Binding="{Binding Third}" />
<c1datagrid:DataGridTextColumn Header="[Semi-Finals, Fourth]" Binding="{Binding Fourth}" />
</c1datagrid:C1DataGrid.Columns>
<c1datagrid:C1DataGrid.TopRows>
<c1datagrid:DataGridColumnHeaderRow />
<c1datagrid:DataGridColumnHeaderRow />
</c1datagrid:C1DataGrid.TopRows>
</c1datagrid:C1DataGrid>
</Grid>
</UserControl>

复制代码

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------华丽的分割线--------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
CS文件

using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Animation;
using System.Windows.Shapes;
using C1.Silverlight.DataGrid;
using C1.Silverlight.Data;
using System.Windows.Data;
using C1.Silverlight.DataGrid.Excel;
namespace C1DataGrid_Demo2010
{
public partial class HeadersMerging : UserControl
{
DataGridColumn[] _headerRowColumns;
DataGridRow[] _headerColumnRows;
public HeadersMerging()
{
InitializeComponent();
// save headers rows and columns for later
_headerRowColumns = grid.Columns.Take(2).ToArray();
_headerColumnRows = grid.TopRows.Take(2).ToArray();
// forbid unfreezing headers
grid.FrozenColumnCountChanged += delegate
{
if (grid.FrozenColumnCount < _headerRowColumns.Length)
grid.FrozenColumnCount = _headerRowColumns.Length;
};
// handle merging when view port changes
grid.MergingCells += new EventHandler<DataGridMergingCellsEventArgs>(grid_MergingCells);
#region ** Initialize data
List<WordCupEntry> entries = new List<WordCupEntry>();
entries.Add(new WordCupEntry() { Continent = "South America", Country = "Brazil", First = "5 (1958, 1962, 1970, 1994, 2002)", Second = "2 (1950*, 1998)", Third = "2 (1938, 1978)", Fourth = "1 (1974)" });
entries.Add(new WordCupEntry() { Continent = "Europe", Country = "Italy", First = "4 (1934*, 1938, 1982, 2006)", Second = "2 (1970, 1994)", Third = "1 (1990*)", Fourth = "1 (1978)" });
entries.Add(new WordCupEntry() { Continent = "Europe", Country = "Germany", First = "3 (1954, 1974*, 1990)", Second = "4 (1966, 1982, 1986, 2002)", Third = "4 (1934, 1970, 2006*, 2010)", Fourth = "1 (1958)" });
entries.Add(new WordCupEntry() { Continent = "South America", Country = "Argentina", First = "2 (1978*, 1986)", Second = "2 (1930, 1990)", Third = "-", Fourth = "-" });
entries.Add(new WordCupEntry() { Continent = "South America", Country = "Uruguay", First = "2 (1930*, 1950)", Second = "-", Third = "-", Fourth = "3 (1954, 1970, 2010)" });
entries.Add(new WordCupEntry() { Continent = "Europe", Country = "France", First = "1 (1998*)", Second = "1 (2006)", Third = "2 (1958, 1986)", Fourth = "1 (1982)" });
entries.Add(new WordCupEntry() { Continent = "Europe", Country = "England", First = "1 (1966*)", Second = "-", Third = "-", Fourth = "1 (1990)" });
entries.Add(new WordCupEntry() { Continent = "Europe", Country = "Spain", First = "1 (2010)", Second = "-", Third = "-", Fourth = "1 (1950)" });
entries.Add(new WordCupEntry() { Continent = "Europe", Country = "Netherlands", First = "-", Second = "3 (1974, 1978, 2010)", Third = "-", Fourth = "1 (1998)" });
entries.Add(new WordCupEntry() { Continent = "Europe", Country = "Czechoslovakia", First = "-", Second = "2 (1934, 1962)", Third = "-", Fourth = "-" });
entries.Add(new WordCupEntry() { Continent = "Europe", Country = "Hungary", First = "-", Second = "2 (1938, 1954)", Third = "-", Fourth = "-" });
entries.Add(new WordCupEntry() { Continent = "Europe", Country = "Sweden", First = "-", Second = "1 (1958*)", Third = "2 (1950, 1994)", Fourth = "1 (1938)" });
#endregion
grid.ItemsSource = entries;
}
private void btnExcel_Click(object sender, RoutedEventArgs e)
{
var options = new ExcelSaveOptions()
{
FileFormat = ExcelFileFormat.Xlsx, // change this to offer a different Excel format
KeepColumnWidths = true,
KeepRowHeights = true
};
var excelExt = options.FileFormat.ToString();
var dialog = new System.Windows.Controls.SaveFileDialog()
{
DefaultExt = "*." + excelExt,
Filter = "Excel " + excelExt + " (*." + excelExt + ")|*." + excelExt + "|All files (*.*)|*.*",
};
if (dialog.ShowDialog() == false) return;
using (var stream = dialog.OpenFile())
{
grid.Save(stream, options);
}
}
void grid_MergingCells(object sender, DataGridMergingCellsEventArgs e)
{
// view port columns & rows without headers
var nonHeadersViewportCols = grid.Viewport.Columns.Where(c => !_headerRowColumns.Contains(c)).ToArray();
var nonHeadersViewportRows = grid.Viewport.Rows.Where(r => !_headerColumnRows.Contains(r)).ToArray();
// merge column & rows headers
foreach (var range in MergingHelper.Merge(Orientation.Vertical, _headerColumnRows, nonHeadersViewportCols, true))
{
e.Merge(range);
}
foreach (var range in MergingHelper.Merge(Orientation.Horizontal, nonHeadersViewportRows, _headerRowColumns, true))
{
e.Merge(range);
}
// merge header intersection as we want, in this case, horizontally
foreach (var range in MergingHelper.Merge(Orientation.Horizontal, _headerColumnRows, _headerRowColumns, true))
{
e.Merge(range);
}
// merge content
foreach (var range in MergingHelper.Merge(Orientation.Vertical, nonHeadersViewportRows, nonHeadersViewportCols, false))
{
e.Merge(range);
}
}
}
public class WordCupEntry
{
public string Continent { get; set; }
public string Country { get; set; }
public string First { get; set; }
public string Second { get; set; }
public string Third { get; set; }
public string Fourth { get; set; }
}
}

复制代码

iceman · iceman

回复 5楼jim_hujun的帖子

jim_hujun 你好，

我使用 2013V1 版重现了这个问题。我会把该问题反馈给产品组。

由于时差和问题处理先后顺序原因，要下周回复。
收到反馈后我会及时更新帖子状态。

谢谢

jim_hujun · jim_hujun

回复 6楼iceman的帖子

好的非常感谢有反馈请及时给我邮件：）

iceman · iceman

收到回复后，我会更新论坛帖子。请及时关注。

iceman · iceman

回复 7楼jim_hujun的帖子

你好，

C1FlexGrid 可以导出多表头到Excel 。附加是 Demo 请参考。包括多表头和导出多表头。

谢谢

jim_hujun · jim_hujun

回复 9楼iceman的帖子

你好本地做了测试可以倒出表头，但是格式不对，需要合并的单元格没有合并

		自动登录	找回密码
密码			立即注册

[已处理] 关于datagrid导出excle没有表头的问题

16 个回复

本帖子中包含更多资源

本帖子中包含更多资源

活字格认证

微信认证勋章

元老葡萄