When saving a Workbook as a PDF - is it possible to customize the pages as they are being generated, so a stamp or watermark can be added in the margin areas of the page?
The ideal would be a way to apply Aspose.Pdf’s TextStamp as the pages are being rendered, customizing each page with a different content.
Watermarking as described here: Add WordArt Watermark to Worksheet|Documentation does not meet the requirements, since that belongs to the spreadsheet content and is not printed in the margin area of the printed version.
Thank you in advance.
@malbanesiascii,
Thank you for your query.
You may set the desired custom page (page size, margins etc.) in PageSetup for the worksheet via Aspose.Cells. This is the only thing that can be done via Aspose.Cells and MS Excel before rendering the Excel file to PDF file format. You may also customize the page using Aspose.PDF API again and add the desired stamp and watermark at the desired location.
I am afraid no option is available to render the watermark in the margin area. However, if you can perform this task using MS Excel, please share the steps with us. We will try to provide you with assistance to perform the same task using Aspose.Cells.
There’s no way to do this on MS Excel. I used Aspose.Cells to do this.
Thank you Ahsan
@malbanesiascii,
Please note that Aspose.Cells mimics the behavior of MS Excel and if some task cannot be performed using MS Excel then it cannot be accomplished using Aspose.Cells also. Please feel free to write us back if you have any other query related to Aspose.Cells.