Aspose.Cells 5.1.3 after upgrade from 4.x version error processing smart tags

pcHouston73 · October 14, 2010, 6:37pm

&nbsp;We have upgraded to the latest Dll to handle processing smart tags for rows over 65K limit of excel 2003, the problem is when we are encoutering this line:template.Process(template.Workbook.Worksheets[&quot;Data&quot;].Index, false);we get a generic system Null exception. TIAHere is the code snippet:var template = new WorkbookDesigner(); //template.Workbook.Open(inFile);//template.Workbook.Open(new MemoryStream(fileBytes), FileFormatType.Excel2007Xlsm);template.Workbook = new Workbook(new MemoryStream(fileBytes), new LoadOptions(LoadFormat.Xlsx)); //Insert data for each datasetvar nodata = false;foreach(var dataSet in dataSets) {var pivotData = dataSet.Value.GetData(requestId, dataSet.Key);if(pivotData.Count &lt; 1) {nodata = true;continue; }nodata = false; template.SetDataSource(pivotData[0].GetClassName(), pivotData);template.Process(template.Workbook.Worksheets[&quot;Data&quot;].Index, false);template.Workbook.Worksheets[&quot;Data&quot;].AutoFitColumns(); }

This message was posted using Aspose.Live 2 Forum

pcHouston73 · October 14, 2010, 6:44pm

Aspose.Cells 5.1.3 after upgrade from 4.x version:

We have upgraded to the latest Dll to handle processing smart tags for rows over 65K limit of excel 2003, the problem is we are encoutering a generic null exception on this line but we only get this error if the data set containes over 65K records:

template.Process(template.Workbook.Worksheets["Data"].Index, false);

here is the complete code snippet:

var template = new WorkbookDesigner();
//template.Workbook.Open(inFile);
//template.Workbook.Open(new MemoryStream(fileBytes), FileFormatType.Excel2007Xlsm);

template.Workbook = new Workbook(new MemoryStream(fileBytes), new LoadOptions(LoadFormat.Xlsx));

//Insert data for each dataset
var nodata = false;
foreach(var dataSet in dataSets)
{
var pivotData = dataSet.Value.GetData(requestId, dataSet.Key);
if(pivotData.Count < 1)
{
nodata = true;
continue;
}
nodata = false;
template.SetDataSource(pivotData[0].GetClassName(), pivotData);
template.Process(template.Workbook.Worksheets["Data"].Index, false);
template.Workbook.Worksheets["Data"].AutoFitColumns();
}

SalmanShakeel · October 14, 2010, 10:35pm

Hi,

Thanks for details and the code. Please share the template file with us so that we can perform testing. This will help us to find out the root cause of the issue.

Thanks,

pcHouston73 · October 18, 2010, 1:24pm

I have done alot of testing, the code listed is generic code and no matter what the dataset provided to the process method looks like the line fails.

the number of records in the dataset must be more than the excel 2003 limit of 65K and you can create any template your want with at least 1 smart tag as long as the smart tag is a formula such as &=&=A{r}*B{r}

hope this helps