Free Support Forum - aspose.com

Event handling on CELLs (java)

Aspose.Cells Product Family
#1

Currently we are using Aspose.Cells for Java V1.9.4 Hot Fix version.

Is there any listener or event handler parseing which is supported by the aspose cell api?

Apache POI supoport this feature 'event-driven parsing' .

I was looking in the forums and they mention taht this can be implemented by using the LightCells api and using the cell hander class.

I was able to find these classes in the Aspose.Cells for Java V1.9.4 Hot Fix version.

please advice us.

Thanks

-Ajit-

#2

Hi Ajit,

Please try our latest fix version, such as V1.9.4.23 at http://www.aspose.com/community/forums/permalink/128332/128193/showthread.aspx#128193. We will release a new version and update the docs for this new API in few days, in the mean time, you may check following threads and the related reply for reference:

http://www.aspose.com/community/forums/thread/125926/performance-of-aspose.aspx

http://www.aspose.com/community/forums/thread/125773/does-aspose.cell-for-java-support-event-driven-parsing.aspx

http://www.aspose.com/community/forums/thread/128176/lightcells-api-giving-the-exception-aspose-cells-for-java.aspx

#3

Thanks Johnson Shi.

Let me try this and get back to you if any questions /issues.

Thanks
-Ajit-

#4

Johnson Shi,

Light cell is working fine but facing one issue with numbers .

If the cell contains the number as value then ouput value is in decimal format.

Example:-
cell value in the excel :5652565556
ouput from the code : 5.652565556E9

We are using the FileFormatType as Excel 2003 .

Please let me know if you need any more information from my side.

Thanks
-Ajit-


#5

Hi Ajit,

I think maybe it is because the value type is double and you transform it into string without any NumberFormat applied, such as System.out.println(val); It is no concern of Cells, in fact, in Java program, when you directly print out such a double value, it will give the same output. To get customed format from number, you may use java.text.NumberFormat, DecimalFormat to format the number value before output it.

And there are some cells in excel file whose value type is defined as double even the values equal to corresponding integer. Cells just read in the defined value type and value then send it to client.

So, it's better for user to check the value type first and then decide how to format it, such as, if double, maybe need NumberFormat, if datetime, maybe need DateFormat, and so on.

#6


Thanks Johnson .

I am facing the issue in the 2007 format type excel sheet .
Attached the excel sheet along with this.
The parsing is stoped at the second row where the numbers are more then one digits.
This work fine if the cell contain only one digit number.

Here is the o/p after parsing this excel sheet:-

0&Type:3& ref
0&Type:3& addr
0&Type:3& type
1&Type:4& 1

Thanks
-Ajit-

#7

Hi Ajit,

Thanks for your feedback and providing us the template file.

Please try the attached fix.

Thank you.