ExcelSaveOptions

Inheritance: java.lang.Object, com.aspose.pdf.SaveOptions, com.aspose.pdf.UnifiedSaveOptions

public class ExcelSaveOptions extends UnifiedSaveOptions

Save options for export to Excel format

Constructors

ConstructorDescription
ExcelSaveOptions()Constructor

Methods

MethodDescription
getMinimizeTheNumberOfWorksheets()Set true if you need to minimize the number of worksheets in resultant workbook.
setMinimizeTheNumberOfWorksheets(boolean value)Set true if you need to minimize the number of worksheets in resultant workbook.
isInsertBlankColumnAtFirst()Set false if you need suppress inserting of blank column as the first column of worksheet.
setInsertBlankColumnAtFirst(boolean value)Set false if you need suppress inserting of blank column as the first column of worksheet.
isUniformWorksheets()Set true for using uniform columns division through the document.
setUniformWorksheets(boolean value)Set true for using uniform columns division through the document.
getFormat()Output format.
setFormat(int value)Output format

ExcelSaveOptions()

public ExcelSaveOptions()

Constructor

getMinimizeTheNumberOfWorksheets()

public boolean getMinimizeTheNumberOfWorksheets()

Set true if you need to minimize the number of worksheets in resultant workbook. Default value is false; it means save of each PDF page as separated worksheet.

Returns: boolean - boolean value

setMinimizeTheNumberOfWorksheets(boolean value)

public void setMinimizeTheNumberOfWorksheets(boolean value)

Set true if you need to minimize the number of worksheets in resultant workbook. Default value is false; it means save of each PDF page as separated worksheet.

Parameters:

ParameterTypeDescription
valuebooleanboolean value

isInsertBlankColumnAtFirst()

public boolean isInsertBlankColumnAtFirst()

Set false if you need suppress inserting of blank column as the first column of worksheet. Default value is true; it means that blank column will be inserted.

Returns: boolean - boolean value

setInsertBlankColumnAtFirst(boolean value)

public void setInsertBlankColumnAtFirst(boolean value)

Set false if you need suppress inserting of blank column as the first column of worksheet. Default value is true; it means that blank column will be inserted.

Parameters:

ParameterTypeDescription
valuebooleanboolean value

isUniformWorksheets()

public boolean isUniformWorksheets()

Set true for using uniform columns division through the document. Default value is false; it means that columns division will independent for each page.

Returns: boolean - boolean value

setUniformWorksheets(boolean value)

public void setUniformWorksheets(boolean value)

Set true for using uniform columns division through the document. Default value is false; it means that columns division will independent for each page.

Parameters:

ParameterTypeDescription
valuebooleanboolean value

getFormat()

public int getFormat()

Output format.

Return ExcelSaveOptions.ExcelFormat.XMLSpreadSheet2003 or ExcelSaveOptions.ExcelFormat.XLSX or ExcelSaveOptions.ExcelFormat.CSV

Returns: int - ExcelFormat element

setFormat(int value)

public void setFormat(int value)

Output format

Use the ExcelSaveOptions.ExcelFormat.XMLSpreadSheet2003 or ExcelSaveOptions.ExcelFormat.XLSX

Parameters:

ParameterTypeDescription
valueintExcelFormat element