Edit

Share via

XlRangeAutoFormat Enum

  • Reference

Definition

Namespace:
Microsoft.Office.Interop.Excel
Assembly:
Microsoft.Office.Interop.Excel.dll

Specifies the predefined format when a range is automatically formatted.

public enum class XlRangeAutoFormat
public enum XlRangeAutoFormat
Public Enum XlRangeAutoFormat
Inheritance
Enum
XlRangeAutoFormat

Fields

Name Value Description
xlRangeAutoFormatSimple -4154

Simple.
xlRangeAutoFormatNone -4142

No specified format.
xlRangeAutoFormatClassic1 1

Classic 1.
xlRangeAutoFormatClassic2 2

Classic 2.
xlRangeAutoFormatClassic3 3

Classic 3.
xlRangeAutoFormatAccounting1 4

Accounting 1.
xlRangeAutoFormatAccounting2 5

Accounting 2.
xlRangeAutoFormatAccounting3 6

Accounting 3.
xlRangeAutoFormatColor1 7

Color 1.
xlRangeAutoFormatColor2 8

Color 2.
xlRangeAutoFormatColor3 9

Color 3.
xlRangeAutoFormatList1 10

List 1.
xlRangeAutoFormatList2 11

List 2.
xlRangeAutoFormatList3 12

List 3.
xlRangeAutoFormat3DEffects1 13

3-D effects 1.
xlRangeAutoFormat3DEffects2 14

3-D effects 2.
xlRangeAutoFormatLocalFormat1 15

Local Format 1.
xlRangeAutoFormatLocalFormat2 16

Local Format 2.
xlRangeAutoFormatAccounting4 17

Accounting 4.
xlRangeAutoFormatLocalFormat3 19

Local Format 3.
xlRangeAutoFormatLocalFormat4 20

Local Format 4.
xlRangeAutoFormatReport1 21

Report 1.
xlRangeAutoFormatReport2 22

Report 2.
xlRangeAutoFormatReport3 23

Report 3.
xlRangeAutoFormatReport4 24

Report 4.
xlRangeAutoFormatReport5 25

Report 5.
xlRangeAutoFormatReport6 26

Report 6.
xlRangeAutoFormatReport7 27

Report 7.
xlRangeAutoFormatReport8 28

Report 8.
xlRangeAutoFormatReport9 29

Report 9.
xlRangeAutoFormatReport10 30

Report 10.
xlRangeAutoFormatClassicPivotTable 31

Classic pivot table.
xlRangeAutoFormatTable1 32

Table 1.
xlRangeAutoFormatTable2 33

Table 2.
xlRangeAutoFormatTable3 34

Table 3.
xlRangeAutoFormatTable4 35

Table 4.
xlRangeAutoFormatTable5 36

Table 5.
xlRangeAutoFormatTable6 37

Table 6.
xlRangeAutoFormatTable7 38

Table 7.
xlRangeAutoFormatTable8 39

Table 8.
xlRangeAutoFormatTable9 40

Table 9.
xlRangeAutoFormatTable10 41

Table 10.
xlRangeAutoFormatPTNone 42

No specified pivot table format.

Applies to