Tips and Tricks : How to Create and Read an Excel File with Altair Flux ?
Altair EmployeeOverview
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.
Find more posts tagged with
Comments
- from the tree, select [Post-processing] [Curve] [2D Curve (I/O Parameter] [name of the curve]
- right click and select [excel export] in the menu
- give a name for the excel file to be created and click on [OK] button
Altair EmployeePlease, how to extract the Excel file for the Flux project?
Hi,
After you have displayed a curve, you can follow the next steps to put the result in an Excel file:
If you are interested in having the main characteristics of your Flux project, you should load ([Project] [Macro] [Load]) and run the macro called [Automatic Report]. The result will be in html or txt format.
I hope it will help
Please, how to extract the Excel file for the Flux project?