public class SpreadsheetWorksheet extends ContentPart
Represents an Excel document worksheet.
Modifier and Type | Method and Description |
---|---|
SpreadsheetAttachmentCollection |
getAttachments()
Gets the collection of all attachments of this
SpreadsheetWorksheet . |
SpreadsheetWatermarkableImage |
getBackgroundImage()
Gets the background image of this
SpreadsheetWorksheet . |
SpreadsheetChartCollection |
getCharts()
Gets the collection of all charts of this
SpreadsheetWorksheet . |
double |
getColumnWidth(int column)
Gets the width of the specified column in points.
|
int |
getColumnWidthPx(int column)
Gets the width of the specified column in pixels.
|
double |
getContentAreaHeight()
Gets the height of the content area in points.
|
int |
getContentAreaHeightPx()
Gets the height of the content area in pixels.
|
double |
getContentAreaWidth()
Gets the width of the content area in points.
|
int |
getContentAreaWidthPx()
Gets the width of the content area in pixels.
|
SpreadsheetHeaderFooterCollection |
getHeadersFooters()
Gets the collection of worksheet headers and footers.
|
SpreadsheetPageSetup |
getPageSetup()
Gets the printing page setup for this
SpreadsheetWorksheet . |
double |
getRowHeight(int row)
Gets the height of the specified row in points.
|
int |
getRowHeightPx(int row)
Gets the height of the specified row in pixels.
|
SpreadsheetShapeCollection |
getShapes()
Gets the collection of all shapes of this
SpreadsheetWorksheet . |
void |
setBackgroundImage(SpreadsheetWatermarkableImage value)
Sets the background image of this
SpreadsheetWorksheet . |
findImages, findImages, search, search
public final SpreadsheetPageSetup getPageSetup()
Gets the printing page setup for this SpreadsheetWorksheet
.
public final double getContentAreaWidth()
Gets the width of the content area in points.
public final int getContentAreaWidthPx()
Gets the width of the content area in pixels.
public final double getContentAreaHeight()
Gets the height of the content area in points.
public final int getContentAreaHeightPx()
Gets the height of the content area in pixels.
public final SpreadsheetShapeCollection getShapes()
Gets the collection of all shapes of this SpreadsheetWorksheet
.
SpreadsheetWorksheet
.public final SpreadsheetAttachmentCollection getAttachments()
Gets the collection of all attachments of this SpreadsheetWorksheet
.
SpreadsheetWorksheet
.public final SpreadsheetChartCollection getCharts()
Gets the collection of all charts of this SpreadsheetWorksheet
.
SpreadsheetWorksheet
.public final SpreadsheetWatermarkableImage getBackgroundImage()
Gets the background image of this SpreadsheetWorksheet
.
SpreadsheetWorksheet
.
Returns null if the worksheet has no background image.public final void setBackgroundImage(SpreadsheetWatermarkableImage value)
Sets the background image of this SpreadsheetWorksheet
.
value
- The background image of this SpreadsheetWorksheet
.
Returns null if the worksheet has no background image.public final SpreadsheetHeaderFooterCollection getHeadersFooters()
Gets the collection of worksheet headers and footers.
public final double getColumnWidth(int column)
Gets the width of the specified column in points.
column
- The column index.public final int getColumnWidthPx(int column)
Gets the width of the specified column in pixels.
column
- The column index.public final double getRowHeight(int row)
Gets the height of the specified row in points.
row
- The row index.public final int getRowHeightPx(int row)
Gets the height of the specified row in pixels.
row
- The row index.Copyright © 2020. All rights reserved.