3000AD Knowledge Base
Home » Categories » Multiple Categories

How do I use PDF-eXPLODE with Microsoft Excel?

ISSUE:
Microsoft Excel  worksheets do not have preset pagination like a Word document. The page formatting is generally done during the print stage. Where or how can I insert a PDF-eXPLODE tag so it appears on each page of the Excel report?


ANSWER:


Use one of the following alternative procedures to explode and send worksheets in an Excel workbook. The first procedure uses Excel's built-in page header feature but requires Excel 2007 if you want the PDF-eXPLODE tag to be hidden by changing the color to white. The second procedure offers a workaround that simulates a page header by repeating the top row of the worksheet on each page. This approach allows you to hide the PDF-eXPLODE tag by applying a white color in any version of Excel. The reason for offering both alternatives stems from the fact that while early versions of Excel allowed you to modify header and footer colors, the capability was removed beginning in Excel 4.0 and not replaced until Excel 2007.


Procedure A:

Using an Excel Page Header

  1. On the File menu, click Page Setup, and then click the Header/Footer tab.
  2. Now click Custom Header.
  3. In the Left Section, enter the PDF-eXPLODE tag, for example:  <pdfexplode>info@pdf-explode.com</pdfexplode>
  4. To add another PDF-eXPLODE tag, press enter to begin the tag on a new line.
  5. If you are using Excel 2007, you may select the tag and click the Format Text button to apply the color white, thereby making the tag invisible.
  6. Click OK twice.
  7. Repeat for each worksheet in the workbook.
  8. On the File menu, click Print.
  9. Set the printer to PDFeXPLODE.
  10. Use the Print what option to control which worksheets to explode. For example,  to explode and e-mail all worksheets in the workbook, select Entire workbook, and then click OK.

 

Procedure B:

Simulating a Page Header

  1. On the first row of a worksheet, enter the PDF-eXPLODE tag, for example:  <pdfexplode>info@pdf-explode.com</pdfexplode>
  2. To hide the tag, click the arrow next to the Font Color button on the Formatting toolbar, and then click the White color sample on the palette.
  3. To add another PDF-eXPLODE tag, enter it on the next row.
  4. On the File menu, click Page Setup, and then click the Sheet tab.
  5. To repeat the first row(s) on every page, use the Print titles option to select the Rows to repeat at top. For example, to repeat the first row the entry will be $1:$1. Finish by clicking OK.
  6. Repeat for each worksheet in the workbook.
  7. On the File menu, click Print.
  8. Set the printer to PDFeXPLODE.
  9. Use the Print what option to control which worksheets to explode. For example, to explode and e-mail all worksheets in the workbook, select Entire workbook, and then click OK



Comments Comments
There are no comments for this article. Be the first to post a comment.
Name
Email
Security Code Security Code

Subscribe to Knowledge Base

Get notified when new articles are added to the knowledge base.