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 ?
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 .
thanks for the advice. I`ll try that.
- update: it worked with the cell split by position (simply add 32 000 as split parameter)
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?
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
cheers for the advice !
looks like its working
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.