Package jxl.write
Class DateTime
java.lang.Object
jxl.biff.RecordData
jxl.biff.WritableRecordData
jxl.write.biff.CellValue
jxl.write.biff.DateRecord
jxl.write.DateTime
- All Implemented Interfaces:
jxl.biff.ByteData
,Cell
,DateCell
,WritableCell
A Date which may be created on the fly by a user application and added to a
spreadsheet
NOTE: By default, all dates will have local timezone information added to
their UTC value. If this is not desired (eg. if the date entered
represents an interval eg. 9.83s for the 100m world record, then use
the overloaded constructor which indicate that the date passed in was
created under the GMT timezone. It is important that when the date
was created, an instruction like
Calendar.setTimeZone(TimeZone.getTimeZone("GMT"))
was made prior to that
-
Field Summary
FieldsModifier and TypeFieldDescriptionstatic final jxl.write.biff.DateRecord.GMTDate
Instance variable for dummy variable overload -
Constructor Summary
ConstructorsConstructorDescriptionConstructor.DateTime
(int c, int r, Date d, CellFormat st) Constructor which takes the format for this cellDateTime
(int c, int r, Date d, CellFormat st, boolean tim) Constructor which takes the format for the cell and an indicator as to whether this cell is a full date time or purely just a time eg.DateTime
(int c, int r, Date d, CellFormat st, jxl.write.biff.DateRecord.GMTDate a) Constructor, which adjusts the specified date to take timezone considerations into accountConstructor, which adjusts the specified date to take timezone considerations into account.A constructor called by the worksheet when creating a writable version of a spreadsheet that has been read in -
Method Summary
Methods inherited from class jxl.write.biff.DateRecord
getContents, getData, getDate, getDateFormat, getType, isTime
Methods inherited from class jxl.write.biff.CellValue
addCellFeatures, getCellFeatures, getCellFormat, getColumn, getRow, getSheet, getWritableCellFeatures, isHidden, removeCellFeatures, removeComment, removeDataValidation, setCellFeatures, setCellFormat
Methods inherited from class jxl.biff.WritableRecordData
getBytes
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
Methods inherited from interface jxl.Cell
getCellFeatures, getCellFormat, getColumn, getContents, getRow, getType, isHidden
Methods inherited from interface jxl.DateCell
getDate, getDateFormat, isTime
Methods inherited from interface jxl.write.WritableCell
getWritableCellFeatures, setCellFeatures, setCellFormat
-
Field Details
-
GMT
public static final jxl.write.biff.DateRecord.GMTDate GMTInstance variable for dummy variable overload
-
-
Constructor Details
-
DateTime
Constructor. The date will be displayed with date and time components using the default date format- Parameters:
c
- the columnr
- the rowd
- the date
-
DateTime
Constructor, which adjusts the specified date to take timezone considerations into account. The date passed in will be displayed with date and time components using the default date format- Parameters:
c
- the columnr
- the rowd
- the datea
- dummy overload
-
DateTime
Constructor which takes the format for this cell- Parameters:
c
- the columnr
- the rowst
- the formatd
- the date
-
DateTime
Constructor, which adjusts the specified date to take timezone considerations into account- Parameters:
c
- the columnr
- the rowd
- the datest
- the cell formata
- the cummy overload
-
DateTime
Constructor which takes the format for the cell and an indicator as to whether this cell is a full date time or purely just a time eg. if the spreadsheet is to contain the world record for 100m, then the value would be 9.83s, which would be indicated as just a time- Parameters:
c
- the columnr
- the rowst
- the styletim
- flag indicating that this represents a timed
- the date
-
DateTime
A constructor called by the worksheet when creating a writable version of a spreadsheet that has been read in- Parameters:
dc
- the date to copy
-
-
Method Details
-
setDate
Sets the date for this cell- Parameters:
d
- the date
-
setDate
Sets the date for this cell, performing the necessary timezone adjustments- Parameters:
d
- the datea
- the dummy overload
-
copyTo
Implementation of the deep copy function- Specified by:
copyTo
in interfaceWritableCell
- Parameters:
col
- the column which the new cell will occupyrow
- the row which the new cell will occupy- Returns:
- a copy of this cell, which can then be added to the sheet
-