Excel Node Export Tab

File name. Enter a filename or click the file chooser button to browse to the file's location. The default filename is excelexp.xlsx.

File type. The Excel .xlsx file format is supported.

Create new file. Creates a new Excel file.

Insert into existing file. Content is replaced beginning at the cell designated by the Start in cell field. Other cells in the spreadsheet are left with their original content.

Include field names. Specifies whether field names should be included in the first row of the worksheet.

Start in cell. The cell location used for the first export record (or first field name if Include field names is checked). Data are filled to the right and down from this initial cell.

Choose worksheet. Specifies the worksheet to which you want to export the data. You can identify the worksheet either by index or by name:

• By index. If you are creating a new file, specify a number from 0 to 9 to identify the worksheet to which you want to export, beginning with 0 for the first worksheet, 1 for the second worksheet, and so on. You can use values of 10 or higher only if a worksheet already exists at this position.
• By name. If you are creating a new file, specify the name used for the worksheet. If you are inserting into an existing file, the data are inserted into this worksheet if it exists, otherwise a new worksheet with this name is created.

Launch Excel. Specifies whether Excel is automatically launched on the exported file when the node is executed. Note that when running in distributed mode against IBM® SPSS® Modeler Server, the output is saved to the server file system, and Excel is launched on the Client with a copy of the exported file.

Generate an import node for this data. Select this option to automatically generate an Excel source node that will read the exported data file. See the topic Excel Source node for more information.