Index

Tutorial Videos

Tutorial videos are available here.

Knowledge Base

Visit our User Forum for discussions & solutions

IncludeSpreadsheet – XpressDox

Embed a spreadsheet into an assembled document

 

Using the IncludeSpreadsheet command, you can embed a spreadsheet into the assembled document.  This uses Microsoft’s OLE technology, which means that when you view the assembled document and double click on the spreadsheet, that spreadsheet will open in Excel. It can then be edited in Excel and the edited result is placed back into the document.

 

The command has the following syntax:

«IncludeSpreadsheet(HourlyRates.xlsx,8,6,1)»

 

The values of the parameters are the following:

  1. The name of the spreadsheet file.
  2. The width (in inches) which the spreadsheet image must occupy in the document.
  3. The height (in inches) of the spreadsheet image in the document.
  4. This is a “Size Adjuster”.  This applies when the spreadsheet is opened for editing.

 

The 2nd, 3rd and 4th parameters are optional and the examples above are the default values.  They will differ from one spreadsheet to another and normally require some trial-and-error to get right.

 

Note:

Use the Include rather than Insert version of this command if you know the name of the spreadsheet at the time of authoring the template.