silverlight 导出DataGrid 数据到Excel

转自 http://hi.baidu.com/freesunshine/blog/item/90150d738d0aab138601b082.html 

并修改

 

 

     

代码

#region
/// <summary>
/// CSV格式化
/// </summary>
/// <param name="data"> 数据 </param>
/// <returns> 格式化数据 </returns>
private static string FormatCsvField( string data)
{
return String.Format( " \ " { 0 }\ "" , data.Replace( " \ "" , " \ " \ " \ "" ).Replace( " \n " , "" ).Replace( " \r " , "" ));
}

/// <summary>
/// 导出DataGrid数据到Excel
/// </summary>
/// <param name="withHeaders"> 是否需要表头 </param>
/// <param name="grid"> DataGrid </param>
/// <returns> Excel内容字符串 </returns>
public static string ExportDataGrid( bool withHeaders, DataGrid grid)
{
System.Reflection.PropertyInfo propInfo;
System.Windows.Data.Binding binding;
var strBuilder = new System.Text.StringBuilder();
var source = (grid.ItemsSource as System.Collections.IList);
if (source == null ) return "" ;
var headers = new List < string > ();
grid.Columns.ToList().ForEach(col =>
{
if (col is DataGridBoundColumn)
{ headers.Add(FormatCsvField(col.Header.ToString())); }
});
strBuilder.Append(String.Join( " , " , headers.ToArray())).Append( " \r\n " );
foreach (Object data in source)
{
var csvRow = new List < string > ();
foreach (DataGridColumn col in grid.Columns)
{
if (col is DataGridBoundColumn)
{
binding = (col as DataGridBoundColumn).Binding;
string colPath = binding.Path.Path;
propInfo = data.GetType().GetProperty(colPath);
if (propInfo != null )
{
csvRow.Add(FormatCsvField(propInfo.GetValue(data, null ).ToString()));
}
}
}
strBuilder.Append(String.Join( " , " , csvRow.ToArray())).Append( " \r\n " );
}
return strBuilder.ToString();
}

/// <summary>
/// 导出DataGrid数据到Excel
/// </summary>
/// <param name="withHeaders"> 是否需要表头 </param>
/// <param name="grid"> DataGrid </param>
/// <param name="dataBind"></param>
/// <returns> Excel内容字符串 </returns>
public static string ExportDataGrid( bool withHeaders, DataGrid grid, bool dataBind)
{
var strBuilder = new System.Text.StringBuilder();
var source = (grid.ItemsSource as System.Collections.IList);
if (source == null ) return "" ;
var headers = new List < string > ();
grid.Columns.ToList().ForEach(col =>
{
if (col is DataGridTemplateColumn)
{
headers.Add(col.Header != null ? FormatCsvField(col.Header.ToString()) : string .Empty);
}
});
strBuilder.Append(String.Join( " , " , headers.ToArray())).Append( " \r\n " );
foreach (Object data in source)
{
var csvRow = new List < string > ();
foreach (DataGridColumn col in grid.Columns)
{
if (col is DataGridTemplateColumn)
{
FrameworkElement cellContent = col.GetCellContent(data);
TextBlock block;
if (cellContent.GetType() == typeof (Grid))
{
block = cellContent.FindName( " TempTextblock " ) as TextBlock;
}
else
{
block = cellContent as TextBlock;
}
if (block != null )
{
csvRow.Add(FormatCsvField(block.Text));
}
}
}
strBuilder.Append(String.Join( " , " , csvRow.ToArray())).Append( " \r\n " );
// strBuilder.Append(String.Join(",", csvRow.ToArray())).Append("\t");
}
return strBuilder.ToString();
}
/// <summary>
/// 导出DataGrid数据到Excel为CVS文件
/// 使用utf8编码 中文是乱码 改用Unicode编码
///
/// </summary>
/// <param name="withHeaders"> 是否带列头 </param>
/// <param name="grid"> DataGrid </param>
public static void ExportDataGridSaveAs( bool withHeaders, DataGrid grid)
{
string data = ExportDataGrid( true , grid);
var sfd = new SaveFileDialog
{
DefaultExt = " csv " ,
Filter = " CSV Files (*.csv)|*.csv|All files (*.*)|*.* " ,
FilterIndex = 1
};
if (sfd.ShowDialog() == true )
{
using (Stream stream = sfd.OpenFile())
{
using (var writer = new StreamWriter(stream, System.Text.Encoding.Unicode))
{
data = data.Replace( " , " , " \t " );
writer.Write(data);
writer.Close();
}
stream.Close();
}
}
}

#endregion 导出DataGrid数据到Excel

 

转载于:https://www.cnblogs.com/hl3292/archive/2010/11/15/1877612.html