Class SqlScriptSaveOptions
Contents
[
Hide
]SqlScriptSaveOptions class
Represents the options of saving sql.
public class SqlScriptSaveOptions : SaveOptions
Constructors
Name | Description |
---|---|
SqlScriptSaveOptions() | Creates options for saving sql file. |
Properties
Name | Description |
---|---|
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
- class SaveOptions
- namespace Aspose.Cells.Saving
- assembly Aspose.Cells