private void SetColumnWidth(ISheet curSheet)
{
for (int i = 0; i < 13; i++)
{
ExcelWriteClass.SetColumnWidth(curSheet, 9 * 256);
}
}
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));
}
