Reading a Date Value From a Worksheet

Aspose.Cells Product Family
1

Hi,


Im trying to read a DATE value from a .xlsx file using aspose.I used the getValue() method of com.aspose.Cells class.It returns the date value in the format yyyy-mm-ddThh:mm:ss.Is this the Default DateTime Format that will be returned always.Can I configure the Format by anymeans.

I need the date to be returned in the format dd-mm-yy hh:mm:ss (and some other format and that depends on the situation).

Is there any way that I can specify the Date Format that should be returned.

Thanks in Advance.
This message was posted using Page2Forum from /community/public/documentation
2

Hi,


Well, by default, the DateTime values are based on your regional and locale settings on your machine.
Well, you need to specify your desired DateTime by using style.setCustom() method (applying the custom string you want) to be set properly for your needs, see the document for your reference:
http://www.aspose.com/docs/display/cellsjava/Setting+Display+Formats+of+Numbers++and++Dates

Thank you.

3
Hi,

Please see the sample code below for your reference:

Sample code:

//Instantiating a Workbook object
Workbook workbook = new Workbook();

Worksheet worksheet = workbook.getWorksheets().get(0);
Cells cells = worksheet.getCells();

//Adding the current system date to "A1" cell
Cell cell = cells.get("A1");
cell.setValue(Calendar.getInstance());

//Setting the display format of the custom date
Style style = cell.getStyle();
style.setCustom("dd-mm-yy hh:mm:ss");
cell.setStyle(style);

System.out.println(cell.getStringValue());
System.out.println(cell.getDisplayStringValue());


Output Console:
21-05-13 18:39:11 - OK
21-05-13 18:39:11 - OK