NumberFormat for String and Sorting

Aspose.Cells Product Family
1

Hi,

We are having numbers for a particular column data.The data object is integer in java and we convert them all to string and populate them.

Cells.importObjectArray(String[])

Cells.importArray(String[])

Cells.setNumber(1)

The sorting for this number column does not work.It treats them as a string.Please advice what tweak we need to do to treat the string as a number and sort the column properly.

Regards

Joe

2

Hi Joe,

For your case, you needn't convert Integer to String before import the data, you can use Cells.importArray(int[],…) or Cells.importObjectArray(Integer[],…) to import numbers.