Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Using First Sheetand All Sheetswith CSV and TXT outputs in the Jet Scheduler

Overview

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

Select the sheet option for CSV or TXT outputs

  1. On the Jet ribbon, clickSchedule. TheScheduled Taskswindow opens.

  2. Create a new scheduled task, or open an existing one.

  3. On the Reports tab, select either CSV or TXT as theFormat. TheSheetdrop-down list appears.

  4. SelectFirst Sheetfrom theSheetdrop-down list. This option will take only the values on the first sheet and output them into a single file in the specified location. If there are hidden sheets in the workbook, they will be removed and the next sheet will be considered the first sheet.The optionAll Sheetswill become available in the future.This option takes all sheets in the workbook and outputs a separate file for each sheet. The format of the output filename in this scenario will be '[workbook filename] - [sheet name].[extension]'

Published:

Using First Sheetand All Sheetswith CSV and TXT outputs in the Jet Scheduler

Overview

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

Select the sheet option for CSV or TXT outputs

  1. On the Jet ribbon, clickSchedule. TheScheduled Taskswindow opens.

  2. Create a new scheduled task, or open an existing one.

  3. On the Reports tab, select either CSV or TXT as theFormat. TheSheetdrop-down list appears.

  4. SelectFirst Sheetfrom theSheetdrop-down list. This option will take only the values on the first sheet and output them into a single file in the specified location. If there are hidden sheets in the workbook, they will be removed and the next sheet will be considered the first sheet.The optionAll Sheetswill become available in the future.This option takes all sheets in the workbook and outputs a separate file for each sheet. The format of the output filename in this scenario will be '[workbook filename] - [sheet name].[extension]'

For an optimal Community experience, Please view on Desktop