|
Format |
Format Description |
Sample output |
Sample template formula |
|
0 |
General |
12345.67 |
EXCEL_WRITE 1, 0, 0, 2, 3, '12345.67' |
|
-12345.67 |
EXCEL_WRITE 1, 0, 0, 3, 3, '-12345.67' |
||
|
Hello World |
EXCEL_WRITE 2, 0, 0, 4, 3, 'Hello World' |
||
|
1 |
0 |
12346 |
EXCEL_WRITE 1, 1, 0, 5, 3, '12345.67' |
|
-12346 |
EXCEL_WRITE 1, 1, 0, 6, 3, '-12345.67' |
||
|
2 |
0.00 |
12345.67 |
EXCEL_WRITE 1, 2, 0, 7, 3, '12345.67' |
|
-12345.67 |
EXCEL_WRITE 1, 2, 0, 8, 3, '-12345.67' |
||
|
3 |
#,##0 |
12,346 |
EXCEL_WRITE 1, 3, 0, 9, 3, '12345.67' |
|
-12,346 |
EXCEL_WRITE 1, 3, 0, 10, 3, '-12345.67' |
||
|
4 |
#,##0.00 |
12,345.67 |
EXCEL_WRITE 1, 4, 0, 11, 3, '12345.67' |
|
-12,345.67 |
EXCEL_WRITE 1, 4, 0, 12, 3, '-12345.67' |
||
|
5 |
#,##0\ "$";\-#,##0\ "$" |
$12,346 |
EXCEL_WRITE 1, 5, 0, 13, 3, '12345.67' |
|
($12,346) |
EXCEL_WRITE 1, 5, 0, 14, 3, '-12345.67' |
||
|
6 |
#,##0\ "$";[Red]\-#,##0\ "$" |
$12,346 |
EXCEL_WRITE 1, 6, 0, 15, 3, '12345.67' |
|
($12,346) |
EXCEL_WRITE 1, 6, 0, 16, 3, '-12345.67' |
||
|
7 |
#,##0.00\ "$";\-#,##0.00\ "$" |
$12,345.67 |
EXCEL_WRITE 1, 7, 0, 17, 3, '12345.67' |
|
($12,345.67) |
EXCEL_WRITE 1, 7, 0, 18, 3, '-12345.67' |
||
|
8 |
#,##0.00\ "$";[Red]\-#,##0.00\ "$" |
$12,345.67 |
EXCEL_WRITE 1, 8, 0, 19, 3, '12345.67' |
|
($12,345.67) |
EXCEL_WRITE 1, 8, 0, 20, 3, '-12345.67' |
||
|
9 |
0% |
1234567% |
EXCEL_WRITE 1, 9, 0, 21, 3, '12345.67' |
|
-1234567% |
EXCEL_WRITE 1, 9, 0, 22, 3, '-12345.67' |
||
|
10 |
0.00% |
1234567.00% |
EXCEL_WRITE 1, 10, 0, 23, 3, '12345.67' |
|
-1234567.00% |
EXCEL_WRITE 1, 10, 0, 24, 3, '-12345.67' |
||
|
11 |
0.00E+00 |
1.23E+04 |
EXCEL_WRITE 1, 11, 0, 25, 3, '12345.67' |
|
-1.23E+04 |
EXCEL_WRITE 1, 11, 0, 26, 3, '-12345.67' |
||
|
12 |
dd/mm/yy |
12/25/05 |
EXCEL_WRITE 3, 12, 0, 27, 3, '12/25/2005 05:30:01' |
|
13 |
dd/\ mmm\ yy |
25-Dec-05 |
EXCEL_WRITE 3, 13, 0, 28, 3, '12/25/2005 05:30:01' |
|
14 |
dd/\ mmm |
25-Dec |
EXCEL_WRITE 3, 14, 0, 29, 3, '12/25/2005 05:30:01' |
|
15 |
mmm\ yy |
Dec-05 |
EXCEL_WRITE 3, 15, 0, 30, 3, '12/25/2005 05:30:01' |
|
16 |
h:mm\ AM/PM |
5:30 AM |
EXCEL_WRITE 3, 16, 0, 31, 3, '12/25/2005 05:30:01' |
|
17 |
h:mm:ss\ AM/PM |
5:30:01 AM |
EXCEL_WRITE 3, 17, 0, 32, 3, '12/25/2005 05:30:01' |
|
18 |
hh:mm |
5:30 |
EXCEL_WRITE 3, 18, 0, 33, 3, '12/25/2005 05:30:01' |
|
19 |
hh:mm:ss |
5:30:01 |
EXCEL_WRITE 3, 19, 0, 34, 3, '12/25/2005 05:30:01' |
|
20 |
dd/mm/yy\ hh:mm |
12/25/05 5:30 |
EXCEL_WRITE 3, 20, 0, 35, 3, '12/25/2005 05:30:01' |
|
21 |
yyyy/mm/dd\ hh:mm:ss |
2005/12/25 |
EXCEL_WRITE 3, 21, 0, 38, 3, '12/25/2005 05:30:01' |