## WorkbookSettings类
代表工作簿的所有设置。



WorkbookSettings 类型公开以下成员：

### 属性
|属性|描述|
| :- | :- |
| [author](/cells/python-net/zh/aspose.cells/workbooksettings/author) |获取并设置文件的作者。|
| [check_custom_number_format](/cells/python-net/zh/aspose.cells/workbooksettings/check_custom_number_format) |设置Style.Custom时是否检查自定义数字格式。|
| [enable_macros](/cells/python-net/zh/aspose.cells/workbooksettings/enable_macros) |启用宏；|
| [date1904](/cells/python-net/zh/aspose.cells/workbooksettings/date1904) |获取或设置一个值，该值表示工作簿是否使用 1904 日期系统。|
| [protection_type](/cells/python-net/zh/aspose.cells/workbooksettings/protection_type) |获取工作簿的保护类型。|
| [display_drawing_objects](/cells/python-net/zh/aspose.cells/workbooksettings/display_drawing_objects) |指示是否以及如何显示工作簿中的对象。|
| [sheet_tab_bar_width](/cells/python-net/zh/aspose.cells/workbooksettings/sheet_tab_bar_width) |工作表选项卡栏的宽度（窗口宽度的 1/1000）。|
| [show_tabs](/cells/python-net/zh/aspose.cells/workbooksettings/show_tabs) |获取或设置是否显示工作簿选项卡的值。|
| [first_visible_tab](/cells/python-net/zh/aspose.cells/workbooksettings/first_visible_tab) |获取或设置第一个可见的工作表选项卡。|
| [is_h_scroll_bar_visible](/cells/python-net/zh/aspose.cells/workbooksettings/is_h_scroll_bar_visible) |获取或设置一个值，该值指示生成的电子表格是否包含水平滚动条。|
| [is_v_scroll_bar_visible](/cells/python-net/zh/aspose.cells/workbooksettings/is_v_scroll_bar_visible) |获取或设置一个值，该值指示生成的电子表格是否包含垂直滚动条。|
| [shared](/cells/python-net/zh/aspose.cells/workbooksettings/shared) |获取或设置一个值，该值指示工作簿是否共享。|
| [language_code](/cells/python-net/zh/aspose.cells/workbooksettings/language_code) |根据保存文件的国家/地区代码获取或设置工作簿版本的用户界面语言。|
| [region](/cells/python-net/zh/aspose.cells/workbooksettings/region) |获取或设置工作簿的区域设置。|
| [globalization_settings](/cells/python-net/zh/aspose.cells/workbooksettings/globalization_settings) |获取并设置全球化设置。|
| [number_decimal_separator](/cells/python-net/zh/aspose.cells/workbooksettings/number_decimal_separator) |获取或设置用于格式化/解析数值的小数分隔符。默认为当前区域的小数分隔符。|
| [number_group_separator](/cells/python-net/zh/aspose.cells/workbooksettings/number_group_separator) |获取或设置数值中小数点左侧数字组的分隔符。默认值为当前区域的组分隔符。|
| [password](/cells/python-net/zh/aspose.cells/workbooksettings/password) |表示工作簿文件加密密码。|
| [write_protection](/cells/python-net/zh/aspose.cells/workbooksettings/write_protection) |提供对工作簿写保护选项的访问。|
| [is_encrypted](/cells/python-net/zh/aspose.cells/workbooksettings/is_encrypted) |获取一个值，该值指示打开此工作簿是否需要密码。|
| [is_protected](/cells/python-net/zh/aspose.cells/workbooksettings/is_protected) |获取一个值，该值指示工作簿的结构或窗口是否受保护。|
| [is_default_encrypted](/cells/python-net/zh/aspose.cells/workbooksettings/is_default_encrypted) |指示如果工作簿的结构和 Windows 被锁定，是否使用默认密码加密工作簿。|
| [is_minimized](/cells/python-net/zh/aspose.cells/workbooksettings/is_minimized) |表示生成的电子表格是否以最小化方式打开。|
| [is_hidden](/cells/python-net/zh/aspose.cells/workbooksettings/is_hidden) |指示此工作簿是否隐藏。|
| [auto_compress_pictures](/cells/python-net/zh/aspose.cells/workbooksettings/auto_compress_pictures) |指定一个布尔值，指示应用程序是否自动压缩工作簿中的图片。|
| [remove_personal_information](/cells/python-net/zh/aspose.cells/workbooksettings/remove_personal_information) |如果可以从指定的工作簿中删除个人信息，则为 True。|
| [hide_pivot_field_list](/cells/python-net/zh/aspose.cells/workbooksettings/hide_pivot_field_list) |获取或设置是否隐藏数据透视表的字段列表。|
| [update_links_type](/cells/python-net/zh/aspose.cells/workbooksettings/update_links_type) |获取并设置工作簿打开时如何更新外部链接。|
| [max_row](/cells/python-net/zh/aspose.cells/workbooksettings/max_row) |获取最大行索引（从零开始）。|
| [max_column](/cells/python-net/zh/aspose.cells/workbooksettings/max_column) |获取最大列索引（从零开始）。|
| [default_style_settings](/cells/python-net/zh/aspose.cells/workbooksettings/default_style_settings) |获取此工作簿的样式相关属性的默认值设置。|
| [window_left](/cells/python-net/zh/aspose.cells/workbooksettings/window_left) |客户区左边缘到窗口左边缘的距离，以点为单位。|
| [window_left_inch](/cells/python-net/zh/aspose.cells/workbooksettings/window_left_inch) |从客户区左边缘到窗口左边缘的距离。<br/>以英寸为单位。|
| [window_left_cm](/cells/python-net/zh/aspose.cells/workbooksettings/window_left_cm) |从客户区左边缘到窗口左边缘的距离。<br/>以厘米为单位。|
| [window_top](/cells/python-net/zh/aspose.cells/workbooksettings/window_top) |客户区上边缘到窗口上边缘的距离，以点为单位。|
| [window_top_inch](/cells/python-net/zh/aspose.cells/workbooksettings/window_top_inch) |客户区上边缘到窗口上边缘的距离，单位为英寸。|
| [window_top_cm](/cells/python-net/zh/aspose.cells/workbooksettings/window_top_cm) |客户区上边缘到窗口上边缘的距离，单位为厘米。|
| [window_width](/cells/python-net/zh/aspose.cells/workbooksettings/window_width) |窗口的宽度，以点为单位。|
| [window_width_inch](/cells/python-net/zh/aspose.cells/workbooksettings/window_width_inch) |窗口的宽度，单位为英寸。|
| [window_width_cm](/cells/python-net/zh/aspose.cells/workbooksettings/window_width_cm) |窗口的宽度，单位为厘米。|
| [window_height](/cells/python-net/zh/aspose.cells/workbooksettings/window_height) |窗口的高度，以点为单位。|
| [window_height_inch](/cells/python-net/zh/aspose.cells/workbooksettings/window_height_inch) |窗口的高度，单位为英寸。|
| [window_height_cm](/cells/python-net/zh/aspose.cells/workbooksettings/window_height_cm) |窗口的高度，单位为厘米。|
| [update_adjacent_cells_border](/cells/python-net/zh/aspose.cells/workbooksettings/update_adjacent_cells_border) |指示是否更新相邻单元格的边框。|
| [significant_digits](/cells/python-net/zh/aspose.cells/workbooksettings/significant_digits) |获取并设置有效数字的数量。<br/>默认值为 [`CellsHelper.significant_digits`](/cells/python-net/zh/aspose.cells/cellshelper#significant_digits)。|
| [check_compatibility](/cells/python-net/zh/aspose.cells/workbooksettings/check_compatibility) |指示保存工作簿时是否检查与早期版本的兼容性。|
| [check_excel_restriction](/cells/python-net/zh/aspose.cells/workbooksettings/check_excel_restriction) |当用户修改单元格相关对象时是否检查Excel文件的限制。<br/>例如，excel不允许输入长度超过32K的字符串值。<br/>当您输入一个长度超过 32K 的值（例如 Cell.PutValue(string)）时，如果此属性为真，您将收到异常。<br/>如果此属性为 false，我们将接受您输入的字符串值作为单元格的值，以便稍后<br/>您可以输出其他文件格式的完整字符串值，例如 CSV。<br/>但是，如果您设置了对 Excel 文件格式无效的值，<br/>请勿将工作簿保存为 Excel 文件格式。否则，生成的 Excel 文件可能会出现意外错误。|
| [auto_recover](/cells/python-net/zh/aspose.cells/workbooksettings/auto_recover) |指示文件是否标记为自动恢复。|
| [crash_save](/cells/python-net/zh/aspose.cells/workbooksettings/crash_save) |指示应用程序崩溃后是否最后保存了工作簿文件。|
| [data_extract_load](/cells/python-net/zh/aspose.cells/workbooksettings/data_extract_load) |指示应用程序最后是否打开工作簿进行数据恢复。|
| [repair_load](/cells/python-net/zh/aspose.cells/workbooksettings/repair_load) |指示应用程序上次打开工作簿时是在安全模式下还是修复模式下。|
| [build_version](/cells/python-net/zh/aspose.cells/workbooksettings/build_version) |指定应用程序的增量公开发布。|
| [memory_setting](/cells/python-net/zh/aspose.cells/workbooksettings/memory_setting) |获取或设置内存使用选项。新选项将作为新建工作表的默认选项，但不会对现有工作表生效。|
| [paper_size](/cells/python-net/zh/aspose.cells/workbooksettings/paper_size) |获取并设置默认打印纸张尺寸。|
| [max_rows_of_shared_formula](/cells/python-net/zh/aspose.cells/workbooksettings/max_rows_of_shared_formula) |获取并设置共享公式的最大行数。|
| [compliance](/cells/python-net/zh/aspose.cells/workbooksettings/compliance) |指定输出文档的 OOXML 版本。默认值为 Ecma376_2006。|
| [quote_prefix_to_style](/cells/python-net/zh/aspose.cells/workbooksettings/quote_prefix_to_style) |指示在单元格中输入字符串值（以单引号开头）时是否设置 [`Style.quote_prefix`](/cells/python-net/zh/aspose.cells/style#quote_prefix) 属性|
| [formula_settings](/cells/python-net/zh/aspose.cells/workbooksettings/formula_settings) |获取公式相关功能的设置。|
| [properties_follow_chart_point](/cells/python-net/zh/aspose.cells/workbooksettings/properties_follow_chart_point) |指示此工作簿中所有图表的数据点属性和数据标签是否遵循其引用。|
| [discard_image_edit_data](/cells/python-net/zh/aspose.cells/workbooksettings/discard_image_edit_data) |表示是否丢弃正在编辑的图像数据。|
| [default_image_resolution](/cells/python-net/zh/aspose.cells/workbooksettings/default_image_resolution) |获取并设置图像的默认分辨率。|


### 方法
|方法|描述|
| :- | :- |
| [`get_theme_font(self, type)`](/cells/python-net/zh/aspose.cells/workbooksettings/get_theme_font/#aspose.cells.fontschemetype) |获取默认主题字体名称。|
| [`set_page_orientation_type(self, page_orientation_type)`](/cells/python-net/zh/aspose.cells/workbooksettings/set_page_orientation_type/#aspose.cells.pageorientationtype) |设置整个工作簿的打印方向类型。|



### 例子

```python
from aspose.cells import Workbook

workbook = Workbook()
settings = workbook.settings

```

### 也可以看看
* 模块[`aspose.cells`](..)
