Perhaps the best way could be to use Excel or LibreOffice and, if necessary, drive operations with Knime and the bash node (Bash – KNIME Community Hub) and comand lines with excel.exe. Or other scripting nodes (Python, Java etc).
Joel
Edit : I see this post also External Tool – KNIME Community Hub and some about comand line like this Open and Close Excel File using the bash node