Jan 20, 2021 - 01:29 PM
Excel can be used as a data source, which will load Excel columns and rows into your underlying database as a table. When the data changes in the Excel file the table, and therefore the charts, will also be updated.
This functionality works with SQL Server, MySQL and MariaDB. For other databases, or non-Excel data, you will need to manually load the file into a table.
Your Excel file:
· Should be in .xlsx format
· Needs to ‘look’ like a database table, i.e., simple rows and columns of data
· Whilst it could contain totals and subtotals this isn’t a good idea as they would need to be identified and excluded, i.e., filtered, to stop the data doubling, or trebling up.
For more information please take a look at Excel as a data source - piDocumentation - piDocuments (atlassian.net)