If AllColumnsInOnePagePerSheet is true , all column content of one sheet will output to only one page in result.
The width of paper size of pagesetup will be invalid, and the other settings of pagesetup
will still take effect.
When characters in the Excel are Unicode and not be set with correct font in cell style,
They may appear as block in pdf,image.
Set this to true to try to use workbook's default font to show these characters first.
When characters in the Excel are Unicode and not be set with correct font in cell style,
They may appear as block in pdf,image.
Set the DefaultFont such as MingLiu or MS Gothic to show these characters.
If this property is not set, Aspose.Cells will use system default font to show these unicode characters.
If OnePagePerSheet is true , all content of one sheet will output to only one page in result.
The paper size of pagesetup will be invalid, and the other settings of pagesetup
will still take effect.
Gets or sets the type of compression to apply only when saving pages to the Tiff format.
The value of the property is TiffCompression integer constant.
public int getSaveFormat() / public void setSaveFormat(int value)
Gets or sets the output file format type
Support Tiff/XPS
The value of the property is SaveFormat integer constant.
NOTE: This member is now obsolete. Instead,
For Tiff/Svg, use ImageType; For Xps, use Workbook.save(java.lang.String, com.aspose.cells.SaveOptions) with XpsSaveOptions.
This property will be removed 12 months later since August 2022.
Aspose apologizes for any inconvenience you may have experienced.
getPrintWithStatusDialog/setPrintWithStatusDialog
public boolean getPrintWithStatusDialog() / public void setPrintWithStatusDialog(boolean value)
If PrintWithStatusDialog = true , there will be a dialog that shows current print status.
else no such dialog will show.
getHorizontalResolution/setHorizontalResolution
public int getHorizontalResolution() / public void setHorizontalResolution(int value)
Gets or sets the horizontal resolution for generated images, in dots per inch.
Applies generating image method except Emf format images.
The default value is 96.
getVerticalResolution/setVerticalResolution
public int getVerticalResolution() / public void setVerticalResolution(int value)
Gets or sets the vertical resolution for generated images, in dots per inch.
Applies generating image method except Emf format image.
The default value is 96.
getTiffCompression/setTiffCompression
public int getTiffCompression() / public void setTiffCompression(int value)
Gets or sets the type of compression to apply only when saving pages to the Tiff format.
The value of the property is TiffCompression integer constant.
Has effect only when saving to TIFF.
The default value is Lzw.
getTiffColorDepth/setTiffColorDepth
public int getTiffColorDepth() / public void setTiffColorDepth(int value)
Gets or sets bit depth to apply only when saving pages to the Tiff format.
The value of the property is ColorDepth integer constant.
Has effect only when saving to TIFF.
If TiffCompression is set to CCITT3, CCITT4, this will not take effect, the bit depth of the generated tiff image will be always 1.
getPrintingPage/setPrintingPage
public int getPrintingPage() / public void setPrintingPage(int value)
Indicates which pages will not be printed.
The value of the property is PrintingPageType integer constant.
getQuality/setQuality
public int getQuality() / public void setQuality(int value)
Gets or sets a value determining the quality of the generated images
to apply only when saving pages to the Jpeg format. The default value is 100
Has effect only when saving to JPEG.
The value must be between 0 and 100.
The default value is 100.
getImageType/setImageType
public int getImageType() / public void setImageType(int value)
Gets or sets the format of the generated images.
default value: PNG.
The value of the property is ImageType integer constant.
isCellAutoFit/setCellAutoFit
public boolean isCellAutoFit() / public void setCellAutoFit(boolean value)
public boolean getOnePagePerSheet() / public void setOnePagePerSheet(boolean value)
If OnePagePerSheet is true , all content of one sheet will output to only one page in result.
The paper size of pagesetup will be invalid, and the other settings of pagesetup
will still take effect.
public boolean getAllColumnsInOnePagePerSheet() / public void setAllColumnsInOnePagePerSheet(boolean value)
If AllColumnsInOnePagePerSheet is true , all column content of one sheet will output to only one page in result.
The width of paper size of pagesetup will be invalid, and the other settings of pagesetup
will still take effect.
Implements this interface to get DrawObject and Bound when rendering.
getChartImageType/setChartImageType
public com.aspose.cells.ImageFormat getChartImageType() / public void setChartImageType(com.aspose.cells.ImageFormat value)
Indicate the chart imagetype when converting.
default value: PNG.
NOTE: This member is now obsolete. Instead,
Chart and Shape are always rendered as vector elements(e.g. point, line) for rendering quality.
This property will be removed 12 months later since June 2022.
Aspose apologizes for any inconvenience you may have experienced.
getEmbededImageNameInSvg/setEmbededImageNameInSvg
public java.lang.String getEmbededImageNameInSvg() / public void setEmbededImageNameInSvg(java.lang.String value)
Indicate the filename of embedded image in svg.
This should be full path with directory like "c:\\xpsEmbedded"
getSVGFitToViewPort/setSVGFitToViewPort
public boolean getSVGFitToViewPort() / public void setSVGFitToViewPort(boolean value)
if this property is true, the generated svg will fit to view port.
getOnlyArea/setOnlyArea
public boolean getOnlyArea() / public void setOnlyArea(boolean value)
If this property is true , one Area will be output, and no scale will take effect.
getTransparent/setTransparent
public boolean getTransparent() / public void setTransparent(boolean value)
Indicates if the background of generated image should be transparent.
The default value is false. That means the background of the generated images is white.
public boolean isFontSubstitutionCharGranularity() / public void setFontSubstitutionCharGranularity(boolean value)
Indicates whether to only substitute the font of character when the cell font is not compatibility for it.
Default is false. We will try default font of Workbook and PdfSaveOption/system for cell font first.
getPageIndex/setPageIndex
public int getPageIndex() / public void setPageIndex(int value)
Gets or sets the 0-based index of the first page to save.
Default is 0.
getPageCount/setPageCount
public int getPageCount() / public void setPageCount(int value)
Gets or sets the number of pages to save.
Default is System.Int32.MaxValue which means all pages will be rendered.
isOptimized/setOptimized
public boolean isOptimized() / public void setOptimized(boolean value)
Indicates whether to optimize the output elements.
Default value is false. Currently only the border lines are optimized when this property is set to true.
getDefaultFont/setDefaultFont
public java.lang.String getDefaultFont() / public void setDefaultFont(java.lang.String value)
When characters in the Excel are Unicode and not be set with correct font in cell style,
They may appear as block in pdf,image.
Set the DefaultFont such as MingLiu or MS Gothic to show these characters.
If this property is not set, Aspose.Cells will use system default font to show these unicode characters.
public boolean getCheckWorkbookDefaultFont() / public void setCheckWorkbookDefaultFont(boolean value)
When characters in the Excel are Unicode and not be set with correct font in cell style,
They may appear as block in pdf,image.
Set this to true to try to use workbook's default font to show these characters first.
Default is true.
public boolean getOutputBlankPageWhenNothingToPrint() / public void setOutputBlankPageWhenNothingToPrint(boolean value)
Indicates whether to output a blank page when there is nothing to print.
Default is false.
getGridlineType/setGridlineType
public int getGridlineType() / public void setGridlineType(int value)
Gets or sets gridline type.
The value of the property is GridlineType integer constant.
Default is Dotted type.
getTextCrossType/setTextCrossType
public int getTextCrossType() / public void setTextCrossType(int value)
Gets or sets displaying text type when the text width is larger than cell width.
The value of the property is TextCrossType integer constant.
getDefaultEditLanguage/setDefaultEditLanguage
public int getDefaultEditLanguage() / public void setDefaultEditLanguage(int value)
Gets or sets default edit language.
The value of the property is DefaultEditLanguage integer constant.
It may display/render different layouts for text paragraph when different edit languages is set.
Default is DefaultEditLanguage.AUTO.
getSheetSet/setSheetSet
public SheetSetgetSheetSet() / public void setSheetSet(SheetSet value)
Gets or sets the sheets to render. Default is all visible sheets in the workbook: SheetSet.Visible.
The set is ignored when it is used in SheetRender
Method Detail
setDesiredSize
public void setDesiredSize(int desiredWidth, int desiredHeight)