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
public class DateTime extends jxl.write.biff.DateRecord implements WritableCell, DateCell
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
Fields Modifier and Type Field Description static jxl.write.biff.DateRecord.GMTDate
GMT
Instance variable for dummy variable overload
-
Constructor Summary
Constructors Constructor Description DateTime(int c, int r, java.util.Date d)
Constructor.DateTime(int c, int r, java.util.Date d, CellFormat st)
Constructor which takes the format for this cellDateTime(int c, int r, java.util.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, java.util.Date d, CellFormat st, jxl.write.biff.DateRecord.GMTDate a)
Constructor, which adjusts the specified date to take timezone considerations into accountDateTime(int c, int r, java.util.Date d, jxl.write.biff.DateRecord.GMTDate a)
Constructor, which adjusts the specified date to take timezone considerations into account.DateTime(DateCell dc)
A constructor called by the worksheet when creating a writable version of a spreadsheet that has been read in
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description WritableCell
copyTo(int col, int row)
Implementation of the deep copy functionvoid
setDate(java.util.Date d)
Sets the date for this cellvoid
setDate(java.util.Date d, jxl.write.biff.DateRecord.GMTDate a)
Sets the date for this cell, performing the necessary timezone adjustments-
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 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
-
-
-
-
Constructor Detail
-
DateTime
public DateTime(int c, int r, java.util.Date d)
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
public DateTime(int c, int r, java.util.Date d, jxl.write.biff.DateRecord.GMTDate a)
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
public DateTime(int c, int r, java.util.Date d, CellFormat st)
Constructor which takes the format for this cell- Parameters:
c
- the columnr
- the rowst
- the formatd
- the date
-
DateTime
public DateTime(int c, int r, java.util.Date d, CellFormat st, jxl.write.biff.DateRecord.GMTDate a)
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
public DateTime(int c, int r, java.util.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. 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
public DateTime(DateCell dc)
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 Detail
-
setDate
public void setDate(java.util.Date d)
Sets the date for this cell- Parameters:
d
- the date
-
setDate
public void setDate(java.util.Date d, jxl.write.biff.DateRecord.GMTDate a)
Sets the date for this cell, performing the necessary timezone adjustments- Parameters:
d
- the datea
- the dummy overload
-
copyTo
public WritableCell copyTo(int col, int row)
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
-
-