public void Export(string businessDate, string exportFilePath) { System.Data.DataSet ds = GetByBusinessDate(businessDate); System.Data.DataTable dt1 = ds.Tables[0]; System.Data.DataTable dt2 = ds.Tables[1]; string[,] arrayExport1 = Tools.DataTableToArray(dt1, false); string[,] arrayExport2 = Tools.DataTableToArray(dt2, false); using (ExcelProcess excelProcess = new ExcelProcess(exportFilePath)) { Worksheet sheet1 = excelProcess.GetSheet(1); sheet1.Activate(); excelProcess.CopyRowInsert(sheet1, 2, 3, arrayExport1.GetLength(0) + 1); Range range1 = excelProcess.GetRange(sheet1, 2, 1, arrayExport1.GetLength(0) + 1, arrayExport1.GetLength(1)); range1.Value2 = arrayExport1; range1.Value2 = range1.Value2; Worksheet sheet2 = excelProcess.GetSheet(2); sheet2.Activate(); excelProcess.CopyRowInsert(sheet2, 2, 3, arrayExport2.GetLength(0) + 1); Range range2 = excelProcess.GetRange(sheet2, 2, 1, arrayExport2.GetLength(0) + 1, arrayExport2.GetLength(1)); range2.Value2 = arrayExport2; range2.Value2 = range2.Value2; excelProcess.Save(); } }
public void Export(string businessDate, string exportFilePath) { System.Data.DataTable dt = GetByBusinessDate(businessDate); string[,] arrayExport = Tools.DataTableToArray(dt, false); using (ExcelProcess excelProcess = new ExcelProcess(exportFilePath)) { Worksheet sheet = excelProcess.GetSheet(1); excelProcess.CopyRowInsert(sheet, 2, 3, 1 + arrayExport.GetLength(0)); Range range = excelProcess.GetRange(sheet, 2, 1, 1 + arrayExport.GetLength(0), 5); range.Value2 = arrayExport; range.Value2 = range.Value2; excelProcess.Save(); } }
public string Export(string businessDateStart, string businessDateEnd, byte businessType, string businessTypeValue, string exportFilePath) { System.Data.DataTable dt = GetAllByBusinessType(businessDateStart, businessDateEnd, businessType, businessTypeValue); string[,] arrayExport = Tools.DataTableToArray(dt, true); if (businessDateStart == businessDateEnd) { using (ExcelProcess excelProcess = new ExcelProcess(exportFilePath)) { Worksheet sheet = excelProcess.GetSheet(1); Range range = excelProcess.GetRange(sheet, 1, 1, arrayExport.GetLength(0), arrayExport.GetLength(1)); range.Value2 = arrayExport; range.Value2 = range.Value2; excelProcess.Save(); } } else { int fixedColumnCount = 4; using (ExcelProcess excelProcess = new ExcelProcess(exportFilePath)) { Worksheet sheet = excelProcess.GetSheet(1); Range range = excelProcess.GetRange(sheet, 1, 1, arrayExport.GetLength(0), arrayExport.GetLength(1)); range.Value2 = arrayExport; range.Value2 = range.Value2; excelProcess.CopyRowInsert(sheet, 1, 2, 2); excelProcess.GetRange(sheet, 1, 1, 2, 1).Merge(); excelProcess.GetRange(sheet, 1, 2, 2, 2).Merge(); excelProcess.GetRange(sheet, 1, 3, 2, 3).Merge(); excelProcess.GetRange(sheet, 1, 4, 2, 4).Merge(); for (int colIndex = 0; colIndex < arrayExport.GetLength(1) - fixedColumnCount; colIndex++) { excelProcess.SetCells(sheet, 1, colIndex + fixedColumnCount + 1, "金额"); } excelProcess.GetRange(sheet, 1, fixedColumnCount + 1, 1, arrayExport.GetLength(1)).Merge(); excelProcess.Save(); } }//end else (businessDateStart != businessDateEnd) string businessTypeName = string.Empty; switch (businessType) { case (byte)SynthesizeAnalyBusinessType.VoiceClass: { businessTypeName = "语单类"; break; } case (byte)SynthesizeAnalyBusinessType.DreamClass: { businessTypeName = "梦网类"; break; } case (byte)SynthesizeAnalyBusinessType.DataClass: { businessTypeName = "数据类"; break; } case (byte)SynthesizeAnalyBusinessType.GroupClass: { businessTypeName = "集团类"; break; } } string saveFileName = string.Empty; if (businessDateStart != businessDateEnd) { saveFileName = string.Format("{0}-{1}无主{2}.xls", businessDateStart, businessDateEnd, businessTypeName); } else { saveFileName = string.Format("{0}无主{1}.xls", businessDateStart, businessTypeName); } return saveFileName; }
public void Export(string businessDate, string exportFilePath) { DataSet ds = GetByBusinessDate(businessDate); System.Data.DataTable dt1 = ds.Tables[0]; System.Data.DataTable dt2 = ds.Tables[1]; System.Data.DataTable dt3 = ds.Tables[2]; System.Data.DataTable dt4 = ds.Tables[3]; System.Data.DataTable dt5 = ds.Tables[4]; System.Data.DataTable dt6 = ds.Tables[5]; string[,] arrayExport1 = Tools.DataTableToArray(dt1, false); string[,] arrayExport2 = Tools.DataTableToArray(dt2, false); string[,] arrayExport3 = Tools.DataTableToArray(dt3, false); string[,] arrayExport4 = Tools.DataTableToArray(dt4, false); string[,] arrayExport5 = Tools.DataTableToArray(dt5, false); string[,] arrayExport6 = Tools.DataTableToArray(dt6, false); using (ExcelProcess excelProcess = new ExcelProcess(exportFilePath)) { Worksheet sheet1 = excelProcess.GetSheet(1); sheet1.Activate(); excelProcess.CopyRowInsert(sheet1, 2, 3, arrayExport1.GetLength(0) + 1); Range range1 = excelProcess.GetRange(sheet1, 2, 1, arrayExport1.GetLength(0) + 1, arrayExport1.GetLength(1)); range1.Value2 = arrayExport1; range1.Value2 = range1.Value2; Worksheet sheet2 = excelProcess.GetSheet(2); sheet2.Activate(); excelProcess.CopyRowInsert(sheet2, 2, 3, arrayExport2.GetLength(0) + 1); Range range2 = excelProcess.GetRange(sheet2, 2, 1, arrayExport2.GetLength(0) + 1, arrayExport2.GetLength(1)); range2.Value2 = arrayExport2; range2.Value2 = range2.Value2; Worksheet sheet3 = excelProcess.GetSheet(3); sheet3.Activate(); excelProcess.CopyRowInsert(sheet3, 2, 3, arrayExport3.GetLength(0) + 1); Range range3 = excelProcess.GetRange(sheet3, 2, 1, arrayExport3.GetLength(0) + 1, arrayExport3.GetLength(1)); range3.Value2 = arrayExport3; range3.Value2 = range3.Value2; Worksheet sheet4 = excelProcess.GetSheet(4); sheet4.Activate(); excelProcess.CopyRowInsert(sheet4, 2, 3, arrayExport4.GetLength(0) + 1); Range range4 = excelProcess.GetRange(sheet4, 2, 1, arrayExport4.GetLength(0) + 1, arrayExport4.GetLength(1)); range4.Value2 = arrayExport4; range4.Value2 = range4.Value2; Worksheet sheet5 = excelProcess.GetSheet(5); sheet5.Activate(); excelProcess.CopyRowInsert(sheet5, 2, 3, arrayExport5.GetLength(0) + 1); Range range5 = excelProcess.GetRange(sheet5, 2, 1, arrayExport5.GetLength(0) + 1, arrayExport5.GetLength(1)); range5.Value2 = arrayExport5; range5.Value2 = range5.Value2; Worksheet sheet6 = excelProcess.GetSheet(6); sheet6.Activate(); excelProcess.CopyRowInsert(sheet6, 2, 3, arrayExport6.GetLength(0) + 1); Range range6 = excelProcess.GetRange(sheet6, 2, 1, arrayExport6.GetLength(0) + 1, arrayExport6.GetLength(1)); range6.Value2 = arrayExport6; range6.Value2 = range6.Value2; excelProcess.Save(); } }