Using First Sheet and All Sheets with CSV and TXT Outputs in the Jet Scheduler

This article addresses how to use the All Sheets and First Sheet options when using the CSV or TXT output formats in the Jet Scheduler. This functionality is only available in Jet Reports 20.4 and later.

Using CSV Files

When setting the output format as a CSV file the following options are available in the Sheet dropdown list:

• First Sheet: This will take only the values on the first sheet and output them into a single CSV file in the location specified. If there are hidden sheets in the workbook they will be removed and the next sheet will be considered the first sheet.
• All Sheets: This will take all sheets in the workbook and output a separate CSV file for each sheet. The format of the output in this scenario will be '[workbook filename] - [sheet name].csv'

Using TXT Files

When setting the output format as a TXT file the following options are available in the Sheet dropdown list:

• First Sheet: This will take only the values on the first sheet and output them into a single TXT file in the location specified. If there are hidden sheets in the workbook they will be removed and the next sheet will be considered the first sheet.
• All Sheets: This will take all sheets in the workbook and output a separate TXT file for each sheet. The format of the output in this scenario will be '[workbook filename] - [sheet name].txt'