Exporting Data to Excel

PhixFlow can export data to Excel automatically as part of an analysis model. We just need to tell it what data to use, what to call the file and where to send it.

Example

In this example we will send Invoice Report data to an Excel file and place this on our server.

You will need:

1. A table that holds your data, we will use a table called Invoice Stats.
2. Optionally a table that contains information about the file, such as the file name. 

Solution

  Image Added

Setting Specific Values in an Excel Template