XLS Writer - Maximum length of cell contents

[And_Z]

Hi all,

i`m trying to export data into a xlsx file, however some of the cells reach the maximum length of some 32 000 characters.
Is there anyway to still export the file and simply cut the cell content at the limit or split the cell into two cells ?

best

And

[Iris]

Hi And,
this seems to be a limitation by excel. Never heard they have this, but it is listed here: https://support.office.com/en-us/article/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3

You can use a cell splitter by position node .
Best, Iris

[And_Z]

Hi Iris,

thanks for the advice. I`ll try that.

• update: it worked with the cell split by position (simply add 32 000 as split parameter)

cheers

Andreas

[And_Z]

Hi Again,

a connected question.
The splitter node tells me i can’t create more than two column from the split?
is this the setting of the node or are more columns possible?

Cheers

Andreas

[ipazin]

Hi Andreas!

Check Node description. You got Array Size option.

Set Array Size
Check this and specify the number of columns to append. All created columns will be of type String. (See above for what happens if the split produces a different number of parts.)

You probably have checked Guess Size and Column Types option.

Also you can use Flow variable to control number of columns because on Flow variable tab you got NumberofCols field

Br,
Ivan

[And_Z]

Dear Ivan,

cheers for the advice !
looks like its working

greets

[ipazin]

You are welcome
Ivan