正文

导出一个EXCEL，多个SHEET

IP云
IP云V管理员/6 阅读
09/28
提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示
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