Class SqlScriptSaveOptions

SqlScriptSaveOptions class

Represents the options of saving sql.

public class SqlScriptSaveOptions : SaveOptions

Constructors

NameDescription
SqlScriptSaveOptions()Creates options for saving sql file.

Properties

NameDescription
AddBlankLineBetweenRows { get; set; }Insert blank line between each data.
CachedFileFolder { get; set; }The cached file folder is used to store some large data.(Inherited from SaveOptions.)
CheckAllDataForColumnType { get; set; }Check all data to find columns’ data type.
CheckIfTableExists { get; set; }Check if the table name exists before creating
ClearData { get; set; }Make the workbook empty after saving the file.(Inherited from SaveOptions.)
ColumnTypeMap { get; set; }Gets and sets the map of column type for different database.
CreateDirectory { get; set; }If true and the directory does not exist, the directory will be automatically created before saving the file.(Inherited from SaveOptions.)
CreateTable { get; set; }Indicates whether exporting sql of creating table.
ExportArea { get; set; }Gets or sets the exporting range.
ExportAsString { get; set; }Indicates whether exporting all data as string value.
HasHeaderRow { get; set; }Indicates whether the range contains header row.
IdName { get; set; }Gets and sets the name of id column.
MergeAreas { get; set; }Indicates whether merge the areas of conditional formatting and validation before saving the file.(Inherited from SaveOptions.)
OperatorType { get; set; }Gets and sets the operator type of sql.
PrimaryKey { get; set; }Represents which column is primary key of the data table.
RefreshChartCache { get; set; }Indicates whether refreshing chart cache data(Inherited from SaveOptions.)
SaveFormat { get; }Gets the save file format.(Inherited from SaveOptions.)
Separator { get; set; }Gets and sets character separator of sql script.
SheetIndexes { get; set; }Represents the indexes of exported sheets.
SortExternalNames { get; set; }Indicates whether sorting external defined names before saving file.(Inherited from SaveOptions.)
SortNames { get; set; }Indicates whether sorting defined names before saving file.(Inherited from SaveOptions.)
StartId { get; set; }Gets and sets the start id.
TableName { get; set; }Gets and sets the table name.
UpdateSmartArt { get; set; }Indicates whether updating smart art setting. The default value is false.(Inherited from SaveOptions.)
ValidateMergedAreas { get; set; }Indicates whether validate merged cells before saving the file.(Inherited from SaveOptions.)
WarningCallback { get; set; }Gets or sets warning callback.(Inherited from SaveOptions.)

See Also