usmanazizgroupdocs
4/17/2017 - 10:11 AM

AddWatermarkTextAsBackgroundToExcel.vb

' For complete examples and data files, please go to https://github.com/groupdocs-watermark/GroupDocs.Watermark-for-.NET
Using doc As CellsDocument = Document.Load(Of CellsDocument)(Utilities.MapSourceFilePath(FilePath))
    Dim watermark As New TextWatermark(WatermarkText, New Font("Segoe UI", 19))
    watermark.HorizontalAlignment = HorizontalAlignment.Center
    watermark.VerticalAlignment = VerticalAlignment.Center
    watermark.RotateAngle = 45
    watermark.SizingType = SizingType.ScaleToParentDimensions
    watermark.ScaleFactor = 0.5
    watermark.Opacity = 0.5
    'set background width
    'set background height
    doc.Worksheets(0).AddWatermarkAsBackground(watermark, doc.Worksheets(0).ContentAreaWidthPx, doc.Worksheets(0).ContentAreaHeightPx)
    doc.Save()
End Using