Jedox Office Add-in makes it possible to insert a named range of Jedox data from an Excel spreadsheet into a Word document or a PowerPoint presentation. It supports Word and PowerPoint Versions 2010 or later. Jedox Office Add-in uses the same language that is set for Jedox Excel Add-in.
By selecting Jedox in the menu bar of Word or PowerPoint you will get the following switches in the Jedox Ribbon:
Click Add and then select an Excel data file. Then click in the drop-down list for the named range you want to insert into your document. It is only possible to add content from one single XLSX source file. To add the selected name and close the dialog use the “Add” button. To add the selected name and continue with the dialog use the “Add and Next” button.
After the last insertion you can adjust the size and position of the placeholder(s).
The Update button in the Jedox Ribbon updates all placeholders in the current file.
To upgrade Jedox data from an Excel file using the Office Add-in, you have to set the Jedox Excel Add-in Settings to “Start automatically with Excel”. To do this, go to the Windows Start menu and enter “Jedox settings” in the search field, then open the resulting Jedox Excel Add-in Settings item.
By default, an absolute path to the source file is saved. However, you can manually change this to a relative path.
For example, if the source file is called “Office_Addin_Data.xlsx” and is located in the same folder as the Word/PowerPoint target file, you can set “.\Office_Addin_Data.xlsx“ as path.
- Display quality of placeholders:
For placeholders Jedox uses the “internal camera function” of Excel and the picture sizes depend only on the defined original ranges. For SUCCESS and other charts, you can receive a better display quality by increasing them in the Excel sheet. This solution doesn’t work for Excel cell based content.
- Update of Excel data:
The Excel workbook, which is used as data source in Office Add-in, must be saved with automatic calculation mode for formulas.
Jedox Office Add-in supports only one Excel source workbook per *.pptx / *.docx file. Technically it’s possible to add named ranges from several excel workbooks, but when updating only data from the last added workbook will be updated correctly.
- Updating of placeholders in Word:
In a Word file, updating of placeholders will reset the size to the original dimensions. If you want to manipulate a Jedox object in Word, you should first use the Update button.