SpreadsheetWatermarkHeaderFooterOptions Leave feedback

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:

• Add watermarks to spreadsheet documents

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();

public SpreadsheetWatermarkHeaderFooterOptions()

Initializes a new instance of the [SpreadsheetWatermarkHeaderFooterOptions](../../com.groupdocs.watermark.options/spreadsheetwatermarkheaderfooteroptions) class.

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.

public final void setWorksheetIndex(int value)

Sets the index of worksheet to add the watermark to.

Parameters:

-1 means every worksheet. |