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)