Watermark for excel file

Aspose.Cells Product Family
1

Hi,
I want add watermark to Excel file for custom page, I tried but after applying watermark in resulted file it is in Box and editable ever after setting shape.IsLocked = true; so please give me code how to achieve watermark configuration i have attached sample excel that how i want to add watermark.
and also for pdf im setting this things
private TextStamp GetStampDetails(WaterMarkDetails waterMarkdDtails)
{
TextStamp stamp = new TextStamp(waterMarkdDtails.WatermarkText);

 if (!string.IsNullOrWhiteSpace(waterMarkdDtails.Background))
 {
     bool isBool = bool.TryParse(waterMarkdDtails.Background, out isBool);
     if (isBool)
     {
         stamp.Background = Convert.ToBoolean(waterMarkdDtails.Background);
     }
 }
 if (waterMarkdDtails.OpacityParsed != null)
 {
     stamp.Opacity = Convert.ToDouble(waterMarkdDtails.OpacityParsed);
 }
 if (waterMarkdDtails.RotateAngleParsed != null) stamp.RotateAngle = Convert.ToDouble(waterMarkdDtails.RotateAngleParsed);
 if (waterMarkdDtails.XIndentParsed != null) stamp.XIndent = Convert.ToDouble(waterMarkdDtails.XIndentParsed);
 if (waterMarkdDtails.YIndentParsed != null) stamp.YIndent = Convert.ToDouble(waterMarkdDtails.YIndentParsed);
 if (waterMarkdDtails.ZoomParsed != null) stamp.Zoom = Convert.ToDouble(waterMarkdDtails.ZoomParsed);
 if (waterMarkdDtails.FontParsed != null) stamp.TextState.Font = waterMarkdDtails.FontParsed;
 if (waterMarkdDtails.FontSizeParsed != null) stamp.TextState.FontSize = (float)waterMarkdDtails.FontSizeParsed;
 if (waterMarkdDtails.FontStyleParsed != null) stamp.TextState.FontStyle = (FontStyles)waterMarkdDtails.FontStyleParsed;
 if (waterMarkdDtails.ForegroundColorParsed != null) stamp.TextState.ForegroundColor = waterMarkdDtails.ForegroundColorParsed;
 if (waterMarkdDtails.BackgroundColorParsed != null) stamp.TextState.BackgroundColor = waterMarkdDtails.BackgroundColorParsed;
 stamp.HorizontalAlignment = waterMarkdDtails.HorizontalAlignmentparsed;
 stamp.VerticalAlignment = waterMarkdDtails.VerticalAlignmentparsed;
 return stamp;

} please give same with excel.

excelfile.zip (20.7 KB)

2

@Darshan06
A background image was inserted to the sheet in the template file.
Please check document : Insert Background Image to Excel|Documentation

3

@Darshan06,

The Excel file you provided has background image set for the worksheet. That’s why we suggested you refer to the document with example code: Insert Background Image to Excel|Documentation to accomplish the task. If you need to set word art watermark (text effects), you may do it easily via Aspose.Cells APIs. See the documents on how to add and format word-art watermarks to the worksheet for your complete reference.
Add WordArt Watermark to Worksheet|Documentation
Add WordArt Watermark to Worksheet in Aspose.Cells|Documentation
Locking WordArt Watermark|Documentation
Set preset WordArt style to the text of the shape|Documentation

In case you find any issue or want something else, please provide a sample Excel file containing a worksheet with your desired watermark set. We will check it soon.