使用CellsFactory类创建样式对象

使用CellsFactory类创建Style对象

以下示例代码使用CellsFactory类创建样式对象,然后设置工作簿的默认样式。请下载输出Excel文件以查看此代码的效果,供您参考。

from aspose.cells import BackgroundType, CellsFactory, Workbook
from aspose.pydrawing import Color
# For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
# The path to the documents directory.
dataDir = RunExamples.GetDataDir(".")
# Create a Style object using CellsFactory class
cf = CellsFactory()
st = cf.create_style()
# Set the Style fill color to Yellow
st.pattern = BackgroundType.SOLID
st.foreground_color = Color.yellow
# Create a workbook and set its default style using the created Style object
wb = Workbook()
wb.default_style = st
# Save the workbook
wb.save(dataDir + "output_out.xlsx")