Excel – Create PDF from an Excel file without white margins

For image-based watermarks, there are several tools that promise their automatic removal. For example:

• We PDF Watermark Remover
• PDF Watermark Remover
• SoftOrbits PDF Logo Remover

All of these are free to try, but require a license to actually produce the desired output.

However, the watermark of this specific PDF file (which the OP sent me via email) isn't a single image that is repeated on all pages. As it turns out, PDFCreator hardcoded it (almost pixel by pixel) into every single one of them. This makes the watermark much more difficult to remove (and results in a rather bloated PDF file).

Since the watermark is actually composed of many tiny images, you can remove them with a PDF editor (e.g., Foxit Advanced PDF Editor), simply by selecting them and pressing Delete. Unfortunately, you have to repeat this for every page.

A less time-consuming solution would be to remove the watermark programmatically. We need:

• Pdftk: a tool to (un)compress and fix PDF streams.
• Notepad++: a text editor capable of replacing Perl Compatible Regular Expressions.

Steps

1. Download Pdftk and extract pdftk.exe and libiconv2.dll to %windir%\System32, a directory in the path or any other location of your choice.

2. Download and install Notepad++.

3. PDF streams are usually compressed using the DEFLATE algorithm. This saves space, but it makes the PDF's source illegible.

   The command

   pdftk original.pdf output uncompressed.pdf uncompress
   

   uncompresses all streams, so they can be modified by a text editor.

4. Open uncompressed.pdf with Notepad++ to reveal the structure of the watermark.

   In this specific case, every page begins with the block

   q 9 0 0 9 2997 4118.67 cm
   BI
   /CS/RGB
   /W 1
   /H 1
   /BPC 8
   ID Ÿ®¼
   EI Q
   

   and nearly 4,000 blocks just like this one. This particular block sets only one (/W 1 /H 1) of the watermark's pixels.

   Scrolling down until the pattern changes reveals that the watermark's stream is 95,906 bytes long (counting newlines). The exact same stream is repeated on every page of the PDF file.

5. Press Ctrl + H and set the following:

   Find:               q 9 0 0 9 2997 4118\.67 cm.{95881}
   Replace:            (blank)
   Match case:         checked
   Wrap around:        checked
   Regular expression: selected
   . matches newline:  checked
   

   The regular expression q 9 0 0 9 2997 4118\.67 cm.{95881} matches the first line of the above block (q 9 0 0 9 2997 4118.67 cm) and all following 95,881 characters, i.e., the watermark's stream.

   Clicking Replace All removes it from all pages of the PDF file.

6. The watermark has now been removed, but the PDF file has errors (the streams' lengths are incorrect) and it's uncompressed.

   The command

   pdftk uncompressed.pdf output nowatermark.pdf compress
   

   takes care of both.

7. uncompressed.pdf is no longer needed. You can delete it.

The result is the same PDF without the watermark (and about half the size).

pdfjam does nup-imposition and gives you the complete power of pdfpages; I'm sure you can trim the pages while imposing them. It needs a working TeX-installation, though.