setDataFormat script operation
Set the cell style Data Format to that supplied.
Format: ObjectOriented
Type: method
Syntax
void ExcelCellStyle::setDataFormat(String format)
Parameters
| Type | Name | Description | Is required? | Is array? |
|---|---|---|---|---|
| ExcelCell | operatesOn | The cellStyle whose data format value is to be set. | true | false |
| String | format | The Data Format style. The valid formats are General, 0, 0.00, #, ##0, #, ##0.00, ($#, ##0_);($#, ##0), ($#, ##0_);[Red]($#, ##0), ($#, ##0.00);($#, ##0.00), ($#, ##0.00_);[Red]($#, ##0.00), 0%, 0.00%, 0.00E+00, # ?/?, # ??/??, m/d/yy, d-mmm-yy, d-mmm, mmm-yy, h:mm AM/PM, h:mm:ss AM/PM, h:mm, h:mm:ss, m/d/yy h:mm. | true | false |
Return values
Return value: void
Is array: false