WebExcelExporter.Export : String values assigned to a cell cannot have a length greater than 32767

Chandu Byragani asked on Oct 9, 2014 8:33 AM

I’m facing an issue while exporting data to Excel from Infragistics WebDataGrid. I have field which is more than 32767 character length and when I export this fields to Excel cell it is showing the below error message.
String values assigned to a cell cannot have a length greater than 32767

Is there any solution for this? out of box functionality? or DO I need to write my custom code?

Replies

0

Mike Dour answered on Oct 5, 2014 6:33 PM

Unfortunately, it is not possible to assign a value to a cell if it is text with more than 32767 characters. Excel does not support it. The exception you see is correctly enforcing the limits of the Excel file format. You can find all limits for Excel 2013 here.
0

Hristo Anastasov answered on Oct 6, 2014 8:38 AM

Hello Chandu,

As Mike pointed out it is not possible to store more than 32767 characters in an excel cell. Of course you could try to separate the data from your field into 2 fields in the grid if that would keep your scenario.
- 0
  
  Hristo Anastasov answered on Oct 9, 2014 8:33 AM
  
  Hello,
  
  If you have further questions on the matter, please let me know, I will be glad to help.