XLSX Files

Importing XLSX files

It is possible in Jedox Web to import XLSX files, either as static files or in a Jedox workbook (WSS file). The XLSX file type is the only file format besides .wss that can be imported into a Jedox workbook. You can also create XLSX files with earlier versions of Excel if you have installed the free Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint. 

To import an XLSX file into a Jedox workbook, select “File – Import…” in an open Jedox worksheet.

Note 1:
Only XLSX files can be imported using the “File – Import…” command in Jedox Web.

Note 2:
With the command “Auto Format” (Excel 2003) or
“Format as Table” (Excel 2007/2010/2013) awarded formats are not supported.

Exporting XLSX files

Under “File – Export” you also have the option of exporting Jedox Spreadsheets as XLSX files (with formulas), as XLSX Snapshots (with actual values but no formulas) or as XLSX OLAP Snapshots (only Palo formulas are replaced with values, other spreadsheet formulas are kept as formulas). For more information on Snapshots in Jedox, click here.

The form elements (Checkboxes, Comboboxes etc.) are included in all XLSX exports.

As of Jedox 7.0 you can exclude form elements in XLSX, XLSX snapshot and XLSX OLAP snapshot exports.
For this you must add an entry in the file <JEDOX_INSTALL_PATH>\core\ooxml_config.xml  within the root node (parallel to <pattern_fills> and <font_fallbacks>) like the following:

   <export_exclude export_type="snapshot" object_type="worksheet_element" object_subtype="formel"/>

For the ‘export type’ entry are supported:
"xlsx" – for standard export
"xlsx_snapshot" – for standard snapshot export
"xlsx_olap_snapshot" – for olap snapshot export
"snapshot" = ‘xlsx_snapshot’|’xlsx_olap_snapshot’ – combo for all snapshot exports.

For the ‘object_type’ entry is only "worksheet_element" supported.

For the ‘object_subtype’ entry are supported:
"formel" – to filter out form elements
"dchart" – to filter out dynamic charts
"hchart" – to filter out success charts
"chart" – to filter out classic charts
"img" – to filter out images
"paloview" – to filter out palo paste view
"page_setup" – to filter out page setup
"panescnf" – to filter out split or frozen pane.

Note 1:
When exporting as an XLSX file, Jedox content and functions that are not supported by Excel will be lost. For example, the hyperlink formula of Excel supports only 2 arguments (hyperlink destination and friendlyname), whereas Jedox supports many more (see Hyperlink Function). Any existing Jedox data transfer arguments will not be saved in the XLSX file.
As Excel doesn’t support direct usage of array formulas in list boxes, comboboxes which reference a subset are not exported. As workaround, it is possible to use in the combobox a named range as reference. This reference points to a subset on the spreadsheet.

Note 2:
As of Excel 2010, Microsoft has implemented its own support for Sparklines. From this version on, it is possible to exchange definitions of Micro Charts (Jedox Web) and Sparklines (Excel 2010 or newer). However, Micro Charts are implemented differently in Jedox spreadsheets than in Excel spreadsheets, and therefore not all properties can be converted during export/import processes.

Note 3:
When exporting reports to Excel, only the DynaRanges on the first sheet of the report will be calculated. When using Batch XLSX Snapshot, however, all DynaRanges on all sheets will be calculated.