Excel Writer adds extra newlines to large text field

KNIME Analytics Platform
#1

Hello,

My data table has a string column with an XML value:

Within KNIME, it looks something like this.

<?xml version="1.0" encoding="utf-8"?>
<A>
  <B>
    <C>ORGANISM</C>
    <D>PLANT</D>

....

when I write the data table to an Excel XLSX file using the Excel Writer (KNIME v. 3.3.1), extra newlines appear in this column. (It looks like:

<?xml version="1.0" encoding="utf-8"?>

<A>

  <B>

    <C>ORGANISM</C>

    <D>PLANT</D>

....

Same thing with the Excel Sheet Appender.

I found a work-around: writing the data to an .XLS file. (No extra newlines appear in this case.)

Reporting this in case someone on the KNIME team wants to take a look.

Mitch

#2

Dear Mitch,

thank for your message.

Could you please send your XML file example? I have tried with the following example and it seems to work fine for me, both with the Excel Writer node and the Excel Sheet Appender node.

<?xml version='1.0' encoding='UTF-8'?>
<note>
    <to>Tove</to>
    <from>Jani</from>
    <heading>Reminder</heading>
    <body>Do not miss the next meeting!</body>
</note> 

Best,

Vincenzo