strings longer than 32K in a cell

Questions and answers on how to use XLSReadWriteII 5.
Post Reply
jdorlon
Posts: 15
Joined: Wed Jan 13, 2010 7:24 pm

strings longer than 32K in a cell

Post by jdorlon »

Hello,

If I use XLSReadWriteII6 to put a string longer than 32K in length into a cell, then when I open the file in Excel, there is no data.

I can, however, paste the same data directly into Excel.

Is this a bug or is there some other reason for this behavior?

Thanks

John Dorlon
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: strings longer than 32K in a cell

Post by larsa »

Hello

Max text length in a cell is 32767 characters. You can probably paste text in a cell because Excel truncates it.
Lars Arvidsson, Axolot Data
Post Reply