We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Overcoming cell size limitation

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.

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.