WPF DataGrid如何分页、导出Excle、打印（急）

2025-02-15 00:21:16

推荐回答（2个）

回答1：

我用的是sql分页，用静态变量保存当前页数，然后在相应的事件里处理。你能获取你选中的行吧！数据源都获取到了，所以导出Excle跟平时的导入导出没什么分别。

回答2：

Excel的导出一般采取的方式是获取数据源的数据,然后对数据进行处理,形成CAS字符串的形式导出.具体代码(来自网站codeproject,具体可以搜一下,适应与silverlight对wpf大同小异,请适当修改一下!):
using System;
using System.Windows;
using System.Windows.Data;
using System.Windows.Media;
using System.Windows.Controls;
using System.Collections;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using System.Linq;
using System.Text;
using System.IO;
using System.Reflection;
using System.Xml.Linq;

public static class DataGridExtensions
{
public static void Export(this DataGrid dg)
{
ExportDataGrid(dg);
}

public static void ExportDataGrid(DataGrid dGrid)
{
SaveFileDialog objSFD = new SaveFileDialog() { DefaultExt = "csv", Filter = "CSV Files (*.csv)|*.csv|Excel XML (*.xml)|*.xml|All files (*.*)|*.*", FilterIndex = 1 };
if (objSFD.ShowDialog() == true)
{
string strFormat = objSFD.SafeFileName.Substring(objSFD.SafeFileName.IndexOf('.') + 1).ToUpper();
StringBuilder strBuilder = new StringBuilder();
if (dGrid.ItemsSource == null) return;
List lstFields = new List();
if (dGrid.HeadersVisibility == DataGridHeadersVisibility.Column || dGrid.HeadersVisibility == DataGridHeadersVisibility.All)
{
foreach (DataGridColumn dgcol in dGrid.Columns)
lstFields.Add(FormatField(dgcol.Header.ToString(), strFormat));
BuildStringOfRow(strBuilder, lstFields, strFormat);
}
foreach (object data in dGrid.ItemsSource)
{
lstFields.Clear();
foreach (DataGridColumn col in dGrid.Columns)
{
string strValue = "";
Binding objBinding = null;
if (col is DataGridBoundColumn)
objBinding = (col as DataGridBoundColumn).Binding;
if (col is DataGridTemplateColumn)
{
//This is a template column... let us see the underlying dependency object
DependencyObject objDO = (col as DataGridTemplateColumn).CellTemplate.LoadContent();
FrameworkElement oFE = (FrameworkElement)objDO;
FieldInfo oFI = oFE.GetType().GetField("TextProperty");
if (oFI != null)
{
if (oFI.GetValue(null) != null)
{
if (oFE.GetBindingExpression((DependencyProperty)oFI.GetValue(null)) != null)
objBinding = oFE.GetBindingExpression((DependencyProperty)oFI.GetValue(null)).ParentBinding;
}
}
}
if (objBinding != null)
{
if (objBinding.Path.Path != "")
{
PropertyInfo pi = data.GetType().GetProperty(objBinding.Path.Path);
if (pi != null) strValue = pi.GetValue(data, null).ToString();
}
if (objBinding.Converter != null)
{
if (strValue != "")
strValue = objBinding.Converter.Convert(strValue, typeof(string), objBinding.ConverterParameter, objBinding.ConverterCulture).ToString();
else
strValue = objBinding.Converter.Convert(data, typeof(string), objBinding.ConverterParameter, objBinding.ConverterCulture).ToString();
}
}
lstFields.Add(FormatField(strValue,strFormat));
}
BuildStringOfRow(strBuilder, lstFields, strFormat);
}
StreamWriter sw = new StreamWriter(objSFD.OpenFile());
if (strFormat == "XML")
{
//Let us write the headers for the Excel XML
sw.WriteLine("");
sw.WriteLine("");
sw.WriteLine("");
sw.WriteLine("");
sw.WriteLine("Arasu Elango");
sw.WriteLine("" + DateTime.Now.ToLocalTime().ToLongDateString() + "");
sw.WriteLine("" + DateTime.Now.ToLocalTime().ToLongDateString() + "");
sw.WriteLine("Atom8 IT Solutions (P) Ltd.,");
sw.WriteLine("12.00");
sw.WriteLine("");
sw.WriteLine("");
sw.WriteLine("");
}
sw.Write(strBuilder.ToString());
if (strFormat == "XML")
{
sw.WriteLine("
");
sw.WriteLine("");
sw.WriteLine("");
}
sw.Close();
}
}
private static void BuildStringOfRow(StringBuilder strBuilder, List lstFields, string strFormat)
{
switch (strFormat)
{
case "XML":
strBuilder.AppendLine("");
strBuilder.AppendLine(String.Join("\r\n", lstFields.ToArray()));
strBuilder.AppendLine("");
break;
case "CSV":
strBuilder.AppendLine(String.Join(",", lstFields.ToArray()));
break;
}
}
private static string FormatField(string data, string format)
{
switch (format)
{
case "XML":
return String.Format("{0}", data);
case "CSV":
return String.Format("\"{0}\"", data.Replace("\"", "\"\"\"").Replace("\n", "").Replace("\r", ""));
}
return data;
}
}

在网上买东西，但是我这边地址不详细我怕快递寄不到？怎么办？

男人的衣服、鞋子该买贵的还是买便宜的？

QQ里，别人发的说说，我点了赞，可过几个小时点赞的那个有变成原来的，就像没点赞一样，是怎么回事？

小升初考试最容易考到的作文题目是什么呢？急求！！！

头发干燥又蓬松怎么办拉直吗

怎么样让男生的头发松动动点？

好的不同意思心情好（）态度好（）天气好（）身体好（）急需

我家狗狗丢失被人捡到不归还，现在狗狗在他家又丢了，还要两条苏烟440块才给，算敲诈吗

有类似《赤裸特工》的电影吗，介绍介绍！