/// <summary>
/// 扩展标题头样式
/// </summary>
/// <param name="workbook"></param>
/// <param name="propertyName"></param>
/// <returns></returns>
protected virtual ICellStyle SetHeaderStyle(HSSFWorkbook workbook, PropertyInfo propertyInfo)
{
if (propertyInfo.Name.Contains("DataContent"))
{
return(ExcelStyle.HeaderLeftStyle(workbook)); //设置居左
}
return(ExcelStyle.HeaderStyle(workbook)); //设置Header剧中
}
/// <summary>
/// 设定某一列的样式
/// </summary>
/// <param name="workbook"></param>
/// <param name="propertyName"></param>
/// <param name="cdrRowStyle">如果设置了行样式，列的样式设置会被覆盖，仅返回行样式</param>
/// <returns></returns>
private ICellStyle SetCdrCellStyle(HSSFWorkbook workbook, PropertyInfo propertyInfo, T dbModel, ICellStyle cdrRowStyle)
{
if (cdrRowStyle != null)
{
return(cdrRowStyle);
}
return(ExcelStyle.CenterStyle(workbook));
}
private ISheet CreateSheet(HSSFWorkbook workbook, int sheetCount, int sheetIdx, string title, out int occupancyRows)
{
ExcelStyle.InitSheetStyle();
occupancyRows = 0;
ISheet sheet = workbook.CreateSheet("Sheet" + sheetIdx);
string strTitle = title + (sheetCount == 1 ? "" : " (" + sheetIdx + ")");
sheet = ExcelStyle.SetSheeetParams(sheet);
occupancyRows = CreateSheetTitle(workbook, sheet, strTitle, occupancyRows);
occupancyRows = CreateSheetHeads(workbook, sheet, occupancyRows);
return(sheet);
}
private int CreateSheetTitle(HSSFWorkbook workbook, ISheet sheet, string title, int titleOccupancyRows)
{
IRow row = sheet.CreateRow(titleOccupancyRows);
row.HeightInPoints = 25;
ICell cell = row.CreateCell(0);
cell.CellStyle = ExcelStyle.GetStyleTitle(workbook);
cell.SetCellValue(title);
sheet.AddMergedRegion(new CellRangeAddress(0, 0, 0, ExportCellHeadList.Count - 1));
titleOccupancyRows++;
return(titleOccupancyRows);
}
public ExportExcelService()
{
this.ExcelStyle = new ExcelStyle();
typeMapper = new TypeMapper <ExcelInfo>();
}
