String longer than 32K error

sharanya · July 18, 2014, 3:08am

Hi,

I am using Aspose.Cells version 7.5.2.0. I am getting “You want to put a string longer than 32K to cell G48. MS Excel only aloows to put a string shorter than 32K to a Cell.” error while writing the large string to a cell.

The way we create worksheet is that, we create a XML file and then apply xsl style sheet and then create work sheet.

Below is the code -

StreamWriter streamWriter = null;

XmlReader xmlDoc = null;

//Storing DataSet temporality in xml format

data.WriteXml(XMLFilePath); //data = dataset, XMLFilePath = Path of the XML file to be created

xmlDoc = XmlReader.Create(XMLFilePath);

XsltSettings settings = new XsltSettings(false,true);

XslCompiledTransform transform = new XslCompiledTransform();

transform.Load(XSLStylesheetPath, settings, new XmlUrlResolver());//XSLStylesheetPath = Style sheet defined for the workbook in .xsl

streamWriter = File.CreateText(newFileFullPath);//newFileFullPath = Path of the excel work sheet

transform.Transform(xmlDoc, xslArg, streamWriter);

Workbook excelWorkbook = new Workbook(newFileFullPath);//The error is thrown here

Please suggest. This is urgent

Thanks,
Sharanya

amjad.sahi · July 18, 2014, 3:57am

Hi,

Well, this is MS Excel restriction and nothing to do with Aspose.Cells. But, we think you may try to use

use CheckExcelRestriction option (Aspose.Cells provides this API) to set it to false. Please see the sample code below:

e.g

Sample code:

LoadOptions loadOptions = new LoadOptions(LoadFormat.Xlsx);
loadOptions.CheckExcelRestriction = false;

Workbook workbook = new Workbook(stringFilePath, loadOptions);

Thank you.