Get DrawObject and Bound while rendering to PDF using DrawObjectEventHandler class

Possible Usage Scenarios

Aspose.Cells provides an abstract class DrawObjectEventHandler which has a Draw() method. The user can implement DrawObjectEventHandler and utilize the Draw() method to get the DrawObject and bound while rendering Excel to PDF or image. Here is a brief description of the parameters of the Draw() method.

If you are rendering an Excel file to PDF, you can utilize the DrawObjectEventHandler class with PdfSaveOptions.DrawObjectEventHandler. Similarly, if you are rendering an Excel file to an image, you can utilize the DrawObjectEventHandler class with ImageOrPrintOptions.DrawObjectEventHandler.

Get DrawObject and Bound while rendering to PDF using DrawObjectEventHandler class

Please see the following sample code. It loads the sample Excel file and saves it as output PDF. While rendering to PDF, it utilizes PdfSaveOptions.DrawObjectEventHandler property and captures the DrawObject and bound of existing cells and objects, e.g., images, etc. If the DrawObject type is Cell, it prints its bound and string value. If the DrawObject type is Image, it prints its bound and shape name. Please see the console output of the sample code given below for more help.

Sample Code

Console Output

[X]: 153.6035 [Y]: 82.94118 [Width]: 103.2035 [Height]: 14.47059 [Cell Value]: This is sample text.

----------------------

[X]: 267.6917 [Y]: 153.4853 [Width]: 160.4491 [Height]: 128.0647 [Shape Name]: Sun

----------------------

Create PdfBookmarkEntry for Chart Sheet Ignore Errors while Rendering Excel to PDF