使用CellsFactory类创建样式对象
Contents
[
Hide
]
使用CellsFactory类创建Style对象
以下示例代码使用CellsFactory类创建样式对象,然后设置工作簿的默认样式。请下载输出Excel文件以查看此代码的效果,供您参考。
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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") |