Silverlight导出excel的另一种方式

说明：这个方法是从网上找到的，但是原来的方法没有考虑到绑定的字段是“自定义类型属性的属性” 以及更深(我在说啥呢。。)。我动了一些手脚完善了一点。

　　备注1：还有就是找不到原来的网址了。。

　　备注2：我先在微软战车上的做了留底。

　　两个方法(做成扩展方法，调用方便)

public  static  string ExportDataGrid( this DataGrid grid,  bool withHeaders)
        {
             string colPath;
            System.Reflection.PropertyInfo propInfo;
            System.Windows.Data.Binding binding;
            System.Text.StringBuilder strBuilder =  new System.Text.StringBuilder();
            System.Collections.IList source = (grid.ItemsSource  as System.Collections.IList);
             if (source ==  null)
                 return  "";

            List< string> 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( "\t\n");

             foreach (Object data  in source)
            {
                List< string> csvRow =  new List< string>();
                 foreach (DataGridColumn col  in grid.Columns)
                {
                     if (col  is DataGridBoundColumn)
                    {
                        binding = (col  as DataGridBoundColumn).Binding;
                        colPath = binding.Path.Path;
                         string[] pathlist = colPath.Split('.'); //此处往下做了修改

                         object currentData = data;
                         int count = 0;
                         foreach ( string item  in pathlist)
                        {
                            propInfo = currentData.GetType().GetProperty(item);
                             if (propInfo ==  null)  break;
                            count++;
                             if (count == pathlist.Count())
                            {
                                csvRow.Add(FormatCSVField(propInfo.GetValue(currentData,  null).GetTrimString()));
                                 break;
                            }
                             else
                            {
                                currentData = propInfo.GetValue(currentData,  null);
                            }

                        }

                    }
                }
                strBuilder
                    .Append( String.Join( "", csvRow.ToArray()))
                    .Append( "\t\n");
            }


             return strBuilder.ToString();
        }


private  static  string FormatCSVField( string data)
        {
             //return String.Format("\"{0}\"", data.Replace("\"", "\"\"\"").Replace("\n", "").Replace("\r", ""));
             return  String.Format( "\t{0}", data.Replace( "\"",  "\t\n"));
        }

 

　　使用示范：

void btnExcelExport_Click( object sender, RoutedEventArgs e)
        {
             string data = gridOrderList.ExportDataGrid( true); //调用函数
             byte[] tmp;
            tmp = Encoding.Unicode.GetBytes(data);
            SaveFileDialog sfd =  new SaveFileDialog()
            {
                DefaultExt =  "csv",
                Filter =  "CSV Files (*.csv)|*.csv|All files (*.*)|*.*",
                FilterIndex = 1
            };
             if (sfd.ShowDialog() ==  true)
            {
                 using (System.IO.Stream stream = sfd.OpenFile())
                {
                     using (System.IO.StreamWriter writer =  new System.IO.StreamWriter(stream, Encoding.Unicode, 30))
                    {
                        writer.Write(data);
                        writer.Close();
                    }
                    stream.Close();


                }
            }
        }

本文来自往事如锋的博客，原文地址:http://www.cnblogs.com/xtechnet/archive/2011/05/28/silverlightToExcel.html