Excel Writer created XLSX file only readable by interface after open save close routine
Dear KNIME community,
I am experiencing problems reading an XLSX file created via Excel Writer Node via an interface (that likely tries to read the file in XML-schema).
I discovered that the problem gets resolved if I manually open and save the file in Excel prior to starting the import via interface.
At the same time I see that the file size increases significantly between the initially create file (Excel Writer Node) and the filesize after opening and saving via Excel.
I do not get an error message when executing the workflow (I am runnint version 4.7.). I also do not get any error or prompt when opening the created file in Excel.
I fixed the problem on my local machine by running a .bat file that would open, save and close the created file - however the .bat file cannot be executed on the target system.
Hence I need to get KNIME to writing the XLSX file in the “right” (i.E. machine-readable) format.
Any ideas how to fix this - a solution would be highly appreciated!
Thank you very much in advance and kind regards,
Denis