XLSX Files


Importing XLSX files

You can import XLSX files in Jedox Web, 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 File > Import… in Jedox Web.

Note 2:
With Auto Format (Excel 2003) or Format as Table (Excel 2007/2010/2013) custom formats are not supported.

Exporting XLSX files

Under File > Export you can export 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 ...\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 a workaround, it is possible to use in the combobox a named range as a 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.