## SqlScriptSaveOptions class

Represents the options of saving sql.



**Inheritance:** [`SqlScriptSaveOptions`](/cells/python-net/aspose.cells.saving/sqlscriptsaveoptions) → 
[`SaveOptions`](/cells/python-net/aspose.cells/saveoptions)



The SqlScriptSaveOptions type exposes the following members:

### Constructors
| Constructor | Description |
| :- | :- |
| [`__init__(self)`](/cells/python-net/aspose.cells.saving/sqlscriptsaveoptions/__init__/#) | Creates options for saving sql file. |


### Properties
| Property | Description |
| :- | :- |
| [save_format](/cells/python-net/aspose.cells.saving/sqlscriptsaveoptions/save_format) | Gets the save file format. |
| [clear_data](/cells/python-net/aspose.cells.saving/sqlscriptsaveoptions/clear_data) | Make the workbook empty after saving the file. |
| [cached_file_folder](/cells/python-net/aspose.cells.saving/sqlscriptsaveoptions/cached_file_folder) | The folder for temporary files that may be used as data cache. |
| [validate_merged_areas](/cells/python-net/aspose.cells.saving/sqlscriptsaveoptions/validate_merged_areas) | Indicates whether validate merged cells before saving the file. |
| [merge_areas](/cells/python-net/aspose.cells.saving/sqlscriptsaveoptions/merge_areas) | Indicates whether merge the areas of conditional formatting and validation before saving the file. |
| [create_directory](/cells/python-net/aspose.cells.saving/sqlscriptsaveoptions/create_directory) | If true and the directory does not exist, the directory will be automatically created before saving the file. |
| [sort_names](/cells/python-net/aspose.cells.saving/sqlscriptsaveoptions/sort_names) | Indicates whether sorting defined names before saving file. |
| [sort_external_names](/cells/python-net/aspose.cells.saving/sqlscriptsaveoptions/sort_external_names) | Indicates whether sorting external defined names before saving file. |
| [refresh_chart_cache](/cells/python-net/aspose.cells.saving/sqlscriptsaveoptions/refresh_chart_cache) | Indicates whether refreshing chart cache data |
| [warning_callback](/cells/python-net/aspose.cells.saving/sqlscriptsaveoptions/warning_callback) | Gets or sets warning callback. |
| [check_excel_restriction](/cells/python-net/aspose.cells.saving/sqlscriptsaveoptions/check_excel_restriction) | Whether check restriction of excel file when user modify cells related objects.
<br/>For example, excel does not allow inputting string value longer than 32K.
<br/>When you input a value longer than 32K, it will be truncated. |
| [update_smart_art](/cells/python-net/aspose.cells.saving/sqlscriptsaveoptions/update_smart_art) | Indicates whether updating smart art setting.
<br/>The default value is false. |
| [encrypt_document_properties](/cells/python-net/aspose.cells.saving/sqlscriptsaveoptions/encrypt_document_properties) | Indicates whether encrypt document properties when saving as .xls file.
<br/>The default value is true. |
| [check_if_table_exists](/cells/python-net/aspose.cells.saving/sqlscriptsaveoptions/check_if_table_exists) | Check if the table name exists before creating |
| [column_type_map](/cells/python-net/aspose.cells.saving/sqlscriptsaveoptions/column_type_map) | Gets and sets the map of column type for different database. |
| [check_all_data_for_column_type](/cells/python-net/aspose.cells.saving/sqlscriptsaveoptions/check_all_data_for_column_type) | Check all data to find columns' data type. |
| [add_blank_line_between_rows](/cells/python-net/aspose.cells.saving/sqlscriptsaveoptions/add_blank_line_between_rows) | Insert blank line between each data. |
| [separator](/cells/python-net/aspose.cells.saving/sqlscriptsaveoptions/separator) | Gets and sets character separator of sql script. |
| [operator_type](/cells/python-net/aspose.cells.saving/sqlscriptsaveoptions/operator_type) | Gets and sets the operator type of sql. |
| [primary_key](/cells/python-net/aspose.cells.saving/sqlscriptsaveoptions/primary_key) | Represents which column is primary key of the data table. |
| [create_table](/cells/python-net/aspose.cells.saving/sqlscriptsaveoptions/create_table) | Indicates whether exporting sql of creating table. |
| [id_name](/cells/python-net/aspose.cells.saving/sqlscriptsaveoptions/id_name) | Gets and sets the name of id column. |
| [start_id](/cells/python-net/aspose.cells.saving/sqlscriptsaveoptions/start_id) | Gets and sets the start id. |
| [table_name](/cells/python-net/aspose.cells.saving/sqlscriptsaveoptions/table_name) | Gets and sets the table name. |
| [export_as_string](/cells/python-net/aspose.cells.saving/sqlscriptsaveoptions/export_as_string) | Indicates whether exporting all data as string value. |
| [sheet_indexes](/cells/python-net/aspose.cells.saving/sqlscriptsaveoptions/sheet_indexes) | Represents the indexes of exported sheets. |
| [export_area](/cells/python-net/aspose.cells.saving/sqlscriptsaveoptions/export_area) | Gets or sets the exporting range. |
| [has_header_row](/cells/python-net/aspose.cells.saving/sqlscriptsaveoptions/has_header_row) | Indicates whether the range contains header row. |



### See Also
* module [`aspose.cells.saving`](..)
* class [`SaveOptions`](/cells/python-net/aspose.cells/saveoptions)
* class [`SqlScriptSaveOptions`](/cells/python-net/aspose.cells.saving/sqlscriptsaveoptions)