SpreadsheetWatermarkHeaderFooterOptions
Inheritance: java.lang.Object, com.groupdocs.watermark.options.WatermarkOptions, com.groupdocs.watermark.options.SpreadsheetWatermarkOptions
public final class SpreadsheetWatermarkHeaderFooterOptions extends SpreadsheetWatermarkOptions
Represents options when adding the watermark to a Spreadsheet header/footer.
Learn more:
The following example demonstrates how to add a text watermark into Excel worksheet header.
SpreadsheetLoadOptions loadOptions = new SpreadsheetLoadOptions(); Watermarker watermarker = new Watermarker(“D:\test.xls”, loadOptions);
TextWatermark watermark = new TextWatermark(“Test”, new Font(“Arial”, 14));
SpreadsheetWatermarkHeaderFooterOptions options = new SpreadsheetWatermarkHeaderFooterOptions(); options.setWorksheetIndex(0);
watermarker.save(“D:\watermarked_test.xlsx”); watermarker.close();
Constructors
| Constructor | Description |
|---|---|
| SpreadsheetWatermarkHeaderFooterOptions() | Initializes a new instance of the [SpreadsheetWatermarkHeaderFooterOptions](../../com.groupdocs.watermark.options/spreadsheetwatermarkheaderfooteroptions) class. |
Methods
| Method | Description |
|---|---|
| getWorksheetIndex() | Gets the index of worksheet to add the watermark to. |
| setWorksheetIndex(int value) | Sets the index of worksheet to add the watermark to. |
SpreadsheetWatermarkHeaderFooterOptions()
public SpreadsheetWatermarkHeaderFooterOptions()
Initializes a new instance of the [SpreadsheetWatermarkHeaderFooterOptions](../../com.groupdocs.watermark.options/spreadsheetwatermarkheaderfooteroptions) class.
getWorksheetIndex()
public final int getWorksheetIndex()
Gets the index of worksheet to add the watermark to.
Returns: int - The index of worksheet to add the watermark to.
-1 means every worksheet.
setWorksheetIndex(int value)
public final void setWorksheetIndex(int value)
Sets the index of worksheet to add the watermark to.
Parameters:
| Parameter | Type | Description |
|---|---|---|
| value | int | The index of worksheet to add the watermark to. |
-1 means every worksheet. |