jxl.write
Class DateTime
java.lang.Object
jxl.biff.RecordData
jxl.biff.WritableRecordData
jxl.write.biff.CellValue
jxl.write.biff.DateRecord
- jxl.biff.ByteData, Cell, DateCell, WritableCell
public class DateTime
extends jxl.write.biff.DateRecord
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
static jxl.write.biff.DateRecord.GMTDate | GMT - Instance variable for dummy variable overload
|
DateTime(int c, int r, Date d) - Constructor
|
DateTime(int c, int r, Date d, CellFormat st) - Constructor which takes the format for this cell
|
DateTime(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 account
|
DateTime(int c, int r, 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
|
WritableCell | copyTo(int col, int row) - Implementation of the deep copy function
|
void | setDate(Date d) - Sets the date for this cell
|
void | setDate(Date d, jxl.write.biff.DateRecord.GMTDate a) - Sets the date for this cell, performing the necessary timezone adjustments
|
addCellFeatures , getCellFeatures , getCellFormat , getColumn , getData , getRow , getWritableCellFeatures , isHidden , removeComment , setCellFeatures , setCellFormat |
GMT
public static final jxl.write.biff.DateRecord.GMTDate GMT
Instance variable for dummy variable overload
DateTime
public DateTime(int c,
int r,
Date d)
Constructor
c
- the columnr
- the rowd
- the date
DateTime
public DateTime(int c,
int r,
Date d,
CellFormat st)
Constructor which takes the format for this cell
c
- the columnr
- the rowd
- the datest
- the format
DateTime
public DateTime(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. 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
c
- the columnr
- the rowd
- the datest
- the styletim
- flag indicating that this represents a time
DateTime
public 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 account
c
- the columnr
- the rowd
- the datest
- the cell formata
- the cummy overload
DateTime
public DateTime(int c,
int r,
Date d,
jxl.write.biff.DateRecord.GMTDate a)
Constructor, which adjusts the specified date to take timezone
considerations into account
c
- the columnr
- the rowd
- the datea
- dummy 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
copyTo
public WritableCell copyTo(int col,
int row)
Implementation of the deep copy function
- copyTo in interface WritableCell
col
- the column which the new cell will occupyrow
- the row which the new cell will occupy
- a copy of this cell, which can then be added to the sheet
setDate
public void setDate(Date d)
Sets the date for this cell
setDate
public void setDate(Date d,
jxl.write.biff.DateRecord.GMTDate a)
Sets the date for this cell, performing the necessary timezone adjustments
d
- the datea
- the dummy overload