private void Insert1Row(IWorkbook curWorkBook, ISheet curSheet) { //设置合并列 ExcelWriteClass.MergedCell(curSheet, 0, 0, 2, 9); IRow row0 = curSheet.CreateRow(0); row0.Height = 1000; CellStyleConfig curStyle = new CellStyleConfig(); curStyle.FontName = "Dialog"; curStyle.FontSize = 7; curStyle.BoldWeight = 800; curStyle.curCellValueFormatStyle = CellValueFormatStyle.头; curStyle.curBorderLineColorIndex = HSSFColor.OliveGreen.White.Index; curStyle.curVerAlign = VerticalAlignment.Center; curStyle.AutoWrap = true; ICellStyle curCellStyle = ExcelWriteClass.GetCellStyle(curWorkBook, curStyle); SetRowsStyle(curSheet, row0, curCellStyle); string Str = @"CHINA PETROLEUM & CHEMICAL CORPORATION THE ESTIMATE OF RESERVES AND FUTURE INCOME ATTRIBUTABLE TO CERTAIN INTERESTS"; row0.Cells[2].SetCellValue(Str); }
static ICellStyle Getcellstyle(IWorkbook wb, CellValueFormatStyle str) { CellStyleConfig curStyle = new CellStyleConfig(); curStyle.curCellValueFormatStyle = str; curStyle.curBorderLineColorIndex = HSSFColor.OliveGreen.White.Index; return(ExcelWriteClass.GetCellStyle(wb, curStyle)); }