Copy Excel sheet or file

You can duplicate a sheet before or after running the SQL (eg. using another sheet as template) or you can save selected sheets in separate Excel workbooks (eg. as backup or for distribution of data).

Overview

The settings for copy Excel sheets or files are easily accessible by pressing the "Create Excel file/sheet" button. It offers 2 basic functionalities:

  • Create a new workbook with one or more sheets from the current workbook. 
  • Copy a sheet within the current workbook (giving the new sheet a different name).

 

 

Note that multiple sheet may be copied to a new workbook if more sheet names are provided (separated with a comma ",").