Free Support Forum - aspose.com

Exclude page header while tiff conversion

Hi,

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

I am using aspose.cells (.NET) for processing excels documents.

I am using ImageOrPrintOptions object to customize tiff settings for saving document to tiff.

Is there any property to exclude or include following things while converting xls file to tiff

· page header

· page footer

· limiting pages (for example page range like 1 to 10)

· remove repeating columns

· remove repeating rows

Thanks,

Sarath

sarathsbvsp:


· page header

· page footer


Well, please check the topic on how to add/include headers on the worksheet pages:

http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/setting-headers-and-footers.html

To, remove the headers and footers, you need to use the following sample code:

//You can manually set the footers/headers blank.

worksheet.PageSetup.SetHeader(0, "");

worksheet.PageSetup.SetHeader(1, "");

worksheet.PageSetup.SetHeader(2, "");

//.................Set footers to blank similarly...


In short, you need to specify Worksheet.PageSetup options for Headers/Footers accordingly before taking Tiff images.



sarathsbvsp:

· limiting pages (for example page range like 1 to 10)

· remove repeating columns

· remove repeating rows


You need to set Printable Area for your desired range of cells, and for including repeating rows and columns, see the topic for your complete reference:
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/setting-print-options.html

To remove repeating rows/columns, similarly you need to set the relative options to null or blank, e.g
worksheet.PageSetup.PrintTitleRows = "";


Thank you.