000032531 - Unable to export data to MIcrosoft Excel (xls) when a string is bigger than 32K to a cell in in RSA Archer

Document created by RSA Customer Support Employee on Jun 14, 2016•Last modified by RSA Customer Support on Jun 28, 2019
Version 3Show Document
  • Comment • 0
  • View in full screen mode

Article Content

Article Number000032531
Applies ToRSA Product Set: Archer 
IssueUnable to export data to MIcrosoft Excel (xls) when a string is bigger than 32K to a cell in in RSA Archer

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.  For more information please review Excel specifications and limits form Microsoft.
WorkaroundThe workaround is to export to a different file type or reduce the number of characters in the field values.

Attachments

    Outcomes