SqlScriptSaveOptions

getAddBlankLineBetweenRows()

Insert blank line between each data. If Separator is '\n' , it's better to set this property as true to increase readability.

getCachedFileFolder()

The cached file folder is used to store some large data.

getCheckAllDataForColumnType()

Check all data to find columns' data type. The default value is false, we only check the first row for performance. If this property is true and the columns contains mixed value type, the columns' type will be text.

getCheckIfTableExists()

Check if the table name exists before creating

getClearData()

Make the workbook empty after saving the file.

getColumnTypeMap()

Gets and sets the map of column type for different database.

getCreateDirectory()

If true and the directory does not exist, the directory will be automatically created before saving the file. The default value is false.

getCreateTable()

Indicates whether exporting sql of creating table.

getExportArea()

Gets or sets the exporting range.

getExportAsString()

Indicates whether exporting all data as string value.

getIdName()

Gets and sets the name of id column. If this property is set , a column will be inserted with automatical increment int value.

getMergeAreas()

Indicates whether merge the areas of conditional formatting and validation before saving the file. The default value is false.

getOperatorType()

Gets and sets the operator type of sql. The value of the property is SqlScriptOperatorType integer constant.

getPrimaryKey()

Represents which column is primary key of the data table.

getRefreshChartCache()

Indicates whether refreshing chart cache data

getSaveFormat()

Gets the save file format. The value of the property is SaveFormat integer constant.

getSeparator()

Gets and sets character separator of sql script. Only can be ' ' or '\n'. If the

getSheetIndexes()

Represents the indexes of exported sheets.

getSortExternalNames()

Indicates whether sorting external defined names before saving file.

getSortNames()

Indicates whether sorting defined names before saving file.

getStartId()

Gets and sets the start id. Only works when IdName is set.

getTableName()

Gets and sets the table name.

getUpdateSmartArt()

Indicates whether updating smart art setting. The default value is false. Only effects after calling Shape.GetResultOfSmartArt() method and the cached shapes exist in the template file.

getValidateMergedAreas()

Indicates whether validate merged cells before saving the file. The default value is false.

getWarningCallback()

Gets or sets warning callback.

hasHeaderRow()

Indicates whether the range contains header row.

setAddBlankLineBetweenRows()

Insert blank line between each data. If Separator is '\n' , it's better to set this property as true to increase readability.

setCachedFileFolder()

The cached file folder is used to store some large data.

setCheckAllDataForColumnType()

Check all data to find columns' data type. The default value is false, we only check the first row for performance. If this property is true and the columns contains mixed value type, the columns' type will be text.

setCheckIfTableExists()

Check if the table name exists before creating

setClearData()

Make the workbook empty after saving the file.

setColumnTypeMap()

Gets and sets the map of column type for different database.

setCreateDirectory()

If true and the directory does not exist, the directory will be automatically created before saving the file. The default value is false.

setCreateTable()

Indicates whether exporting sql of creating table.

setExportArea()

Gets or sets the exporting range.

setExportAsString()

Indicates whether exporting all data as string value.

setHasHeaderRow()

Indicates whether the range contains header row.

setIdName()

Gets and sets the name of id column. If this property is set , a column will be inserted with automatical increment int value.

setMergeAreas()

Indicates whether merge the areas of conditional formatting and validation before saving the file. The default value is false.

setOperatorType()

Gets and sets the operator type of sql. The value of the property is SqlScriptOperatorType integer constant.

setPrimaryKey()

Represents which column is primary key of the data table.

setRefreshChartCache()

Indicates whether refreshing chart cache data

setSeparator()

Gets and sets character separator of sql script. Only can be ' ' or '\n'. If the

setSheetIndexes()

Represents the indexes of exported sheets.

setSortExternalNames()

Indicates whether sorting external defined names before saving file.

setSortNames()

Indicates whether sorting defined names before saving file.

setStartId()

Gets and sets the start id. Only works when IdName is set.

setTableName()

Gets and sets the table name.

setUpdateSmartArt()

Indicates whether updating smart art setting. The default value is false. Only effects after calling Shape.GetResultOfSmartArt() method and the cached shapes exist in the template file.

setValidateMergedAreas()

Indicates whether validate merged cells before saving the file. The default value is false.

setWarningCallback()

Gets or sets warning callback.