Skip to content

Elements of Report Files

A typical aPriori spreadsheet report consists of the following elements:

  • an XML (.xml) file that defines the data to be extracted from aPriori.
  • an optional Excel template file (.xls or .xlsx or .xlsm) that defines how the data should be formatted.
  • an Excel output file containing the extracted data (the report).

If no Excel template file exists, then the data is dumped into the Excel output file with no formatting. For small reports, this may be sufficient but it’s likely you need to format the data by using a template file to make the report usable.

  • You can format your spreadsheet report with Excel PivotTables® for advanced formatting.
  • You can choose not to create a spreadsheet at all and instead dump out your data into a CSV (comma-separated values) file or an XML file.

The data that you can extract from aPriori generally variables that are defined as part of the aPriori defined by a Digital Factory creator as a custom output.