在ODS文件中使用背景

ODS文件中的背景

可以将背景添加到ODS文件中的工作表。背景可以是彩色背景或图形背景。在打开文件时背景不可见，但如果文件作为PDF打印，则在生成的PDF中可以看到背景。在打印预览对话框中也可以看到背景。

Aspose.Cells for Python via .NET提供读取背景信息并在ODS文件中添加背景的能力。

从ODS文件读取背景信息

Aspose.Cells for Python via .NET 提供 OdsPageBackground 类来管理ODS文件中的背景。以下示例演示了通过加载 source ODS 文件并读取背景信息来使用 OdsPageBackground 类的方法。请参考代码生成的控制台输出。

示例代码

from aspose.cells import Workbook
from PIL import Image

#  For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
# Source directory
sourceDir = ""
# Output directory
outputDir = ""
# Load source Excel file
workbook = Workbook(sourceDir + "GraphicBackground.ods")
# Access first worksheet
worksheet = workbook.worksheets[0]
background = worksheet.page_setup.ods_page_background
print("Background Type: "  + str(background.type))
print("Backgorund Position: "  + str(background.graphic_position_type))

image = Image.frombytes(mode='RGB', size=(50,50), data=background.graphic_data)
image.save(outputDir + "background.jpg")

控制台输出

Background Type: Graphic

Backgorund Position: CenterCenter

向ODS文件添加彩色背景

Aspose.Cells for Python via .NET 提供 OdsPageBackground 类来管理ODS文件中的背景。以下示例演示了通过使用 OdsPageBackground.color 属性向ODS文件添加彩色背景的方法。请参考代码生成的 output ODS 文件。

示例代码

from aspose.cells import SaveFormat, Workbook
from aspose.cells.ods import OdsPageBackgroundType
from aspose.pydrawing import Color

#  For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
# Output directory
outputDir = RunExamples.Get_OutputDirectory()
#  Instantiating a Workbook object
workbook = Workbook()
# Access first worksheet
worksheet = workbook.worksheets[0]
worksheet.cells.get(0, 0).value = 1
worksheet.cells.get(1, 0).value = 2
worksheet.cells.get(2, 0).value = 3
worksheet.cells.get(3, 0).value = 4
worksheet.cells.get(4, 0).value = 5
worksheet.cells.get(5, 0).value = 6
worksheet.cells.get(0, 1).value = 7
worksheet.cells.get(1, 1).value = 8
worksheet.cells.get(2, 1).value = 9
worksheet.cells.get(3, 1).value = 10
worksheet.cells.get(4, 1).value = 11
worksheet.cells.get(5, 1).value = 12
background = worksheet.page_setup.ods_page_background

background.color = Color.red
background.type = OdsPageBackgroundType.COLOR
workbook.save(outputDir + "ColoredBackground.ods", SaveFormat.ODS)

向ODS文件添加图形背景

Aspose.Cells for Python via .NET 提供 OdsPageBackground 类来管理ODS文件中的背景。以下示例演示了通过使用 OdsPageBackground.graphic_data 属性向ODS文件添加图形背景的方法。请参考代码生成的 output ODS 文件。

示例代码

from aspose.cells import SaveFormat, Workbook
from aspose.cells.ods import OdsPageBackgroundGraphicType, OdsPageBackgroundType

#  For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
# Source directory
sourceDir = RunExamples.Get_SourceDirectory()
# Output directory
outputDir = RunExamples.Get_OutputDirectory()
#  Instantiating a Workbook object
workbook = Workbook()
# Access first worksheet
worksheet = workbook.worksheets[0]
worksheet.cells.get(0, 0).value = 1
worksheet.cells.get(1, 0).value = 2
worksheet.cells.get(2, 0).value = 3
worksheet.cells.get(3, 0).value = 4
worksheet.cells.get(4, 0).value = 5
worksheet.cells.get(5, 0).value = 6
worksheet.cells.get(0, 1).value = 7
worksheet.cells.get(1, 1).value = 8
worksheet.cells.get(2, 1).value = 9
worksheet.cells.get(3, 1).value = 10
worksheet.cells.get(4, 1).value = 11
worksheet.cells.get(5, 1).value = 12
background = worksheet.page_setup.ods_page_background
background.type = OdsPageBackgroundType.GRAPHIC
background.graphic_data = open(sourceDir + "background.jpg", "rb").read()
background.graphic_type = OdsPageBackgroundGraphicType.AREA
workbook.save(outputDir + "GraphicBackground.ods", SaveFormat.ODS)