时间:2011-08-10 20:32
来源:博客园
作者:菊花香
点击: 299 次
目前项目使用第三方空间Telerik RadControls,在数据导出方面提供便利 可以直接使用RadGridView,将GridView中数据导出为需要的格式。 //表格数据导出 private void btn_export_Click( object sender,RoutedEventArgse) { string extension= ; ExportFormatformat=ExportFormat.Html; RadComboBoxItemcomboItem= this .rcb
目前项目使用第三方空间Telerik RadControls,在数据导出方面提供便利
可以直接使用RadGridView,将GridView中数据导出为需要的格式。
//表格数据导出
private void btn_export_Click( object sender, RoutedEventArgs e)
{
string extension = "";
ExportFormat format = ExportFormat.Html;
RadComboBoxItem comboItem = this.rcb_format.SelectedItem as RadComboBoxItem;
string selectedItem = comboItem.Content.ToString();
switch (selectedItem)
{
case "Excel": extension = "xls";
format = ExportFormat.Html;
break;
case "ExcelML": extension = "xml";
format = ExportFormat.ExcelML;
break;
case "Word": extension = "doc";
format = ExportFormat.Html;
break;
case "Csv": extension = "csv";
format = ExportFormat.Csv;
break;
}
SaveFileDialog dialog = new SaveFileDialog();
dialog.DefaultExt = extension;
dialog.Filter = String.Format( "{1} files (*.{0})|*.{0}|All files (*.*)|*.*", extension, selectedItem);
dialog.FilterIndex = 1;
if (dialog.ShowDialog())
{
using (Stream stream = dialog.OpenFile())
{
GridViewExportOptions exportOptions = new GridViewExportOptions();
exportOptions.Format = format;
exportOptions.ShowColumnFooters = true;
exportOptions.ShowColumnHeaders = true;
exportOptions.ShowGroupFooters = true;
this.radgridview.Export(stream, exportOptions);
}
private void btn_export_Click( object sender, RoutedEventArgs e)
{
string extension = "";
ExportFormat format = ExportFormat.Html;
RadComboBoxItem comboItem = this.rcb_format.SelectedItem as RadComboBoxItem;
string selectedItem = comboItem.Content.ToString();
switch (selectedItem)
{
case "Excel": extension = "xls";
format = ExportFormat.Html;
break;
case "ExcelML": extension = "xml";
format = ExportFormat.ExcelML;
break;
case "Word": extension = "doc";
format = ExportFormat.Html;
break;
case "Csv": extension = "csv";
format = ExportFormat.Csv;
break;
}
SaveFileDialog dialog = new SaveFileDialog();
dialog.DefaultExt = extension;
dialog.Filter = String.Format( "{1} files (*.{0})|*.{0}|All files (*.*)|*.*", extension, selectedItem);
dialog.FilterIndex = 1;
if (dialog.ShowDialog())
{
using (Stream stream = dialog.OpenFile())
{
GridViewExportOptions exportOptions = new GridViewExportOptions();
exportOptions.Format = format;
exportOptions.ShowColumnFooters = true;
exportOptions.ShowColumnHeaders = true;
exportOptions.ShowGroupFooters = true;
this.radgridview.Export(stream, exportOptions);
}
本文来自菊花香的博客,原文地址:http://www.cnblogs.com/MR520/archive/2011/08/11/2116086.html