/// <summary> /// 将数据导入到Excel /// </summary> public static void ExportExcel(string excelPath, IList <Hashtable> list, string sheetName, string[] strValue) { Workbook wb = new Workbook(); wb.Worksheets.Add(sheetName); WindowOptions options = wb.WindowOptions; Worksheet ws = options.SelectedWorksheet; //设置标题的格式 IWorksheetCellFormat cellFormatHead = wb.CreateNewWorksheetCellFormat(); cellFormatHead.Alignment = HorizontalCellAlignment.Center; cellFormatHead.BottomBorderStyle = CellBorderLineStyle.Thin; cellFormatHead.LeftBorderStyle = CellBorderLineStyle.Thin; cellFormatHead.RightBorderStyle = CellBorderLineStyle.Thin; cellFormatHead.TopBorderStyle = CellBorderLineStyle.Thin; cellFormatHead.Font.Bold = ExcelDefaultableBoolean.True; cellFormatHead.Font.Name = "Calibri"; cellFormatHead.Font.Height = 220; ws.Rows[0].CellFormat.SetFormatting(cellFormatHead); //设置数据行的格式 IWorksheetCellFormat cellFormatContent = wb.CreateNewWorksheetCellFormat(); cellFormatContent.Alignment = HorizontalCellAlignment.Left; cellFormatContent.BottomBorderStyle = CellBorderLineStyle.Thin; cellFormatContent.LeftBorderStyle = CellBorderLineStyle.Thin; cellFormatContent.RightBorderStyle = CellBorderLineStyle.Thin; cellFormatContent.TopBorderStyle = CellBorderLineStyle.Thin; cellFormatContent.Font.Name = "Calibri"; cellFormatContent.Font.Height = 220; //添加标题行 //Hashtable headHashTable = list[0]; int i = 0; foreach (string headValue in strValue) { ws.Rows[0].Cells[i].Value = headValue; ws.Columns[i].Width = 5000; i++; } //添加数据行 for (int k = 0; k < list.Count; k++) { Hashtable dataHashTable = list[k]; int j = 0; foreach (string dataValue in strValue) { ws.Rows[k + 1].Cells[j].Value = dataHashTable[dataValue]; ws.Rows[k + 1].Cells[j].CellFormat.SetFormatting(cellFormatContent); j++; } } wb.Save(excelPath); }