@wooddenbowl you can use OpenPyxl with the bundled Python in KNIME to extract the format of the first line of data of an Excel sheet and store that for later use.
If you want to ‘preserve’ the formats you might have to also employ OpenPyxl and define a reference for your excel formats in Pandas and store the information as strings. The downside would be that you would have to define these settings before. But the above approach might help you with that.
