导出一个EXCEL，多个SHEET

Infragistics.Excel.  Workbook  work =  new  Infragistics.Excel. Workbook ();

                        Infragistics.Excel.  Worksheet  sheet1 = work.Worksheets.Add( "sheet2"  );

                        Infragistics.Excel.  Worksheet  sheet2 = work.Worksheets.Add( "sheet1"  );

                         this .ultraGridExcelExporter1.Export(dgdQueryData, sheet1);

                         this .ultraGridExcelExporter1.Export(dgdQueryData, sheet2);

                        Infragistics.Excel. BIFF8Writer  .WriteWorkbookToFile(work, Sfd.FileName);

 

System.Web.HttpUtility.UrlEncode("我是", System.Text.Encoding.Default)

//去除为空的

AND   PATINDEX ( '%[^0-9|.|-|+]%'   , ISNULL (   CONVERT ( VARCHAR   ( 8000 ),   spp2 . OVEN_VALUE   ), spp2 .   VALUE_S ))   =   0

转载于:https://www.cnblogs.com/CharlesGrant/p/3650856.html