Here's what I usually do.
Create a new XLSX file or use an existing one.
Go into the 32-bit ODBC admin or click on New ODBC Connection from the Data Connections area in DataFlux.
Add a new User or System DSN, selecting the Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)
Point it to the spreadsheet from above and make sure you have "Read Only" UNchecked.
In your DataFlux job, use the Data Target (Insert) node:
Navigate to select the Data connection.
Select the new connection you created above.
Click on it and click the green plus + to create a new output tab name.
Make sure "Delete Existing Rows" is UNchecked in your Insert node.
Running your job should automatically create a new Tab and Named Range in your spreadsheet.
Also, I don't think Excel allows the job to automatically delete or alter the data or range (hence my final bullet point above), so I always clear our my data before each run, either programmatically in DF or manually.
... View more
