Tag: excel

Integrating Jedox Reports from Excel to PowerPoint

January 26, 2024January 26, 2024 by Jedox 4 BeginnersNo Comments

In this guide, we’ll walk you through the steps to integrate Jedox reports from Excel into PowerPoint presentations, allowing for dynamic and effortless updates. Step 1: Creating a Paste View with the Jedox Add-in for Excel Rescently, Jedox released a new Excel 365 Add-in which allows you to read and analyze data from your Jedox instance and store values and comments to the Jedox In-Memory Database while using Excel 365 desktop or browser, without requiring local installation, simplifying deployment and access to the latest features. So to begin, open Excel and ensure you have the Jedox Add-in installed. If you haven’t already installed it, you can find detailed instructions on how to do so here. Once the add-in is installed, navigate to the data you want to include in your PowerPoint presentation. With the Jedox Add-in, you can easily create a Paste View by selecting the desired area of your spreadsheet. This Paste View serves as a snapshot of your data that can...

Excel download using macro

January 2, 2022June 28, 2023 by Jedox 4 Beginners2 Comments

Here is one quick way to download a file as an Excel. In normal conditions, Jedox offers two possibilities to Export to Excel: XLSX Snapshot XLSX OLAP Snapshot More about differences can be found here. Sometimes, we want to limit end users from seeing these buttons. That can be done in this way [see bellow] by clicking on report properties and unchecking Interface checkboxes. Now, when the report does not contain anything related to Jedox bars we can install the macro for exporting. The code behind the macro is very simple: return array ( array('actn', "exportToXLSX",2), ); The final output looks like this: The whole project can be downloaded from here. ...