Icon

LCA_​daily report

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 RowNode 2263Define formattinginformations With 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.xlsxwrite initial table/data/test.xlsxNode 2278Node 2279EmptyNode 2281Node 2282Node 2284Add Empty RowAdd HeaderNode 2287Node 2288Add Empty RowNode 2290Table Creator Add Empty Rows Concatenate XLS Formatting XLS ControlTable Generator Rule Engine XLS ControlTable Generator XLS Formatter(apply) Excel Writer Excel Reader Excel Reader Table Creator Column Appender Column Resorter Excel Reader Add Empty Rows Table Creator Column Resorter Sorter Add Empty Rows Missing Value 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 RowNode 2263Define formattinginformationsWith 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.xlsxwrite initial table/data/test.xlsxNode 2278Node 2279EmptyNode 2281Node 2282Node 2284Add Empty RowAdd HeaderNode 2287Node 2288Add Empty RowNode 2290Table Creator Add Empty Rows Concatenate XLS Formatting XLS ControlTable Generator Rule Engine XLS ControlTable Generator XLS Formatter(apply) Excel Writer Excel Reader Excel Reader Table Creator Column Appender Column Resorter Excel Reader Add Empty Rows Table Creator Column Resorter Sorter Add Empty Rows Missing Value

Nodes

Extensions

Links