<?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.
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.