Overcoming cell size limitation

[andyww]

Hi,

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

I've hit a snag regarding importing to importing a datatable into excel document.

Some of cells do contain considerably more than 1000 characters. Therefore whilst the cell is holding the data, when I come to print it I only get a subset of the true data.

The only work around I can think of is to somehow loop through each row in the datatable and add a new line characters at set interval.

Do you have any better suggestions?

Thanks.

[Amjad_Sahi]

Hi,

Well, in MS Excel, you have certain limitations regarding cell contents’ length. For example, in Excel, you can have:

Length of cell contents (text)

32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar.

Aspose.Cells have to follow MS Excel standards, so it is due to MS Excel limitation.

Also, I think you are doing OK to overcome size limitation issue. Also, I cannot think a better suggestion than this at the moment. If in any case, I have a better option, I will share it here for you.

Thank you.