Article Content
Article Number | 000032531 |
Applies To | RSA Product Set: Archer |
Issue | Unable 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.—�(String ) at Aspose.Cells.Cell.PutValue(Object objectValue) at ..ƒ�(Worksheet , XmlTextReader ) at ..‰(XmlTextReader ) at ..(XmlTextReader ) at ..(Stream , Workbook ) at Aspose.Cells.Workbook.Ÿ(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> |
Cause | Excel 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. |
Workaround | The workaround is to export to a different file type or reduce the number of characters in the field values. |