SqlScriptSaveOptions class

SqlScriptSaveOptions class

Represents the options of saving sql.

Inheritance: SqlScriptSaveOptions → SaveOptions

The SqlScriptSaveOptions type exposes the following members:

Constructors

Constructor	Description
init	Creates options for saving sql file.

Properties

Property	Description
save_format	Gets the save file format.
clear_data	Make the workbook empty after saving the file.
cached_file_folder	The cached file folder is used to store some large data.
validate_merged_areas	Indicates whether validate merged cells before saving the file.
merge_areas	Indicates whether merge the areas of conditional formatting and validation before saving the file.
create_directory	If true and the directory does not exist, the directory will be automatically created before saving the file.
sort_names	Indicates whether sorting defined names before saving file.
sort_external_names	Indicates whether sorting external defined names before saving file.
refresh_chart_cache	Indicates whether refreshing chart cache data
warning_callback	Gets or sets warning callback.
update_smart_art	Indicates whether updating smart art setting. The default value is false.
encrypt_document_properties	Indicates whether encrypt document properties when saving as .xls file. The default value is true.
check_if_table_exists	Check if the table name exists before creating
column_type_map	Gets and sets the map of column type for different database.
check_all_data_for_column_type	Check all data to find columns’ data type.
add_blank_line_between_rows	Insert blank line between each data.
separator	Gets and sets character separator of sql script.
operator_type	Gets and sets the operator type of sql.
primary_key	Represents which column is primary key of the data table.
create_table	Indicates whether exporting sql of creating table.
id_name	Gets and sets the name of id column.
start_id	Gets and sets the start id.
table_name	Gets and sets the table name.
export_as_string	Indicates whether exporting all data as string value.
sheet_indexes	Represents the indexes of exported sheets.
export_area	Gets or sets the exporting range.
has_header_row	Indicates whether the range contains header row.

See Also

• module aspose.cells.saving
• class SaveOptions
• class SqlScriptSaveOptions