from aspose.cells import SaveFormat, Workbook
from aspose.pydrawing import Color
from os import os, path

#  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 directory if it is not already present.
IsExists = path.isdir(dataDir)
if notIsExists:
    os.makedirs(dataDir)
#  Instantiating an Workbook object
workbook = Workbook()
#  Adding Orchid color to the palette at 55th index
workbook.change_palette(Color.orchid, 55)
#  Adding a new worksheet to the Excel object
i = workbook.worksheets.add()
#  Obtaining the reference of the newly added worksheet by passing its sheet index
worksheet = workbook.worksheets[i]
#  Accessing the "A1" cell from the worksheet
cell = worksheet.cells.get("A1")
#  Adding some value to the "A1" cell
cell.put_value("Hello Aspose!")
#  Defining new Style object
styleObject = workbook.create_style()
#  Setting the Orchid (custom) color to the font
styleObject.font.color = Color.orchid
#  Applying the style to the cell
cell.set_style(styleObject)
#  Saving the Excel file
workbook.save(dataDir + "book1.out.xls", SaveFormat.AUTO)