Session 1: Macros
Lesson 9 – Writing to a spreadsheet cell

Online Course Thumbnail

What will you learn:

  • Working with the application object

  • Adding a value to a cell via a macro


Welcome to the Jedox Report Designer course which covers the Professional and Expert-level curriculum (300 and 400-level courses) as outlined by the Jedox Academy. Here you will learn how to use Jedox for your company’s business intelligence and corporate performance management needs with guidance provided by the Head of Academy, Thomas Arampatzis, and the Online Education Consultant, Sabrina Sebens.

This session addresses more in-depth concepts and use cases regarding Jedox’s advanced spreadsheet capabilities. In this video, we show you how to get your macro to interact with a spreadsheet. A very common use case involves writing a result into a cell, which we demonstrate. The application object is the link between the PHP code and the spreadsheet.

  • Course Type

    Jedox Report Designer

  • Duration

    04:39 min
  • Language


  • Speaker

    Thomas Arampatzis
    Sabrina Sebens

Learn More

Get familiar with Jedox as a platform by watching our Platform Basics course, where you can learn how to create ad-hoc reports, customized reports, and set up data models among other things. Don’t forget that you can try out Jedox for yourself for free with a 14-day Cloud trial or for 30 days with a standard trial, and check out the Jedox Blog for some great practical examples and our user documentation resource at the Jedox Knowledge Base.

Back to Overview