XLSX Writer :The maximum length of cell contents (text) is 32,767 characters

Hello everyone,

I have encountered a problem, i’m trying to extrapolate text from a PDF but when trying to append it in a xlsx file i get the following error message:
“Execute failed: The maximum length of cell contents (text) is 32,767 characters”

I tried with the cell splitter by position but without success, browsing the forum i saw there is a possibility to stop a column at 32000 char and then make a new column, but where do I have to configure it? because the cell splitter options just ask me for a split indices not a char count.
Thank you in advance

you could use regexextractor node and then define after how many characters to split
e.g. in my case I chose 3 (including spaces)


br

1 Like

Hi @gabriele,

I do not quite understand your problem with the cell splitter by position node

Wouldn’t
grafik
do exactly what you want?

1 Like

Hello there,
thank for your answer, but it still give the same error

Maybe i have to split the cell several time at 32.000 and again? in this case i can use the same indices (32.000) or i have to use 32,64,96 and so on?

Hi @gabriele,
Maybe you can provide an example?
Hard to say without seeing the data.
But from the error message you have to split it further (just add additional points in thr cell. splitter e.g. 32000,64000,96000

1 Like

The input data is a raw text (27 pages) extracted from 152 pdf.
So i have 152 row with a Text column made by XX Char.
I use the split text to write an xlsx with less than 32.767 char in this way


But the output is less column than required which make me think the text is shorter than 64.000 or 96.000 character

But i still get the writer node error

Hi @gabriele

I believe this is a problem that some of us have already experienced and perhaps deserves its own component to be addressed. So please find below a link to the component that I implemented to generically solve your problem. The component has a menu to select the column to split cell strings and choose the maximum number of characters desired per new substring. The component generates from there as many columns as needed to contain all the substrings of the initial string:

The following workflow illustrates the use of the above component:

This component has the advantage of preserving word integrity so that words are not split during the string splitting process.

I hope this component solves your sentence splitting problem. If not, please contact us again to help you further, perhaps with your own data if you can upload it here.

Best
Ael

4 Likes