Aspose.Cells区域格式设置

Aspose.Cells很强大。

1 首先设置格式

                    //设置格式
                    Aspose.Cells.Style s = workbook.Styles[workbook.Styles.Add()];
                    s.Font.Color = Color.Red;
                    s.ForegroundColor = Color.Yellow;//Color.Yellow;
                    s.Pattern = Aspose.Cells.BackgroundType.Solid;

2 设置区域

                    Aspose.Cells.Range r = cellSheet.Cells.CreateRange(3, 3, 3, 3);
                    r.SetStyle(s);

3 效果图