Research Python libraries for core functions

[pearlescence-m]

Overview

I need to research Python libraries for core functions of the app so that developers would know which library to use to develop.

Action Items

Research Excel file reading packages in Python:

• [x] Preserving formatting
• [x] Importing charts
• [x] Transferring connections - Macros (Power Query - stretch)
  • [x] Generating dashboards with known UI from dataframes - programmatic/AI approaches
  • [x] Export dashboards in pdf

[pearlescence-m]

Research Excel file reading packages in Python

• Preserving formatting - openpyxl - copy each style argument
• Importing charts - win32com - getting excel ChartObjects.ChartType
• Transferring connections
  • win32com - run macro through Python or other tools
  • access M language script from Power Query and run with this CLI tool
• Generating dashboards with known UI from dataframes - pandas, plotly - get data the same way and do some kind mapping (excel table style -> pandas/matplotlib table styling, excel chart -> plotly chart)
• Export dashboards in pdf - plotly - static images to pdf