Excel cell value is not showing properly

Aspose.Cells Product Family
1

Hi,

I have the following code:

int colIndex = thisCell.getColumnIndex()+1;

int rowIndex = thisCell.getRowIndex();

Cell nextCell = worksheet.getCell(rowIndex, colIndex);

String CellValue = nextCell.getStringValue();

If my cell value is "" or " " then CellValue is showing an integer value either 31 or 33.

I am using Java.Cells-7.1.1. We upgraded from Java.Cells-7.0.2. The above code was working fine with 7.0.2 version.

I need to show the value as it is. Any idea how to fix this?

Thanks

Hari

2

Hi,

Please download and try the latest version:
Aspose.Cells
for Java v7.1.2.2

It is working fine…

Please see the code below.

Java


String filePath = “F:\Shak-Data-RW\Downloads\source.xlsx”;


Workbook workbook = new Workbook(filePath);


Worksheet worksheet = workbook.getWorksheets().get(0);


Cell cell = worksheet.getCells().get(“A1”);


System.out.println(cell.getValue());

3

I replaced aspose-cells-7.1.1 to aspose-cells-7.1.2.2, I still see the above issue. It didn't resolve for me.

Here I attached the source code (AsposeWorkbookHelper.java) that cause the above error. Please review and let me know what we are doing wrong here and how could we resolve this.

4

Hi,

Please provide a simpler code to replicate the problem.

Please also let us know your JDK and make sure you are using the correct JDK libraries needed by aspose.cells jar.

You can download all the prerequisite libraries from the major download link:

Aspose.Cells for Java 7.1.2