1、冻结窗口:
void WorkSheet.FreezePanes(cellName, freezedRows, freezedColumns)
row, column, freezedRows, freezedColumns
2、设置单元格底色:
Workbook workbook = new Workbook();
Worksheet ws = workbook.Worksheets[0];
Style style = workbook.Styles[workbook.Styles.Add()];
style.BackgroundColor = System.Drawing.Color.Red;
style.ForegroundColor = System.Drawing.Color.Green;
style.Pattern = Aspose.Cells.BackgroundType.Solid;
StyleFlag flag = new StyleFlag();
flag.All = true;
sheet.Cells.ApplyRowStyle(0, style, flag);