Create Style object using CellsFactory class

Create Style object using CellsFactory class

The following sample code creates Style object using CellsFactory class and then sets the Default Style of the workbook. Please download the output excel file to see the results of this code for your reference.

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")