Number and date format

// Create a style for the cell
ExcelStyle xlsStyle = new ExcelStyle();
xlsStyle.setFormat("$0.00");

// Apply the style to the cell
xlsCell.setStyle(xlsStyle);

' Create a style for the cell
Dim xlsStyle As ExcelStyle = New ExcelStyle()
xlsStyle.setFormat("$0.00")

' Apply the style to the cell
xlsCell.setStyle(xlsStyle)

C++

// Create a style for the cell
EasyXLS::IExcelStylePtr xlsStyle;
hr = CoCreateInstance(__uuidof(EasyXLS::ExcelStyle),
		      NULL,
		      CLSCTX_ALL,
		      __uuidof(EasyXLS::IExcelStyle),
		      (void**) &xlsStyle);
xlsStyle->setFormat("$0.00");

// Apply the style to the cell
xlsCell->setStyle(xlsStyle);


C++.NET

// Create a style for the cell
ExcelStyle ^xlsStyle = gcnew ExcelStyle();
xlsStyle->setFormat("$0.00");

// Apply the style to the cell
xlsCell->setStyle(xlsStyle);

// Create a style for the cell
ExcelStyle xlsStyle = new ExcelStyle();
xlsStyle.setFormat("$0.00");

// Apply the style to the cell
xlsCell.setStyle(xlsStyle);

.NET:

// Create a style for the cell
$xlsStyle = new COM("EasyXLS.ExcelStyle");
$xlsStyle->setFormat("$0.00");

// Apply the style to the cell
$xlsCell->setStyle($xlsStyle);


Java:

// Create a style for the cell
$xlsStyle = new java("EasyXLS.ExcelStyle");
$xlsStyle->setFormat("$0.00");

// Apply the style to the cell
$xlsCell->setStyle($xlsStyle);

' Create a style for the cell
set xlsStyle = Server.CreateObject("EasyXLS.ExcelStyle")
xlsStyle.setFormat("$0.00")

' Apply the style to the cell
xlsCell.setStyle(xlsStyle)

' Create a style for the cell
Set xlsStyle = CreateObject("EasyXLS.ExcelStyle")
xlsStyle.setFormat("$0.00")

' Apply the style to the cell
xlsCell.setStyle(xlsStyle)

' Create a style for the cell
set xlsStyle = CreateObject("EasyXLS.ExcelStyle")
xlsStyle.setFormat("$0.00")

' Apply the style to the cell
xlsCell.setStyle(xlsStyle)

<!-- Create a style for the cell -->
<cfobject type="java" class="EasyXLS.ExcelStyle" name="xlsStyle" action="CREATE">
<cfset xlsStyle.setFormat("$0.00")>

<!-- Apply the style to the cell -->
<cfset xlsCell.setStyle(xlsStyle)>

.NET:

# Create a style for the cell
xlsStyle = ExcelStyle()
xlsStyle.setFormat("$0.00")

# Apply the style to the cell
xlsCell.setStyle(xlsStyle)


Java:

# Create a style for the cell
xlsStyle = gateway.jvm.ExcelStyle()
xlsStyle.setFormat("$0.00")

# Apply the style to the cell
xlsCell.setStyle(xlsStyle)

ExcelStyle xlsStyle = xlsTable.easy_getCell(0,0).getStyle();
xlsStyle.setFormat(Format.FORMAT_GENERAL);

Dim xlsStyle As ExcelStyle = xlsTable.easy_getCell(0, 0).getStyle()
xlsStyle.setFormat(Format.FORMAT_GENERAL)

C++

EasyXLS::IExcelStylePtr xlsStyle = xlsTable->easy_getCell(0, 0)->getStyle();
xlsStyle->setFormat(FORMAT_FORMAT_GENERAL);


C++.NET

ExcelStyle ^xlsStyle = xlsTable->easy_getCell(0, 0)->getStyle();
xlsStyle->setFormat(Format::FORMAT_GENERAL);

ExcelStyle xlsStyle = xlsTable.easy_getCell(0,0).getStyle();
xlsStyle.setFormat(Format.FORMAT_GENERAL);

.NET:

$xlsStyle = $xlsTable->easy_getCell(0,0)->getStyle();
$xlsStyle->setFormat($FORMAT_FORMAT_GENERAL);


Java:

$xlsStyle = $xlsTable->easy_getCell(0,0)->getStyle();
$xlsStyle->setFormat($FORMAT_FORMAT_GENERAL);

Set xlsStyle = xlsTable.easy_getCell(0,0).getStyle()
xlsStyle.setFormat(FORMAT_FORMAT_GENERAL)

Set xlsStyle = xlsTable.easy_getCell(0,0).getStyle()
xlsStyle.setFormat(FORMAT_FORMAT_GENERAL)

set xlsStyle = xlsTable.easy_getCell(0,0).getStyle()
xlsStyle.setFormat(FORMAT_FORMAT_GENERAL)

<cfobject type="java" class="EasyXLS.ExcelStyle" name="xlsStyle" action="CREATE">
<cfset xlsStyle = xlsTable.easy_getCell(0,0).getStyle()>
<cfset xlsStyle.setFormat(Format.FORMAT_GENERAL)>

.NET:

xlsStyle = xlsTable.easy_getCell(0,0).getStyle()
xlsStyle.setFormat(Format.FORMAT_GENERAL)


Java:

xlsStyle = xlsTable.easy_getCell(0,0).getStyle()
xlsStyle.setFormat(gateway.jvm.Format.FORMAT_GENERAL)

// Apply integer format
ExcelStyle xlsStyleInteger = new ExcelStyle();
xlsStyleInteger.setFormat(Format.FORMAT_INTEGER);
xlsCell.setStyle(xlsStyleInteger);

// Apply decimal format
ExcelStyle xlsStyleDecimals = new ExcelStyle();
xlsStyleDecimals.setFormat(Format.FORMAT_FLOAT_2DECIMALS);
xlsCell.setStyle(xlsStyleDecimals);

// Format with red color for negative numbers
ExcelStyle xlsStyleNegative = new ExcelStyle();
xlsStyleNegative.setFormat("0.00_);[Red](0.00)");
xlsCell.setStyle(xlsStyleNegative);

' Apply integer format
Dim xlsStyleInteger As ExcelStyle = New ExcelStyle()
xlsStyleInteger.setFormat(Format.FORMAT_INTEGER)
xlsCell.setStyle(xlsStyleInteger)

' Apply decimal format
Dim xlsStyleDecimals As ExcelStyle = New ExcelStyle()
xlsStyleDecimals.setFormat(Format.FORMAT_FLOAT_2DECIMALS)
xlsCell.setStyle(xlsStyleDecimals)

' Format with red color for negative numbers
Dim xlsStyleNegative As ExcelStyle = New ExcelStyle()
xlsStyleNegative.setFormat("0.00_);[Red](0.00)")
xlsCell.setStyle(xlsStyleNegative)

C++

// Apply integer format
EasyXLS::IExcelStylePtr xlsStyleInteger;
hr = CoCreateInstance(__uuidof(EasyXLS::ExcelStyle),
	              NULL,
	              CLSCTX_ALL,
	              __uuidof(EasyXLS::IExcelStyle),
	              (void**)&xlsStyleInteger);
xlsStyleInteger->setFormat(FORMAT_FORMAT_INTEGER);
xlsCell->setStyle(xlsStyleInteger);

// Apply decimal format
EasyXLS::IExcelStylePtr xlsStyleDecimals;
hr = CoCreateInstance(__uuidof(EasyXLS::ExcelStyle),
	              NULL,
	              CLSCTX_ALL,
	              __uuidof(EasyXLS::IExcelStyle),
	              (void**)&xlsStyleDecimals);
xlsStyleDecimals->setFormat(FORMAT_FORMAT_FLOAT_2DECIMALS);
xlsCell->setStyle(xlsStyleDecimals);

// Format with red color for negative numbers
EasyXLS::IExcelStylePtr xlsStyleNegative;
hr = CoCreateInstance(__uuidof(EasyXLS::ExcelStyle),
	              NULL,
	              CLSCTX_ALL,
	              __uuidof(EasyXLS::IExcelStyle),
	              (void**)&xlsStyleNegative);
xlsStyleNegative->setFormat("0.00_);[Red](0.00)");
xlsCell->setStyle(xlsStyleNegative);


C++.NET

// Apply integer format
ExcelStyle ^xlsStyleInteger = gcnew ExcelStyle();
xlsStyleInteger->setFormat(Format::FORMAT_INTEGER);
xlsCell->setStyle(xlsStyleInteger);

// Apply decimal format
ExcelStyle ^xlsStyleDecimals = gcnew ExcelStyle();
xlsStyleDecimals->setFormat(Format::FORMAT_FLOAT_2DECIMALS);
xlsCell->setStyle(xlsStyleDecimals);

// Format with red color for negative numbers
ExcelStyle ^xlsStyleNegative = gcnew ExcelStyle();
xlsStyleNegative->setFormat("0.00_);[Red](0.00)");
xlsCell->setStyle(xlsStyleNegative);

// Apply integer format
ExcelStyle xlsStyleInteger = new ExcelStyle();
xlsStyleInteger.setFormat(Format.FORMAT_INTEGER);
xlsCell.setStyle(xlsStyleInteger);

// Apply decimal format
ExcelStyle xlsStyleDecimals = new ExcelStyle();
xlsStyleDecimals.setFormat(Format.FORMAT_FLOAT_2DECIMALS);
xlsCell.setStyle(xlsStyleDecimals);

// Format with red color for negative numbers
ExcelStyle xlsStyleNegative = new ExcelStyle();
xlsStyleNegative.setFormat("0.00_);[Red](0.00)");
xlsCell.setStyle(xlsStyleNegative);

.NET:

// Apply integer format
$xlsStyleInteger = new COM("EasyXLS.ExcelStyle");
$xlsStyleInteger->setFormat($FORMAT_FORMAT_INTEGER);
$xlsCell->setStyle($xlsStyleInteger);

// Apply decimal format
$xlsStyleDecimals = new COM("EasyXLS.ExcelStyle");
$xlsStyleDecimals->setFormat($FORMAT_FORMAT_FLOAT_2DECIMALS);
$xlsCell->setStyle($xlsStyleDecimals);

// Format with red color for negative numbers
$xlsStyleNegative = new COM("EasyXLS.ExcelStyle");
$xlsStyleNegative->setFormat("0.00_);[Red](0.00)");
$xlsCell->setStyle($xlsStyleNegative);
	

Java:

// Apply integer format
$xlsStyleInteger = new java("EasyXLS.ExcelStyle");
$xlsStyleInteger->setFormat($FORMAT_FORMAT_INTEGER);
$xlsCell->setStyle($xlsStyleInteger);

// Apply decimal format
$xlsStyleDecimals = new java("EasyXLS.ExcelStyle");
$xlsStyleDecimals->setFormat($FORMAT_FORMAT_FLOAT_2DECIMALS);
$xlsCell->setStyle($xlsStyleDecimals);

// Format with red color for negative numbers
$xlsStyleNegative = new java("EasyXLS.ExcelStyle");
$xlsStyleNegative->setFormat("0.00_);[Red](0.00)");
$xlsCell->setStyle($xlsStyleNegative);

' Apply integer format
set xlsStyleInteger = Server.CreateObject("EasyXLS.ExcelStyle")
xlsStyleInteger.setFormat(FORMAT_FORMAT_INTEGER)
xlsCell.setStyle(xlsStyleInteger)

' Apply decimal format
set xlsStyleDecimals = Server.CreateObject("EasyXLS.ExcelStyle")
xlsStyleDecimals.setFormat(FORMAT_FORMAT_FLOAT_2DECIMALS)
xlsCell.setStyle(xlsStyleDecimals)

' Format with red color for negative numbers
set xlsStyleNegative = Server.CreateObject("EasyXLS.ExcelStyle")
xlsStyleNegative.setFormat("0.00_);[Red](0.00)")
xlsCell.setStyle(xlsStyleNegative)

' Apply integer format
Set xlsStyleInteger = CreateObject("EasyXLS.ExcelStyle")
xlsStyleInteger.setFormat(FORMAT_FORMAT_INTEGER)
xlsCell.setStyle(xlsStyleInteger)

' Apply decimal format
Set xlsStyleDecimals = CreateObject("EasyXLS.ExcelStyle")
xlsStyleDecimals.setFormat(FORMAT_FORMAT_FLOAT_2DECIMALS)
xlsCell.setStyle(xlsStyleDecimals)

' Format with red color for negative numbers
Set xlsStyleNegative = CreateObject("EasyXLS.ExcelStyle")
xlsStyleNegative.setFormat("0.00_);[Red](0.00)")
xlsCell.setStyle(xlsStyleNegative)

' Apply integer format
set xlsStyleInteger = CreateObject("EasyXLS.ExcelStyle")
xlsStyleInteger.setFormat(FORMAT_FORMAT_INTEGER)
xlsCell.setStyle(xlsStyleInteger)

' Apply decimal format
set xlsStyleDecimals = CreateObject("EasyXLS.ExcelStyle")
xlsStyleDecimals.setFormat(FORMAT_FORMAT_FLOAT_2DECIMALS)
xlsCell.setStyle(xlsStyleDecimals)

' Format with red color for negative numbers
set xlsStyleNegative = CreateObject("EasyXLS.ExcelStyle")
xlsStyleNegative.setFormat("0.00_);[Red](0.00)")
xlsCell.setStyle(xlsStyleNegative)

<!-- Apply integer format -->
<cfobject type="java" class="EasyXLS.ExcelStyle" 
          name="xlsStyleInteger" action="CREATE">
<cfset xlsStyleInteger.setFormat(Format.FORMAT_INTEGER)>
<cfset xlsCell.setStyle(xlsStyleInteger)>

<!-- Apply decimal format -->
<cfobject type="java" class="EasyXLS.ExcelStyle" 
          name="xlsStyleDecimals" action="CREATE">
<cfset xlsStyleDecimals.setFormat(Format.FORMAT_FLOAT_2DECIMALS)>
<cfset xlsCell.setStyle(xlsStyleDecimals)>

<!-- Format with red color for negative numbers -->
<cfobject type="java" class="EasyXLS.ExcelStyle" 
          name="xlsStyleNegative" action="CREATE">
<cfset xlsStyleNegative.setFormat("0.00_);[Red](0.00)")>
<cfset xlsCell.setStyle(xlsStyleNegative)>

.NET:

# Apply integer format
xlsStyleInteger = ExcelStyle()
xlsStyleInteger.setFormat(Format.FORMAT_INTEGER)
xlsCell.setStyle(xlsStyleInteger)

# Apply decimal format
xlsStyleDecimals = ExcelStyle()
xlsStyleDecimals.setFormat(Format.FORMAT_FLOAT_2DECIMALS)
xlsCell.setStyle(xlsStyleDecimals)

# Format with red color for negative numbers
xlsStyleNegative = ExcelStyle()
xlsStyleNegative.setFormat("0.00_);[Red](0.00)")
xlsCell.setStyle(xlsStyleNegative)


Java:

# Apply integer format
xlsStyleInteger = gateway.jvm.ExcelStyle()
xlsStyleInteger.setFormat(gateway.jvm.Format.FORMAT_INTEGER)
xlsCell.setStyle(xlsStyleInteger)

# Apply decimal format
xlsStyleDecimals = gateway.jvm.ExcelStyle()
xlsStyleDecimals.setFormat(gateway.jvm.Format.FORMAT_FLOAT_2DECIMALS)
xlsCell.setStyle(xlsStyleDecimals)

# Format with red color for negative numbers
xlsStyleNegative = gateway.jvm.ExcelStyle()
xlsStyleNegative.setFormat("0.00_);[Red](0.00)")
xlsCell.setStyle(xlsStyleNegative)

// Apply currency format
ExcelStyle xlsStyleCurrency = new ExcelStyle();
xlsStyleCurrency.setFormat(Format.FORMAT_CURRENCY);
xlsCell.setStyle(xlsStyleCurrency);

// Format with red color for negative numbers
ExcelStyle xlsStyleNegative = new ExcelStyle();
xlsStyleNegative.setFormat("$#,##0.00_);[Red]($#,##0.00)");
xlsCell.setStyle(xlsStyleNegative);

' Apply currency format
Dim xlsStyleCurrency As ExcelStyle = New ExcelStyle()
xlsStyleCurrency.setFormat(Format.FORMAT_CURRENCY)
xlsCell.setStyle(xlsStyleCurrency)

' Format with red color for negative numbers
Dim xlsStyleNegative As ExcelStyle = New ExcelStyle()
xlsStyleNegative.setFormat("$#,##0.00_);[Red]($#,##0.00)")
xlsCell.setStyle(xlsStyleNegative)

C++

// Apply currency format
EasyXLS::IExcelStylePtr xlsStyleCurrency;
hr = CoCreateInstance(__uuidof(EasyXLS::ExcelStyle),
	              NULL,
	              CLSCTX_ALL,
	              __uuidof(EasyXLS::IExcelStyle),
	              (void**)&xlsStyleCurrency);
xlsStyleCurrency->setFormat(FORMAT_FORMAT_CURRENCY);
xlsCell->setStyle(xlsStyleCurrency);

// Format with red color for negative numbers
EasyXLS::IExcelStylePtr xlsStyleNegative;
hr = CoCreateInstance(__uuidof(EasyXLS::ExcelStyle),
	              NULL,
	              CLSCTX_ALL,
	              __uuidof(EasyXLS::IExcelStyle),
	              (void**)&xlsStyleNegative);
xlsStyleNegative->setFormat("$#,##0.00_);[Red]($#,##0.00)");
xlsCell->setStyle(xlsStyleNegative);


C++.NET

// Apply currency format
ExcelStyle ^xlsStyleCurrency = gcnew ExcelStyle();
xlsStyleCurrency->setFormat(Format::FORMAT_CURRENCY);
xlsCell->setStyle(xlsStyleCurrency);

// Format with red color for negative numbers
ExcelStyle ^xlsStyleNegative = gcnew ExcelStyle();
xlsStyleNegative->setFormat("$#,##0.00_);[Red]($#,##0.00)");
xlsCell->setStyle(xlsStyleNegative);

// Apply currency format
ExcelStyle xlsStyleCurrency = new ExcelStyle();
xlsStyleCurrency.setFormat(Format.FORMAT_CURRENCY);
xlsCell.setStyle(xlsStyleCurrency);

// Format with red color for negative numbers
ExcelStyle xlsStyleNegative = new ExcelStyle();
xlsStyleNegative.setFormat("$#,##0.00_);[Red]($#,##0.00)");
xlsCell.setStyle(xlsStyleNegative);

.NET:

// Apply currency format
$xlsStyleCurrency = new COM("EasyXLS.ExcelStyle");
$xlsStyleCurrency->setFormat($FORMAT_FORMAT_CURRENCY);
$xlsCell->setStyle($xlsStyleCurrency);

// Format with red color for negative numbers
$xlsStyleNegative = new COM("EasyXLS.ExcelStyle");
$xlsStyleNegative->setFormat("$#,##0.00_);[Red]($#,##0.00)");
$xlsCell->setStyle($xlsStyleNegative);
	

Java:

// Apply currency format
$xlsStyleCurrency = new java("EasyXLS.ExcelStyle");
$xlsStyleCurrency->setFormat($FORMAT_FORMAT_CURRENCY);
$xlsCell->setStyle($xlsStyleCurrency);

// Format with red color for negative numbers
$xlsStyleNegative = new java("EasyXLS.ExcelStyle");
$xlsStyleNegative->setFormat("$#,##0.00_);[Red]($#,##0.00)");
$xlsCell->setStyle($xlsStyleNegative);

' Apply currency format
set xlsStyleCurrency = Server.CreateObject("EasyXLS.ExcelStyle")
xlsStyleCurrency.setFormat(FORMAT_FORMAT_CURRENCY)
xlsCell.setStyle(xlsStyleCurrency)

' Format with red color for negative numbers
set xlsStyleNegative = Server.CreateObject("EasyXLS.ExcelStyle")
xlsStyleNegative.setFormat("$#,##0.00_);[Red]($#,##0.00)")
xlsCell.setStyle(xlsStyleNegative)

' Apply currency format
Set xlsStyleCurrency = CreateObject("EasyXLS.ExcelStyle")
xlsStyleCurrency.setFormat(FORMAT_FORMAT_CURRENCY)
xlsCell.setStyle(xlsStyleCurrency)

' Format with red color for negative numbers
Set xlsStyleNegative = CreateObject("EasyXLS.ExcelStyle")
xlsStyleNegative.setFormat("$#,##0.00_);[Red]($#,##0.00)")
xlsCell.setStyle(xlsStyleNegative)

' Apply currency format
set xlsStyleCurrency = CreateObject("EasyXLS.ExcelStyle")
xlsStyleCurrency.setFormat(FORMAT_FORMAT_CURRENCY)
xlsCell.setStyle(xlsStyleCurrency)

' Format with red color for negative numbers
set xlsStyleNegative = CreateObject("EasyXLS.ExcelStyle")
xlsStyleNegative.setFormat("$#,##0.00_);[Red]($#,##0.00)")
xlsCell.setStyle(xlsStyleNegative)

<!-- Apply currency format -->
<cfobject type="java" class="EasyXLS.ExcelStyle" 
          name="xlsStyleCurrency" action="CREATE">
<cfset xlsStyleCurrency.setFormat(Format.FORMAT_CURRENCY)>
<cfset xlsCell.setStyle(xlsStyleCurrency)>

<!-- Format with red color for negative numbers -->
<cfobject type="java" class="EasyXLS.ExcelStyle" 
          name="xlsStyleNegative" action="CREATE">
<cfset xlsStyleNegative.setFormat("$##,####0.00_);[Red]($##,####0.00)")>
<cfset xlsCell.setStyle(xlsStyleNegative)>

.NET:

# Apply currency format
xlsStyleCurrency = ExcelStyle()
xlsStyleCurrency.setFormat(Format.FORMAT_CURRENCY)
xlsCell.setStyle(xlsStyleCurrency)

# Format with red color for negative numbers
xlsStyleNegative = ExcelStyle()
xlsStyleNegative.setFormat("$#,##0.00_);[Red]($#,##0.00)")
xlsCell.setStyle(xlsStyleNegative)


Java:

# Apply currency format
xlsStyleCurrency = gateway.jvm.ExcelStyle()
xlsStyleCurrency.setFormat(gateway.jvm.Format.FORMAT_CURRENCY)
xlsCell.setStyle(xlsStyleCurrency)

# Format with red color for negative numbers
xlsStyleNegative = gateway.jvm.ExcelStyle()
xlsStyleNegative.setFormat("$#,##0.00_);[Red]($#,##0.00)")
xlsCell.setStyle(xlsStyleNegative)

// Apply accounting format
ExcelStyle xlsStyleAccounting = new ExcelStyle();
xlsStyleAccounting.setFormat("_($* #,##0.00_);_($* (#,##0.00);_($* \"-\"??_);_(@_)");
xlsCell.setStyle(xlsStyleAccounting);

' Apply accounting format
Dim xlsStyleAccounting As ExcelStyle = New ExcelStyle()
xlsStyleAccounting.setFormat("_($* #,##0.00_);_($* (#,##0.00);_($* ""-""??_);_(@_)")
xlsCell.setStyle(xlsStyleAccounting)

C++

// Apply accounting format
EasyXLS::IExcelStylePtr xlsStyleAccounting;
hr = CoCreateInstance(__uuidof(EasyXLS::ExcelStyle),
		      NULL,
		      CLSCTX_ALL,
		      __uuidof(EasyXLS::IExcelStyle),
		      (void**) &xlsStyleAccounting);
xlsStyleAccounting->setFormat("_($* #,##0.00_);_($* (#,##0.00);_($* \"-\"??_);_(@_)");
xlsCell->setStyle(xlsStyleAccounting);


C++.NET

// Apply accounting format
ExcelStyle ^xlsStyleAccounting = gcnew ExcelStyle();
xlsStyleAccounting->setFormat("_($* #,##0.00_);_($* (#,##0.00);_($* \"-\"??_);_(@_)");
xlsCell->setStyle(xlsStyleAccounting);

// Apply accounting format
ExcelStyle xlsStyleAccounting = new ExcelStyle();
xlsStyleAccounting.setFormat("_($* #,##0.00_);_($* (#,##0.00);_($* \"-\"??_);_(@_)");
xlsCell.setStyle(xlsStyleAccounting);

.NET:

// Apply accounting format
$xlsStyleAccounting = new COM("EasyXLS.ExcelStyle");
$xlsStyleAccounting->setFormat("_($* #,##0.00_);_($* (#,##0.00);_($* \"-\"??_);_(@_)");
$xlsCell->setStyle($xlsStyleAccounting);


Java:

// Apply accounting format
$xlsStyleAccounting = new java("EasyXLS.ExcelStyle");
$xlsStyleAccounting->setFormat("_($* #,##0.00_);_($* (#,##0.00);_($* \"-\"??_);_(@_)");
$xlsCell->setStyle($xlsStyleAccounting);

' Apply accounting format
set xlsStyleAccounting = Server.CreateObject("EasyXLS.ExcelStyle")
xlsStyleAccounting.setFormat("_($* #,##0.00_);_($* (#,##0.00);_($* ""-""??_);_(@_)")
xlsCell.setStyle(xlsStyleAccounting)

' Apply accounting format
Set xlsStyleAccounting = CreateObject("EasyXLS.ExcelStyle")
xlsStyleAccounting.setFormat("_($* #,##0.00_);_($* (#,##0.00);_($* ""-""??_);_(@_)")
xlsCell.setStyle(xlsStyleAccounting)

' Apply accounting format
set xlsStyleAccounting = CreateObject("EasyXLS.ExcelStyle")
xlsStyleAccounting.setFormat("_($* #,##0.00_);_($* (#,##0.00);_($* ""-""??_);_(@_)")
xlsCell.setStyle(xlsStyleAccounting)

<!-- Apply accounting format -->
<cfobject type="java" class="EasyXLS.ExcelStyle" 
          name="xlsStyleAccounting" action="CREATE">
<cfset xlsStyleAccounting.setFormat(
       "_($* ##,####0.00_);_($* (##,####0.00);_($* ""-""??_);_(@_)")>
<cfset xlsCell.setStyle(xlsStyleAccounting)>

.NET:

# Apply accounting format
xlsStyleAccounting = ExcelStyle()
xlsStyleAccounting.setFormat("_($* #,##0.00_);_($* (#,##0.00);_($* \"-\"??_);_(@_)")
xlsCell.setStyle(xlsStyleAccounting)


Java:

# Apply accounting format
xlsStyleAccounting = gateway.jvm.ExcelStyle()
xlsStyleAccounting.setFormat("_($* #,##0.00_);_($* (#,##0.00);_($* \"-\"??_);_(@_)")
xlsCell.setStyle(xlsStyleAccounting)

// Apply date format
ExcelStyle xlsStyleDate = new ExcelStyle();
xlsStyleDate.setFormat(Format.FORMAT_DATE);
xlsCell1.setStyle(xlsStyleDate);

// Apply date format with regional settings
ExcelStyle xlsStyleDateRegional = new ExcelStyle();
xlsStyleDateRegional.setFormat(Format.FORMAT_DATE_REGIONAL_SETTINGS);
xlsCell2.setStyle(xlsStyleDateRegional);

' Apply date format
Dim xlsStyleDate As ExcelStyle = New ExcelStyle()
xlsStyleDate.setFormat(Format.FORMAT_DATE)
xlsCell1.setStyle(xlsStyleDate)

' Apply date format with regional settings
Dim xlsStyleDateRegional As ExcelStyle = New ExcelStyle()
xlsStyleDateRegional.setFormat(Format.FORMAT_DATE_REGIONAL_SETTINGS)
xlsCell2.setStyle(xlsStyleDateRegional)

C++

// Apply date format
EasyXLS::IExcelStylePtr xlsStyleDate;
hr = CoCreateInstance(__uuidof(EasyXLS::ExcelStyle),
	              NULL,
	              CLSCTX_ALL,
	              __uuidof(EasyXLS::IExcelStyle),
	              (void**)&xlsStyleDate);
xlsStyleDate->setFormat(FORMAT_FORMAT_DATE);
xlsCell1->setStyle(xlsStyleDate);

// Apply date format with regional settings
EasyXLS::IExcelStylePtr xlsStyleDateRegional;
hr = CoCreateInstance(__uuidof(EasyXLS::ExcelStyle),
	              NULL,
	              CLSCTX_ALL,
	              __uuidof(EasyXLS::IExcelStyle),
	              (void**)&xlsStyleDateRegional);
xlsStyleDateRegional->setFormat(FORMAT_FORMAT_DATE_REGIONAL_SETTINGS);
xlsCell2->setStyle(xlsStyleDateRegional);


C++.NET

// Apply date format
ExcelStyle ^xlsStyleDate = gcnew ExcelStyle();
xlsStyleDate->setFormat(Format::FORMAT_DATE);
xlsCell1->setStyle(xlsStyleDate);

// Apply date format with regional settings
ExcelStyle ^xlsStyleDateRegional = gcnew ExcelStyle();
xlsStyleDateRegional->setFormat(Format::FORMAT_DATE_REGIONAL_SETTINGS);
xlsCell2->setStyle(xlsStyleDateRegional);

// Apply date format
ExcelStyle xlsStyleDate = new ExcelStyle();
xlsStyleDate.setFormat(Format.FORMAT_DATE);
xlsCell1.setStyle(xlsStyleDate);

// Apply date format with regional settings
ExcelStyle xlsStyleDateRegional = new ExcelStyle();
xlsStyleDateRegional.setFormat(Format.FORMAT_DATE_REGIONAL_SETTINGS);
xlsCell2.setStyle(xlsStyleDateRegional);

.NET:

// Apply date format
$xlsStyleDate = new COM("EasyXLS.ExcelStyle");
$xlsStyleDate->setFormat($FORMAT_FORMAT_DATE);
$xlsCell1->setStyle($xlsStyleDate);

// Apply date format with regional settings
$xlsStyleDateRegional = new COM("EasyXLS.ExcelStyle");
$xlsStyleDateRegional->setFormat($FORMAT_FORMAT_DATE_REGIONAL_SETTINGS);
$xlsCell2->setStyle($xlsStyleDateRegional);
	

Java:

// Apply date format
$xlsStyleDate = new java("EasyXLS.ExcelStyle");
$xlsStyleDate->setFormat($FORMAT_FORMAT_DATE);
$xlsCell1->setStyle($xlsStyleDate);

// Apply date format with regional settings
$xlsStyleDateRegional = new java("EasyXLS.ExcelStyle");
$xlsStyleDateRegional->setFormat($FORMAT_FORMAT_DATE_REGIONAL_SETTINGS);
$xlsCell2->setStyle($xlsStyleDateRegional);

' Apply date format
set xlsStyleDate = Server.CreateObject("EasyXLS.ExcelStyle")
xlsStyleDate.setFormat(FORMAT_FORMAT_DATE)
xlsCell1.setStyle(xlsStyleDate)

' Apply date format with regional settings
set xlsStyleDateRegional = Server.CreateObject("EasyXLS.ExcelStyle")
xlsStyleDateRegional.setFormat(FORMAT_FORMAT_DATE_REGIONAL_SETTINGS)
xlsCell2.setStyle(xlsStyleDateRegional)

' Apply date format
Set xlsStyleDate = CreateObject("EasyXLS.ExcelStyle")
xlsStyleDate.setFormat(FORMAT_FORMAT_DATE)
xlsCell1.setStyle(xlsStyleDate)

' Apply date format with regional settings
Set xlsStyleDateRegional = CreateObject("EasyXLS.ExcelStyle")
xlsStyleDateRegional.setFormat(FORMAT_FORMAT_DATE_REGIONAL_SETTINGS)
xlsCell2.setStyle(xlsStyleDateRegional)

' Apply date format
set xlsStyleDate = CreateObject("EasyXLS.ExcelStyle")
xlsStyleDate.setFormat(FORMAT_FORMAT_DATE)
xlsCell1.setStyle(xlsStyleDate)

' Apply date format with regional settings
set xlsStyleDateRegional = CreateObject("EasyXLS.ExcelStyle")
xlsStyleDateRegional.setFormat(FORMAT_FORMAT_DATE_REGIONAL_SETTINGS)
xlsCell2.setStyle(xlsStyleDateRegional)

<!-- Apply date format -->
<cfobject type="java" class="EasyXLS.ExcelStyle" 
          name="xlsStyleDate" action="CREATE">
<cfset xlsStyleDate.setFormat(Format.FORMAT_DATE)>
<cfset xlsCell1.setStyle(xlsStyleDate)>

<!-- Apply date format with regional settings -->
<cfobject type="java" class="EasyXLS.ExcelStyle" 
          name="xlsStyleDateRegional" action="CREATE">
<cfset xlsStyleDateRegional.setFormat(Format.FORMAT_DATE_REGIONAL_SETTINGS)>
<cfset xlsCell2.setStyle(xlsStyleDateRegional)>

.NET:

# Apply date format
xlsStyleDate = ExcelStyle()
xlsStyleDate.setFormat(Format.FORMAT_DATE)
xlsCell1.setStyle(xlsStyleDate)

# Apply date format with regional settings
xlsStyleDateRegional = ExcelStyle()
xlsStyleDateRegional.setFormat(Format.FORMAT_DATE_REGIONAL_SETTINGS)
xlsCell2.setStyle(xlsStyleDateRegional)


Java:

# Apply date format
xlsStyleDate = gateway.jvm.ExcelStyle()
xlsStyleDate.setFormat(gateway.jvm.Format.FORMAT_DATE)
xlsCell1.setStyle(xlsStyleDate)

# Apply date format with regional settings
xlsStyleDateRegional = gateway.jvm.ExcelStyle()
xlsStyleDateRegional.setFormat(gateway.jvm.Format.FORMAT_DATE_REGIONAL_SETTINGS)
xlsCell2.setStyle(xlsStyleDateRegional)

// Apply time format
ExcelStyle xlsStyleTime = new ExcelStyle();
xlsStyleTime .setFormat("HH:mm:ss");
xlsCell1.setStyle(xlsStyleTime);

// Apply date time format with regional settings
ExcelStyle xlsStyleDateRegional = new ExcelStyle();
xlsStyleDateRegional.setFormat(Format.FORMAT_DATE_AND_TIME_REGIONAL_SETTINGS);
xlsCell2.setStyle(xlsStyleDateRegional);

' Apply time format
Dim xlsStyleTime As ExcelStyle = New ExcelStyle()
xlsStyleTime.setFormat("HH:mm:ss")
xlsCell1.setStyle(xlsStyleTime)

' Apply date time format with regional settings
Dim xlsStyleDateRegional As ExcelStyle = New ExcelStyle()
xlsStyleDateRegional.setFormat(Format.FORMAT_DATE_AND_TIME_REGIONAL_SETTINGS)
xlsCell2.setStyle(xlsStyleDateRegional)

C++

// Apply time format
EasyXLS::IExcelStylePtr xlsStyleTime;
hr = CoCreateInstance(__uuidof(EasyXLS::ExcelStyle),
	              NULL,
	              CLSCTX_ALL,
	              __uuidof(EasyXLS::IExcelStyle),
	              (void**)&xlsStyleTime);
xlsStyleTime->setFormat("HH:mm:ss");
xlsCell1->setStyle(xlsStyleTime);

// Apply date time format with regional settings
EasyXLS::IExcelStylePtr xlsStyleDateRegional;
hr = CoCreateInstance(__uuidof(EasyXLS::ExcelStyle),
	              NULL,
	              CLSCTX_ALL,
	              __uuidof(EasyXLS::IExcelStyle),
	              (void**)&xlsStyleDateRegional);
xlsStyleDateRegional->setFormat(FORMAT_FORMAT_DATE_AND_TIME_REGIONAL_SETTINGS);
xlsCell2->setStyle(xlsStyleDateRegional);


C++.NET

// Apply time format
ExcelStyle ^xlsStyleTime = gcnew ExcelStyle();
xlsStyleTime->setFormat("HH:mm:ss");
xlsCell1->setStyle(xlsStyleTime);

// Apply date time format with regional settings
ExcelStyle ^xlsStyleDateRegional = gcnew ExcelStyle();
xlsStyleDateRegional->setFormat(Format::FORMAT_DATE_AND_TIME_REGIONAL_SETTINGS);
xlsCell2->setStyle(xlsStyleDateRegional);

// Apply time format
ExcelStyle xlsStyleTime = new ExcelStyle();
xlsStyleTime .setFormat("HH:mm:ss");
xlsCell1.setStyle(xlsStyleTime);

// Apply date time format with regional settings
ExcelStyle xlsStyleDateRegional = new ExcelStyle();
xlsStyleDateRegional.setFormat(Format.FORMAT_DATE_AND_TIME_REGIONAL_SETTINGS);
xlsCell2.setStyle(xlsStyleDateRegional);

.NET:

// Apply time format
$xlsStyleTime = new COM("EasyXLS.ExcelStyle");
$xlsStyleTime->setFormat("HH:mm:ss");
$xlsCell1->setStyle($xlsStyleTime);

// Apply date time format with regional settings
$xlsStyleDateRegional = new COM("EasyXLS.ExcelStyle");
$xlsStyleDateRegional->setFormat($FORMAT_FORMAT_DATE_AND_TIME_REGIONAL_SETTINGS);
$xlsCell2->setStyle($xlsStyleDateRegional);
	

Java:

// Apply time format
$xlsStyleTime = new java("EasyXLS.ExcelStyle");
$xlsStyleTime->setFormat("HH:mm:ss");
$xlsCell1->setStyle($xlsStyleTime);

// Apply date time format with regional settings
$xlsStyleDateRegional = new java("EasyXLS.ExcelStyle");
$xlsStyleDateRegional->setFormat($FORMAT_FORMAT_DATE_AND_TIME_REGIONAL_SETTINGS);
$xlsCell2->setStyle($xlsStyleDateRegional);

' Apply time format
set xlsStyleTime = Server.CreateObject("EasyXLS.ExcelStyle")
xlsStyleTime.setFormat("HH:mm:ss")
xlsCell1.setStyle(xlsStyleTime)

' Apply date time format with regional settings
set xlsStyleDateRegional = Server.CreateObject("EasyXLS.ExcelStyle")
xlsStyleDateRegional.setFormat(FORMAT_FORMAT_DATE_AND_TIME_REGIONAL_SETTINGS)
xlsCell2.setStyle(xlsStyleDateRegional)

' Apply time format
Set xlsStyleTime = CreateObject("EasyXLS.ExcelStyle")
xlsStyleTime.setFormat("HH:mm:ss")
xlsCell1.setStyle(xlsStyleTime)

' Apply date time format with regional settings
Set xlsStyleDateRegional = CreateObject("EasyXLS.ExcelStyle")
xlsStyleDateRegional.setFormat(FORMAT_FORMAT_DATE_AND_TIME_REGIONAL_SETTINGS)
xlsCell2.setStyle(xlsStyleDateRegional)

' Apply time format
set xlsStyleTime = CreateObject("EasyXLS.ExcelStyle")
xlsStyleTime.setFormat("HH:mm:ss")
xlsCell1.setStyle(xlsStyleTime)

' Apply date time format with regional settings
set xlsStyleDateRegional = CreateObject("EasyXLS.ExcelStyle")
xlsStyleDateRegional.setFormat(FORMAT_FORMAT_DATE_AND_TIME_REGIONAL_SETTINGS)
xlsCell2.setStyle(xlsStyleDateRegional)

<!-- Apply time format -->
<cfobject type="java" class="EasyXLS.ExcelStyle" 
          name="xlsStyleTime" action="CREATE">
<cfset xlsStyleTime.setFormat("HH:mm:ss")>
<cfset xlsCell1.setStyle(xlsStyleTime)>

<!-- Apply date time format with regional settings -->
<cfobject type="java" class="EasyXLS.ExcelStyle" 
          name="xlsStyleDateRegional" action="CREATE">
<cfset xlsStyleDateRegional.setFormat(Format.FORMAT_DATE_AND_TIME_REGIONAL_SETTINGS)>
<cfset xlsCell2.setStyle(xlsStyleDateRegional)>

.NET:

# Apply time format
xlsStyleTime = ExcelStyle()
xlsStyleTime.setFormat("HH:mm:ss")
xlsCell1.setStyle(xlsStyleTime)

# Apply date time format with regional settings
xlsStyleDateRegional = ExcelStyle()
xlsStyleDateRegional.setFormat(Format.FORMAT_DATE_AND_TIME_REGIONAL_SETTINGS)
xlsCell2.setStyle(xlsStyleDateRegional)


Java:

# Apply time format
xlsStyleTime = gateway.jvm.ExcelStyle()
xlsStyleTime.setFormat("HH:mm:ss")
xlsCell1.setStyle(xlsStyleTime)

# Apply date time format with regional settings
xlsStyleDateRegional = gateway.jvm.ExcelStyle()
xlsStyleDateRegional.setFormat(
                gateway.jvm.Format.FORMAT_DATE_AND_TIME_REGIONAL_SETTINGS)
xlsCell2.setStyle(xlsStyleDateRegional)

// Apply percentage format
ExcelStyle xlsStylePercentage = new ExcelStyle();
xlsStylePercentage.setFormat(Format.FORMAT_FLOAT_2DECIMALS_PERCENT);
xlsCell.setStyle(xlsStylePercentage);

' Apply percentage format
Dim xlsStylePercentage As ExcelStyle = New ExcelStyle()
xlsStylePercentage.setFormat(Format.FORMAT_FLOAT_2DECIMALS_PERCENT)
xlsCell.setStyle(xlsStylePercentage)

C++

// Apply percentage format
EasyXLS::IExcelStylePtr xlsStylePercentage;
hr = CoCreateInstance(__uuidof(EasyXLS::ExcelStyle),
		      NULL,
		      CLSCTX_ALL,
		      __uuidof(EasyXLS::IExcelStyle),
		      (void**) &xlsStylePercentage);
xlsStylePercentage->setFormat(FORMAT_FORMAT_FLOAT_2DECIMALS_PERCENT);
xlsCell->setStyle(xlsStylePercentage);


C++.NET

// Apply percentage format
ExcelStyle ^xlsStylePercentage = gcnew ExcelStyle();
xlsStylePercentage->setFormat(Format::FORMAT_FLOAT_2DECIMALS_PERCENT);
xlsCell->setStyle(xlsStylePercentage);

// Apply percentage format
ExcelStyle xlsStylePercentage = new ExcelStyle();
xlsStylePercentage.setFormat(Format.FORMAT_FLOAT_2DECIMALS_PERCENT);
xlsCell.setStyle(xlsStylePercentage);

.NET:

// Apply percentage format
$xlsStylePercentage = new COM("EasyXLS.ExcelStyle");
$xlsStylePercentage->setFormat($FORMAT_FORMAT_FLOAT_2DECIMALS_PERCENT);
$xlsCell->setStyle($xlsStylePercentage);


Java:

// Apply percentage format
$xlsStylePercentage = new java("EasyXLS.ExcelStyle");
$xlsStylePercentage->setFormat($FORMAT_FORMAT_FLOAT_2DECIMALS_PERCENT);
$xlsCell->setStyle($xlsStylePercentage);

' Apply percentage format
set xlsStylePercentage = Server.CreateObject("EasyXLS.ExcelStyle")
xlsStylePercentage.setFormat(FORMAT_FORMAT_FLOAT_2DECIMALS_PERCENT)
xlsCell.setStyle(xlsStylePercentage)

' Apply percentage format
Set xlsStylePercentage = CreateObject("EasyXLS.ExcelStyle")
xlsStylePercentage.setFormat(FORMAT_FORMAT_FLOAT_2DECIMALS_PERCENT)
xlsCell.setStyle(xlsStylePercentage)

' Apply percentage format
set xlsStylePercentage = CreateObject("EasyXLS.ExcelStyle")
xlsStylePercentage.setFormat(FORMAT_FORMAT_FLOAT_2DECIMALS_PERCENT)
xlsCell.setStyle(xlsStylePercentage)

<!-- Apply percentage format -->
<cfobject type="java" class="EasyXLS.ExcelStyle" 
          name="xlsStylePercentage" action="CREATE">
<cfset xlsStylePercentage.setFormat(Format.FORMAT_FLOAT_2DECIMALS_PERCENT)>
<cfset xlsCell.setStyle(xlsStylePercentage)>

.NET:

# Apply percentage format
xlsStylePercentage = ExcelStyle()
xlsStylePercentage.setFormat(Format.FORMAT_FLOAT_2DECIMALS_PERCENT)
xlsCell.setStyle(xlsStylePercentage)


Java:

# Apply percentage format
xlsStylePercentage = gateway.jvm.ExcelStyle()
xlsStylePercentage.setFormat(gateway.jvm.Format.FORMAT_FLOAT_2DECIMALS_PERCENT)
xlsCell.setStyle(xlsStylePercentage)