EasyXLS

Styles.bas

Attribute VB_Name = "Styles"
Public AUTOFORMAT_NONE As Long
Public AUTOFORMAT_SIMPLE As Long
Public AUTOFORMAT_SIMPLE_SUBTOTAL As Long
Public AUTOFORMAT_CLASSIC1 As Long
Public AUTOFORMAT_CLASSIC1_SUBTOTAL As Long
Public AUTOFORMAT_CLASSIC1_RIGHT_TOTAL As Long
Public AUTOFORMAT_CLASSIC1_TOTALS As Long
Public AUTOFORMAT_CLASSIC2 As Long
Public AUTOFORMAT_CLASSIC2_SUBTOTAL As Long
Public AUTOFORMAT_CLASSIC3 As Long
Public AUTOFORMAT_CLASSIC3_SUBTOTAL As Long
Public AUTOFORMAT_ACCOUNTING1 As Long
Public AUTOFORMAT_ACCOUNTING1_SUBTOTAL As Long
Public AUTOFORMAT_ACCOUNTING1_RIGHT_TOTAL As Long
Public AUTOFORMAT_ACCOUNTING1_TOTALS As Long
Public AUTOFORMAT_ACCOUNTING2 As Long
Public AUTOFORMAT_ACCOUNTING2_SUBTOTAL As Long
Public AUTOFORMAT_ACCOUNTING3 As Long
Public AUTOFORMAT_ACCOUNTING3_SUBTOTAL As Long
Public AUTOFORMAT_ACCOUNTING4 As Long
Public AUTOFORMAT_ACCOUNTING4_SUBTOTAL As Long
Public AUTOFORMAT_COLORFUL1 As Long
Public AUTOFORMAT_COLORFUL1_SUBTOTAL As Long
Public AUTOFORMAT_COLORFUL2 As Long
Public AUTOFORMAT_COLORFUL2_SUBTOTAL As Long
Public AUTOFORMAT_COLORFUL2_RIGHT_TOTAL As Long
Public AUTOFORMAT_COLORFUL2_TOTALS As Long
Public AUTOFORMAT_COLORFUL3 As Long
Public AUTOFORMAT_COLORFUL3_SUBTOTAL As Long
Public AUTOFORMAT_COLORFUL3_RIGHT_TOTAL As Long
Public AUTOFORMAT_COLORFUL3_TOTALS As Long
Public AUTOFORMAT_LIST1 As Long
Public AUTOFORMAT_LIST1_SUBTOTAL As Long
Public AUTOFORMAT_LIST2 As Long
Public AUTOFORMAT_LIST2_SUBTOTAL As Long
Public AUTOFORMAT_LIST3 As Long
Public AUTOFORMAT_LIST3_SUBTOTAL As Long
Public AUTOFORMAT_3D_EFFECTS1 As Long
Public AUTOFORMAT_3D_EFFECTS1_SUBTOTAL As Long
Public AUTOFORMAT_3D_EFFECTS1_RIGHT_TOTAL As Long
Public AUTOFORMAT_3D_EFFECTS1_TOTALS As Long
Public AUTOFORMAT_3D_EFFECTS2 As Long
Public AUTOFORMAT_3D_EFFECTS2_SUBTOTAL As Long
Public AUTOFORMAT_EASYXLS1 As Long
Public AUTOFORMAT_EASYXLS1_SUBTOTAL As Long
Public AUTOFORMAT_EASYXLS2 As Long
Public AUTOFORMAT_EASYXLS2_SUBTOTAL As Long
Public AUTOFORMAT_EASYXLS3 As Long
Public AUTOFORMAT_EASYXLS3_SUBTOTAL As Long

Sub Initialize()
    AUTOFORMAT_NONE = 0
    AUTOFORMAT_SIMPLE = 1
    AUTOFORMAT_SIMPLE_SUBTOTAL = 2
    AUTOFORMAT_CLASSIC1 = 3
    AUTOFORMAT_CLASSIC1_SUBTOTAL = 4
    AUTOFORMAT_CLASSIC1_RIGHT_TOTAL = 5
    AUTOFORMAT_CLASSIC1_TOTALS = 6
    AUTOFORMAT_CLASSIC2 = 7
    AUTOFORMAT_CLASSIC2_SUBTOTAL = 8
    AUTOFORMAT_CLASSIC3 = 9
    AUTOFORMAT_CLASSIC3_SUBTOTAL = 10
    AUTOFORMAT_ACCOUNTING1 = 11
    AUTOFORMAT_ACCOUNTING1_SUBTOTAL = 12
    AUTOFORMAT_ACCOUNTING1_RIGHT_TOTAL = 13
    AUTOFORMAT_ACCOUNTING1_TOTALS = 14
    AUTOFORMAT_ACCOUNTING2 = 15
    AUTOFORMAT_ACCOUNTING2_SUBTOTAL = 16
    AUTOFORMAT_ACCOUNTING3 = 17
    AUTOFORMAT_ACCOUNTING3_SUBTOTAL = 18
    AUTOFORMAT_ACCOUNTING4 = 19
    AUTOFORMAT_ACCOUNTING4_SUBTOTAL = 20
    AUTOFORMAT_COLORFUL1 = 21
    AUTOFORMAT_COLORFUL1_SUBTOTAL = 22
    AUTOFORMAT_COLORFUL2 = 23
    AUTOFORMAT_COLORFUL2_SUBTOTAL = 24
    AUTOFORMAT_COLORFUL2_RIGHT_TOTAL = 25
    AUTOFORMAT_COLORFUL2_TOTALS = 26
    AUTOFORMAT_COLORFUL3 = 27
    AUTOFORMAT_COLORFUL3_SUBTOTAL = 28
    AUTOFORMAT_COLORFUL3_RIGHT_TOTAL = 29
    AUTOFORMAT_COLORFUL3_TOTALS = 30
    AUTOFORMAT_LIST1 = 31
    AUTOFORMAT_LIST1_SUBTOTAL = 32
    AUTOFORMAT_LIST2 = 33
    AUTOFORMAT_LIST2_SUBTOTAL = 34
    AUTOFORMAT_LIST3 = 35
    AUTOFORMAT_LIST3_SUBTOTAL = 36
    AUTOFORMAT_3D_EFFECTS1 = 37
    AUTOFORMAT_3D_EFFECTS1_SUBTOTAL = 38
    AUTOFORMAT_3D_EFFECTS1_RIGHT_TOTAL = 39
    AUTOFORMAT_3D_EFFECTS1_TOTALS = 40
    AUTOFORMAT_3D_EFFECTS2 = 41
    AUTOFORMAT_3D_EFFECTS2_SUBTOTAL = 42
    AUTOFORMAT_EASYXLS1 = 43
    AUTOFORMAT_EASYXLS1_SUBTOTAL = 44
    AUTOFORMAT_EASYXLS2 = 45
    AUTOFORMAT_EASYXLS2_SUBTOTAL = 46
    AUTOFORMAT_EASYXLS3 = 47
    AUTOFORMAT_EASYXLS3_SUBTOTAL = 48
End Sub

EasyXLS Excel components:

.NET
Excel Library for VB6
full COM+ version to import, export or convert Excel files
Excel Writer for VB6
COM+ version to create and export Excel files
Excel Reader for VB6
COM+ version to read and import Excel files
Download EasyXLS™ Excel Component for VB6

File formats:

MS Excel 97 - 2003
MS Excel 2007 - 2019
MS Excel 2021
Office 365
XLSXXLSMXLSBXLS
XMLHTMLCSVTXT