1 单个单元格设置样式
1.1 使用SetStyle()
Workbook workbook=new Workbook();
Style style=workbook.Styles[workbook.Styles.Add()];
WorkSheet worksheet=workbook.WorkSheet[0];
Cells cells=worksheet.Cells;
//给第一行第一列设置样式
cells[0, 0].SetStyle(style);
1.2 使用ApplyStyle()
Workbook workbook=new Workbook();
Style style=workbook.Styles[workbook.Styles.Add()];
WorkSheet worksheet=workbook.WorkSheet[0];
Cells cells=worksheet.Cells;
//给第一行第一列设置样式
Range range= worksheet.Cells.CreateRange(0, 0, 1, 1);
range.ApplyStyle(style, new StyleFlag() { All=true});
2 多个单元格设置样式
Workbook workbook=new Workbook();
Style style=workbook.Styles[workbook.Styles.Add()];
WorkSheet worksheet=workbook.WorkSheet[0];
Cells cells=worksheet.Cells;
//给第一行第一列到第二行第二列总共4个单元格设置样式
Range range= worksheet.Cells.CreateRange(0, 0, 2, 2);
range.ApplyStyle(style, new StyleFlag() { All=true});