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 |
static jxl.write.biff.DateRecord.GMTDate |
GMT
Instance variable for dummy variable overload |
Constructor Summary |
DateTime(DateCell dc)
A constructor called by the worksheet when creating a writable version
of a spreadsheet that has been read in |
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 cell |
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. |
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 |
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 |
Method Summary |
WritableCell |
copyTo(int col,
int row)
Implementation of the deep copy function |
void |
setDate(java.util.Date d)
Sets the date for this cell |
void |
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 |
getCellFormat, getColumn, getRow, isHidden, 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 |
GMT
public static final jxl.write.biff.DateRecord.GMTDate GMT
- Instance variable for dummy variable overload
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
DateTime
public DateTime(int c,
int r,
java.util.Date d)
- Constructor
- Parameters:
c
- the columnr
- the rowd
- the date
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,
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(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,
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 datea
- dummy overload
copyTo
public WritableCell copyTo(int col,
int row)
- Implementation of the deep copy function
- Specified by:
copyTo
in interface WritableCell
- 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
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