Tips and Tricks : How to Create and Read an Excel File with Altair Flux ?

Overview

As engineers, we often like to provide data using tables from Excel. With Altair Flux, you may want to compute the efficiency of electric motors. In this case, it can be interesting to build a table with all losses to create the power balance sheet.

What we propose here is an example of a script, that can be run from Altair Flux to generate an Excel file and then read it. These examples are based on the POI library from Apache in Python, which has been embedded inside Flux.

The first script will create an Excel file (see image). 1_Create_Excel_File_From_Flux_POI_Out_2.py 

The second script will open this Excel file and display values in the Flux console (see image 2) 2_Read_Excel_File_From_Flux_POI_Out_2.py 

Et voilà !

Usage/Installation Instructions

Follow the next steps:

1. Download the 2 script files.

2. Open a Flux project.

3. Select [Project] [Command File] [Run a python file...].

4. Select one of the downloaded files.