2024-10-21 Andrew Jackson
Based on https://hub.knime.com/tommy/spaces/Public/Excel%20Table%20Writer~EnxXLRACyo7A_tGI/current-state
Some Python code was modified to suit.
Description:
This component takes an existing Excel spreadsheet file and creates an Excel "Table" in the nominated sheet.Opening the excel file and "Select all" -> "Insert" -> "Table" is not necessary anymore.
This component uses the Python Integration and refers to the openpyxl package. This has to be installed prior to executing the node.
First input (variable)
Filename should be a string (not a Path)
Sheetname should be a string containing the name of the sheet in Excel where the data exists.
Tablename should be a string containing the desired name of the table that will be created
Second input (table)
This should contain the same data as was written to the sheet in the Excel spreadsheet, so that the number of rows and columns can be extracted.
Based on https://hub.knime.com/tommy/spaces/Public/Excel%20Table%20Writer~EnxXLRACyo7A_tGI/current-state
Some Python code was modified to suit.
Description:
This component takes an existing Excel spreadsheet file and creates an Excel "Table" in the nominated sheet.Opening the excel file and "Select all" -> "Insert" -> "Table" is not necessary anymore.
This component uses the Python Integration and refers to the openpyxl package. This has to be installed prior to executing the node.
First input (variable)
Filename should be a string (not a Path)
Sheetname should be a string containing the name of the sheet in Excel where the data exists.
Tablename should be a string containing the desired name of the table that will be created
Second input (table)
This should contain the same data as was written to the sheet in the Excel spreadsheet, so that the number of rows and columns can be extracted.