Hi,
I'm getting an exception for halving a string more than 32767 characters when exporting my data from UltraGrid to Excel. To handle this I am creating another worksheet and setting the value on the new worksheet and breaking up into multiple cells to prevent that exception. After creating the new worksheet I am trying copy the first row values and cell format of "Sheet1" to the new sheet. I am able to copy the value but the formatting of the cell does not roll over. I try to set the cell formatting manually using SetFormatting method but nothing changes. I've attached an example excel file on what is happening. DeviceImageAnalyzer.xlsx
Hi Raymond,
The exception you encounter is intended behavior. Microsoft Excel has a limit of 32,767 characters for a cell, so our engine throws an exception to alert the developer that it will not be possible to store that value in a cell.
Your workaround of breaking up the data into multiple cells sounds like a good approach to me. SetFormatting should be working to copy the format over. If you can provide the sample code that you're using to copy the format over, I can check into why it is not working as you expect.
I figured out the issue. I was tried setting the format for the entire row first and then tried the entire column, but what I had to do is set it for each cell.