aspose.cells

Constructor Detail

• XlsSaveOptions

  function XlsSaveOptions()

  Creates options for saving Excel 97-2003 xls/xlt file.

• XlsSaveOptions

  function XlsSaveOptions(format)

  Creates options for saving Excel 97-2003 xls/xlt file.

  Parameters:

  format: Number - A SaveFormat value. The file format. It must be xls/xlt.

Property Getters/Setters Detail

• getLightCellsDataProvider/setLightCellsDataProvider : LightCellsDataProvider 

  function getLightCellsDataProvider() / function setLightCellsDataProvider(value)
  

  The Data provider to provide cells data for saving workbook in light mode.

• isTemplate/setTemplate : boolean 

  function isTemplate() / function setTemplate(value)
  

  Indicates whether saving a template file.

• getMatchColor/setMatchColor : boolean 

  function getMatchColor() / function setMatchColor(value)
  

  Indicates whether matching font color because there are 56 colors in the standard color palette.

• getSaveFormat : Number 

  function getSaveFormat()
  

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

• getClearData/setClearData : boolean 

  function getClearData() / function setClearData(value)
  

  Make the workbook empty after saving the file.

• getCachedFileFolder/setCachedFileFolder : String 

  function getCachedFileFolder() / function setCachedFileFolder(value)
  

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

• getValidateMergedAreas/setValidateMergedAreas : boolean 

  function getValidateMergedAreas() / function setValidateMergedAreas(value)
  

  Indicates whether validate merged cells before saving the file.

  The default value is false.

• getMergeAreas/setMergeAreas : boolean 

  function getMergeAreas() / function setMergeAreas(value)
  

  Indicates whether merge the areas of conditional formatting and validation before saving the file.

  The default value is false.

• getCreateDirectory/setCreateDirectory : boolean 

  function getCreateDirectory() / function setCreateDirectory(value)
  

  If true and the directory does not exist, the directory will be automatically created before saving the file.

  The default value is false.

• getSortNames/setSortNames : boolean 

  function getSortNames() / function setSortNames(value)
  

  Indicates whether sorting defined names before saving file.

• getSortExternalNames/setSortExternalNames : boolean 

  function getSortExternalNames() / function setSortExternalNames(value)
  

  Indicates whether sorting external defined names before saving file.

• getRefreshChartCache/setRefreshChartCache : boolean 

  function getRefreshChartCache() / function setRefreshChartCache(value)
  

  Indicates whether refreshing chart cache data

• getPdfExportImagesFolder/setPdfExportImagesFolder : String 

  function getPdfExportImagesFolder() / function setPdfExportImagesFolder(value)
  

  The physical folder where images will be saved when exporting a workbook to Aspose.Pdf XML format. Default is an empty string.

• getEnableHTTPCompression/setEnableHTTPCompression : boolean 

  function getEnableHTTPCompression() / function setEnableHTTPCompression(value)
  

  Indicates if http compression is to be used in user's IIS.

  Please specify this property to true if http compression is used.

• getUpdateSmartArt/setUpdateSmartArt : boolean 

  function getUpdateSmartArt() / function setUpdateSmartArt(value)
  

  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.