Free Support Forum - aspose.com

How to convert excel to PDF and jpeg images with all the content in excel sheet irrespective of print area?

How to convert to PDF and jpeg images with all the content in excel sheet even though the sheet is set with custom print area. Means somehow we need to identify the content (row wise and column wise) of the sheet and convert to PDF and Images. Help me to resolve this issue.

Thanks in advance.

@satishvertex,

Thanks for your query.

Well, you remove the print area of the sheet dynamically using Aspose.Cells APIs before rendering to PDF or image file(s), see the sample lines of code for your referfence:
e.g
Sample code:

........
Worksheet sheet = workbook.Worksheets[0];
sheet.PageSetup.PrintArea = "";

Hope, this helps a bit.