Using WorkbookDesigner SetDataSource with int array

Aspose.Cells Product Family
1

I am just trying to set an array of simple numbers in a spreadsheet using WorkbookDesigner.

Aspose.Cells.WorkbookDesigner designer = new Aspose.Cells.WorkbookDesigner();
designer.Open("c:\\test1.xls");
designer.SetDataSource("str_col", new string[] { "str1", "str2", "str3" });
designer.SetDataSource("int_col", new int[] { 1, 2, 3 });
designer.Process();
designer.Save("c:\\test2.xls");

The .xls template has

&=$str_col &=$int_col

In this simple sample, the str_col sucessfully contains the 3 strings ... but the int_col has no values. I can insert a SINGLE int (rather than an array), but I cannot get an array to work.

Any ideas why?

2

Hi,

We found the issue with int array as you have mentioned. We will fix it soon.

Thank you.

3

Hi,

Please try the attached version v4.8.0.11, we have supported int array as the smart marker’s data source.


Thank you.

4

The issues you have found earlier (filed as 11099) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.