000032531 - Unable to Export to Excel (xls) when a string is bigger than 32K to a Cell in in RSA Archer 5.x

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 22, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000032531
Applies ToRSA Product Set: Archer

RSA Version/Condition: 5.x
IssueUnable to export to Excel.
The following exception occurs in the w3wp log file:
<ApplicationData>
  <TraceData>
    <DataItem>UserId: ;
LogReferenceId: ;
Message: ;
Exception: Aspose.Cells.CellsException: You want to put a string longer than 32K to Cell B14. MS Excel only allows to put a string shorter than 32K to a Cell.
   at Aspose.Cells.Cell.—�&#x19;(String )
   at Aspose.Cells.Cell.PutValue(Object objectValue)
   at &#x18;&#x3;&#xE;.&#x19;&#x3;&#xE;.ƒ�&#x7;(Worksheet , XmlTextReader )
   at &#x18;&#x3;&#xE;.&#x19;&#x3;&#xE;.‰&#xF;&#xF;(XmlTextReader )
   at &#x18;&#x3;&#xE;.&#x19;&#x3;&#xE;.&#x1C;&#xF;&#xF;(XmlTextReader )
   at &#x18;&#x3;&#xE;.&#x19;&#x3;&#xE;.&#x19;&#xF;&#xF;(Stream , Workbook )
   at Aspose.Cells.Workbook.&#x1F;Ÿ&#x10;(Stream , LoadOptions , Boolean )
   at ArcherTech.ChannelFramework.Reporting.Excel.ExcelGridReport.RenderReport(XmlReader data, Stream output)
   at ArcherTech.PrintExport.PrintExportService.RenderRecordData(SessionContext sessionContext, PrintExportCriteria printExportCriteria, Boolean printLayout, Stream output)
   at ArcherTech.Web.Modules.Foundation.Views.PrintExportPresenter.ExportRecord(SessionContext sessionContext, PrintExportCriteria printExportCriteria)</DataItem>
  </TraceData>
</ApplicationData>

 
CauseExcel limits the total number of characters a cell can contain to 32,767 characters.  Check out Excel specifications and limits.
WorkaroundWorkaround is to export to a different file type or reduce the number of characters in the field values.

Attachments

    Outcomes