We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Aspose cann't properly read my dateformat

aspose cann’t properly read my dateformat

example 09/06/14 00:00 this format is read to 09/06/14 00:06

my code is


Workbook workbook = new Workbook(inputStream);
WorksheetCollection wsc = workbook.getWorksheets();
Worksheet worksheet = wsc.get(0);
Cells cls = worksheet.getCells();
RowCollection rc = cls.getRows();
Row row=(Row)rc.getRowByIndex(5);
Iterator cellIter = row.iterator();
while(cellIter.hasNext())
{
Cell myCell = (Cell) cellIter.next();
headers.addElement(myCell.getStringValue());
}

please help me

Hi Arunkumar,


Thank you for contacting Aspose support.

We have evaluated your presented scenario on our end while using the latest version of Aspose.Cells for Java 8.1.0. Unfortunately the issue didn’t replicate, therefore we would suggest you to please give the latest version a try on your end. In case the problem persists, please provide your template file for thorough investigation.

i update that jar but canot work properly


09/06/14 00:00 read as 09/06/14 00:06

what is that problm

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());


}


Console Output
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


Workbook workbook = new Workbook(inputStream);
WorksheetCollection wsc = workbook.getWorksheets();
Worksheet worksheet = wsc.get(0);
Cells cls = worksheet.getCells();
RowCollection rc = cls.getRows();
Row row=(Row)rc.getRowByIndex(5);
Iterator cellIter = row.iterator();
while(cellIter.hasNext())
{
Cell myCell = (Cell) cellIter.next();
logger.info(“mycell”+myCell.getStringValue());
headers.addElement(myCell.getStringValue());
}
logger.info(“headers:::>>”+headers);


this is my project code

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


i am using version 8.1.0

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


read the xlsx file using aspose current version

System.out.println(CellsHelper.getVersion());

the output is : 7.7.0.0

perticuler cell value is 08/06/14 00:00 but read the xlsx file the output is 08/06/14 00:06


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


read the xlsx file using aspose current version

System.out.println(CellsHelper.getVersion());

the output is : 7.7.0.0

perticuler cell value is 08/06/14 00:00 but read the xlsx file the output is 08/06/14 00:06



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 )