Icon

kn_​forum_​42140_​excel_​continental_​nodes_​complex_​header

create an Excel file with a complex header with the help of Continental Excel nodes

create an Excel file with a complex header with the help of Continental Excel nodes

create an Excel file with a complex header with the help of Continental Excel nodesbased on https://kni.me/w/hRM4Db1vakNNNuMD (by https://hub.knime.com/kathrin)=> install Continental extensions first! Add HeaderAdd Empty RowData TableDefine formattinginformationswrite initial table/data/test.xlsxWith unpivot option to get one row per cell Assing tagvalues based on row and column numberTransformback into originaltable formapply styles to a new filetest_applied.xlsx Table Creator Add Empty Rows Extract revenueper CW Concatenate XLS Formatting Excel Writer XLS ControlTable Generator Rule Engine XLS ControlTable Generator XLS Formatter(apply) create an Excel file with a complex header with the help of Continental Excel nodesbased on https://kni.me/w/hRM4Db1vakNNNuMD (by https://hub.knime.com/kathrin)=> install Continental extensions first! Add HeaderAdd Empty RowData TableDefine formattinginformationswrite initial table/data/test.xlsxWith unpivot option to get one row per cell Assing tagvalues based on row and column numberTransformback into originaltable formapply styles to a new filetest_applied.xlsxTable Creator Add Empty Rows Extract revenueper CW Concatenate XLS Formatting Excel Writer XLS ControlTable Generator Rule Engine XLS ControlTable Generator XLS Formatter(apply)

Nodes

Extensions

Links