aspose cann’t properly read my dateformat
Hi Arunkumar,
i update that jar but canot work properly
Hi Arunkumar,
Thanks for your posting and using Aspose.Cells.
We have tested your issue with the following code using the latest version: Aspose.Cells for Java 8.1.0 and it gave correct results.
Please make sure that you are using the latest version. You can check it using the following code and it should print 8.1.0.0.
System.out.println(CellsHelper.getVersion());
I have also shown the console output of the following test code for your reference. The code reads cells from B2:B57 and prints their string values.
Java
String filePath = “F:\Shak-Data-RW\Downloads\withcusdate.xlsx”;
System.out.println(CellsHelper.getVersion());
Workbook workbook = new Workbook(filePath);
Worksheet worksheet = workbook.getWorksheets().get(0);
for(int i=1; i<57; i++)
{
Cell cell = worksheet.getCells().get(i, 1);
System.out.println(cell.getStringValue());
}
8.1.0.0
05/06/14 00:00
06/06/14 00:00
07/06/14 00:00
08/06/14 00:00
09/06/14 00:00
10/06/14 00:00
11/06/14 00:00
12/06/14 00:00
13/06/14 00:00
14/06/14 00:00
15/06/14 00:00
16/06/14 00:00
17/06/14 00:00
18/06/14 00:00
19/06/14 00:00
20/06/14 00:00
21/06/14 00:00
22/06/14 00:00
23/06/14 00:00
24/06/14 00:00
25/06/14 00:00
26/06/14 00:00
27/06/14 00:00
28/06/14 00:00
29/06/14 00:00
30/06/14 00:00
01/07/14 00:00
02/07/14 00:00
03/07/14 00:00
04/07/14 00:00
05/07/14 00:00
06/07/14 00:00
07/07/14 00:00
08/07/14 00:00
09/07/14 00:00
10/07/14 00:00
11/07/14 00:00
12/07/14 00:00
13/07/14 00:00
14/07/14 00:00
15/07/14 00:00
16/07/14 00:00
17/07/14 00:00
18/07/14 00:00
19/07/14 00:00
20/07/14 00:00
21/07/14 00:00
22/07/14 00:00
23/07/14 00:00
24/07/14 00:00
25/07/14 00:00
26/07/14 00:00
27/07/14 00:00
28/07/14 00:00
29/07/14 00:00
30/07/14 00:00
file reading correctly print my terminal, but using my project not good
Hi Arunkumar,
Thanks for using Aspose.Cells.
Please first make sure, you are using the latest version. Please execute this line of code in your project.
System.out.println(CellsHelper.getVersion());
and let us know what does it print.
If your issue persists, then please provide us your runnable sample code, so that we could look into this issue further.
the version is 7.7.0.0
Hi Arunkumar,
Thanks for using Aspose.Cells.
It means, you are using the older version. Kindly use the latest version: Aspose.Cells for Java 8.1.0 and let us know your results.
Please also let us know your output. If your issue still occurs, then please try the code in this post.
perticuler cell value is 08/06/14 00:06 but read the xlsx file the output is 08/06/14 00:06
Hi,
Thanks for your posting and using Aspose.Cells for Java.
If cell value is 08/06/14 00:06 and it is read as 08/06/14 00:06, then it is correct behavior.
Kindly provide screenshot of your output. Also, please check what is your Date & Regional settings.
Please also try the code in this post and let us know your output.
sorry for the disturbance please ignore the previous post
Hi,
Thanks for your feedback and using Aspose.Cells.
You are still using the older version because if it was new version then
System.out.println(CellsHelper.getVersion());
above line should print 8.1.0.0. So please make sure you are using the latest version and you have updated the classpath correctly.
Kindly run the following code and let us know your output so that we could investigate if we could replicate your issue at our end.
Java
Locale locale = Locale.getDefault();
System.out.println(locale.getCountry());
System.out.println(locale.getLanguage());
java version "1.7.0_51" OpenJDK Runtime Environment (IcedTea 2.4.4) (7u51-2.4.4-0ubuntu0.12.04.2) OpenJDK 64-Bit Server VM (build 24.45-b08, mixed mode)
os is ubundu
Hi,
Thanks for using Aspose.Cells.
Kindly refer to my previous post and let us know your feedback.
( Aspose cann't properly read my dateformat )