Format
No.

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
05:30:01

EXCEL_WRITE 3, 21, 0, 38, 3, '12/25/2005 05:30:01'

Return to EXCEL_WRITE