Icon

kn_​forum_​43376_​excel_​sheet_​names_​as_​column

Read the sheet names from an existing excel file and add the sheet name as a column and write to a new excel file
OUTER LOOP just create the dummy data excel files Read the sheet names from an existing excel file and add the sheet name as a column and write to a new excel file INNER LOOP createDummy DataSTART createExcel Filewith 4 sheetscreate"my_file.xlsx"with 4 Sheetscontrol Sheet name with variable"var_sheet_name"END createExcel Filewith 4 sheetslistExcel Filesfrom/data/ folderthat start with the Name" my_file.xlsx"read theexcel filesextractFile NamesSTARTOUTER LOOPto writeto ExcelFilemy_target_file.xlsxSheet Name controlled byVariableENDINNER LOOPcreate the sheet namevar_sheet_namecreate theExcel File Names"<..>_new.xlsx" read theexcelsheet namesvar_new_excel_fileSTARTINNER LOOPto writeto single excelFilesheet_name=> apply the Sheet names ascolumnENDOUTER LOOPdeletemy_file.xlsxto make sure you have a clean start Data Generator Group Loop Start Excel Writer Variable Loop End List Files/Folders Excel Reader Path to URI URL to File Path Table Row ToVariable Loop Start Excel Writer Variable Loop End Java EditVariable (simple) Create File/FolderVariables Read ExcelSheet Names Java EditVariable (simple) Table Row ToVariable Loop Start ConstantValue Column Loop End Delete originalxlsx file Delete targetxlsx file OUTER LOOP just create the dummy data excel files Read the sheet names from an existing excel file and add the sheet name as a column and write to a new excel file INNER LOOP createDummy DataSTART createExcel Filewith 4 sheetscreate"my_file.xlsx"with 4 Sheetscontrol Sheet name with variable"var_sheet_name"END createExcel Filewith 4 sheetslistExcel Filesfrom/data/ folderthat start with the Name" my_file.xlsx"read theexcel filesextractFile NamesSTARTOUTER LOOPto writeto ExcelFilemy_target_file.xlsxSheet Name controlled byVariableENDINNER LOOPcreate the sheet namevar_sheet_namecreate theExcel File Names"<..>_new.xlsx" read theexcelsheet namesvar_new_excel_fileSTARTINNER LOOPto writeto single excelFilesheet_name=> apply the Sheet names ascolumnENDOUTER LOOPdeletemy_file.xlsxto make sure you have a clean start Data Generator Group Loop Start Excel Writer Variable Loop End List Files/Folders Excel Reader Path to URI URL to File Path Table Row ToVariable Loop Start Excel Writer Variable Loop End Java EditVariable (simple) Create File/FolderVariables Read ExcelSheet Names Java EditVariable (simple) Table Row ToVariable Loop Start ConstantValue Column Loop End Delete originalxlsx file Delete targetxlsx file

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: m_lauber
Created at: 2022-05-10
On NodePit since: 2022-05-24
Last update: 2024-04-27
Created with KNIME version: v4.5.2
Tags: excelimportsheetlistfiles

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!