I have encountered a challenge, when trying to append a picture from a Python view node to a XLS file using the Excel Sheet Appender. Doing this via an “Image to table” node, but that worked a lot of times previously, so I doubt that’s the problem.
It says the following error message:
“Execute failed: The maximum length of cell contents (text) is 32,767 characters”
The only help, I could find was this old post, which wasn’t helping.
Can anybody help me with this?
I added a picture of my workflow and the settings in my Appender. Sorry, I’m not able to attach the workflow due to NDA regulations.
If I need to supply additional information’s, please let me know.
The problem is excel wont allow you to write more than 32,767 characters inside a single cell. The image produced by your component is in SVG format, which is XML text. Depending on the complexity of your graphics this XML text could be well over the limit.
The work around is to use the Renderer to Image node to convert the svg to PNG (for example) then you can write the converted column to excel. This way excel recognises it as an image and the character limit is not a problem.
