如何用 Python.NET 设置打印区域

可能的使用场景

在文档中设置打印区域有助于控制打印内容。主要原因包括：

1. 聚焦特定数据：仅打印相关部分
2. 改善布局：整齐排列内容跨多个页面
3. 节省资源：减少纸张/墨水消耗
4. 专业表现：确保输出更佳
5. 一致性：保持统一的打印输出

** 如何在 Excel 中设置打印区域**

编程方式设置打印区域：

1. 访问工作表的页面设置属性
2. 使用单元格范围符号定义打印区域
3. 保存已修改的工作簿

# Sample image reference remains unchanged
<img src="3.png" width=60% />

如何在Excel中清除打印区域

要删除打印区域限制：

1. 访问页面设置属性
2. 将打印区域重置为空字符串
3. 保存更改

# Sample image reference remains unchanged
<img src="4.png" width=60% />

清除打印区域后会发生什么

清除打印区域会导致：

1. 默认打印整个工作表
2. 移除之前的范围限制
3. 包含所有已格式化单元格

如何使用Aspose.Cells设置打印区域

通过工作表的页面设置设置打印区域：

import aspose.cells as ac

# Load sample workbook
workbook = ac.Workbook("input.xlsx")

# Access first worksheet
worksheet = workbook.worksheets[0]

# Set print area to A1:D10
worksheet.page_setup.print_area = "A1:D10"

# Save modified workbook
workbook.save("output_set_print_area.xlsx")

# Output image reference
<img src="1.png" width=60% />

如何使用Aspose.Cells清除打印区域

删除现有的打印区域定义：

import aspose.cells as ac

# Load sample workbook
workbook = ac.Workbook("input.xlsx")

# Access first worksheet
worksheet = workbook.worksheets[0]

# Clear print area
worksheet.page_setup.print_area = ""

# Save modified workbook
workbook.save("output_clear_print_area.xlsx")

# Output image reference
<img src="2.png" width=60% />

from aspose.cells import Workbook

# Load the workbook
workbook = Workbook("input.xlsx")

# Access the desired worksheet
worksheet = workbook.worksheets[0]

# Set the print area - specify the range you want to print
worksheet.page_setup.print_area = "A1:D10"

# Save the workbook
workbook.save("set_print_area.pdf")

from aspose.cells import Workbook

# Load the workbook
workbook = Workbook("input.xlsx")

# Access the desired worksheet
worksheet = workbook.worksheets[0]

# Clear the print area
worksheet.page_setup.print_area = ""

# Save the workbook
workbook.save("clear_print_area.pdf")