Excel generates huge output PDF

Nov 21, 2016 at 10:46 AM
Edited Nov 21, 2016 at 10:48 AM
Hi Cognidox,

We have been using OfficeToPDF in production for quite a while now and it works great for us. A problem has been popping up frequently however that has become problematic. An excel with little data generating huge PDF files with thousands of pages. 99% of these pages are just emty rows and columns.

An example Excel file that does this is this one: https://dl.dropboxusercontent.com/u/16476289/very_large_print.xlsx

Is there any way we can change our usage of OfficeToPDF to prevent the output PDF containing lots of empty rows and columns?
Or is this behavior normal because there is something wrong with the Excel perhaps?

Thanks for your awesome work,

Pieter
Coordinator
Nov 22, 2016 at 3:18 PM
Hi Pieter

Looking at the provided spreadsheet, the full range of the first worksheet is A1:XDN181. OfficeToPDF will be using this range to produce the PDF, hence the large resulting PDF.

What you should do is set a print-range in the worksheet to limit the resulting PDF to just the range you need.

Regards
Vittal
Marked as answer by cognidox on 8/18/2017 at 3:54 AM