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
. |
SpreadsheetWatermarkableImage |
getBackgroundImage()
Gets the background image of this
. |
SpreadsheetChartCollection |
getCharts()
Gets the collection of all charts of this
. |
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
. |
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
. |
void |
setBackgroundImage(SpreadsheetWatermarkableImage value)
Sets the background image of this
. |
findImages, findImages, search, search
public final SpreadsheetPageSetup getPageSetup()
SpreadsheetWorksheet
.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()
SpreadsheetWorksheet
.SpreadsheetWorksheet
.public final SpreadsheetAttachmentCollection getAttachments()
SpreadsheetWorksheet
.SpreadsheetWorksheet
.public final SpreadsheetChartCollection getCharts()
SpreadsheetWorksheet
.SpreadsheetWorksheet
.public final SpreadsheetWatermarkableImage getBackgroundImage()
SpreadsheetWorksheet
.SpreadsheetWorksheet
or null
if the worksheet has no background image.public final void setBackgroundImage(SpreadsheetWatermarkableImage value)
SpreadsheetWorksheet
.value
- The background image of this SpreadsheetWorksheet
or null
if the background image should be removed.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.