Write To Excel Template (deprecated)

This node writes the input data table into an existing Excel file without changing its formatting.
Alternatively a new file will be created based on the template file formats and data. The input data will be written to the second row without header by default (can be changed in the Advanced Options) Already populated cells in the input file will be overwritten.
The node supports three formats chosen by file extension: XLS,XLSX,XLSM
This node is deprecated and a newer version can be found in the extension. Future changes will only be done in the newer node

Options

Template File Type

Select the file type of your template Excel. The same file type will be used for the optional output file.

Template File - Selected File

Enter a valid location where the template Excel is available. This file will be used as template - including the formatting and data. The required syntax of a path depends on the chosen file system, such as "C:\path\to\file" (Local File System on Windows) or "/path/to/file" (Local File System on Linux/MacOS and Mountpoint).

Template Sheet Name Selection

Select which sheet in the template file should be used. You can select the sheet by name or by the sheet index. by default the first sheet will be used.

Writing Options

Select if the template file should be overwritten orderedlist if a new file should be created. Note: If "Create new file" is selected - then you have to specify a output file

Output File - Selected File

Enter a valid location where the output file should be created. This file will be used as template - including the formatting and data. The required syntax of a path depends on the chosen file system, such as "C:\path\to\file" (Local File System on Windows) or "/path/to/file" (Local File System on Linux/MacOS and Mountpoint).

Output File - Overwrite Options

Select if the node should fail - if the new file already exists. Or if the existing file should be overwritten.

Write Options - Write column header

Select if the input table column headers should be written into the first row. By default no column header will be written.

Write Options - Do not write '=' cells as formulas

Select if string columns containing = should be escaped by ' so they are not interpreted as formulas.

Should all exising formulas be recalculated?

Select if you want to recalculate all existing formulas in your Excel file.

Offsets

Select on which row/column the writer should start. By default the input table will write from A2 till the last row of the input table. If you want to shift this by 2 rows and 1 column (so starting at C4): Starting row: 4 Starting column: 3 If you want to append the input table to the end of the template file, then select the "Write to last physical row" option

Template file password

If you template file is secured by a password. Then enter your Excel password here. The following password options are availible: No PWD needed = the file does not have an password and no password should be added to the output Open with PWD = file has an password and the password should be the same in the output Remove PWD = file has an password, but output should not be secured Change PWD = file has an password, but output should have a different password Add PWD = file has no password, but output should be secured

Views

This node has no views

Workflows

• AgedKNIME Hub
• Congruence_NewKNIME Hub
• exampleKNIME Forum
• IMAGE_TESTKNIME Forum
• JKI_032_Change_Structure_of_an_Excel_FileKNIME Hub
• kn_forum_38380_excel_re_evaluate_formulasKNIME Hub
• KNIME_projectKNIME Hub
• prova_templateKNIME Forum

Links

• Write to excel templateby HansS on 2023-05-12

  forum.knime.com/p/205820
• Using Cell Updater node to update XLSM file typeby AnotherFraudUser on 2023-01-17

  forum.knime.com/p/189592
• Node source code for EXCELby AnotherFraudUser on 2023-06-14

  forum.knime.com/p/212812

Developers