利用NPOI和List泛型导出Excel

具体方法不要看，这里这是一个参考

//弹出表的保存路径

private void Output_Click_1(object sender,RoutedEventArgs e)//导出方式合为一个方法体（强制转换sender）

       {

           if (Grid_Center.ItemsSource != null)

           {

               DevExpress.Xpf.Bars.BarButtonItem s =(DevExpress.Xpf.Bars.BarButtonItem)sender;

                string name = s.Name;

                Microsoft.Win32.SaveFileDialogsave = new Microsoft.Win32.SaveFileDialog();//有没有只取路径的控件？貌似没有

                ActionResult ar = newActionResult(true, "");

                switch (name)

                {

                    case"bbiOutputXls":

                        save.Filter ="*.xls|.xls";

                        save.FileName = "文件名";

                        save.Title ="Export To Excel";

                        break;

                    case"bbiOutputXls_1":

                        save.Filter ="*.xls|.xls";

                        save.FileName = "文件名";

                        save.Title ="Export To Excel";

                        break;

                    case "bbiOutputCsv":

                        save.Filter ="*.csv|.csv";

                        save.FileName = "文件名";

                        save.Title ="Export To Csv";

                        break;

                    default:

                        break;

                }

                bool? result =save.ShowDialog();

                if (result.Value)//点击保存

                {

                    string path =save.FileName;

                    try

                    {

                        switch (name)

                        {

                            case"bbiOutputXls":

                               //DevExpress.XtraPrinting.XlsExportOptions options = newDevExpress.XtraPrinting.XlsExportOptions();

 

                                //GridView_Center.ExportToXls(path,options);

                               ar=OutToExcel(path,1);

                                break;

                            case"bbiOutputXls_1"://导出表

                               ar=OutToExcel(path,2);

                                bre