EasyXLS

Fill.bas

Attribute VB_Name = "Fill"
Public FILL_GRADIENT_NONE As Long
Public FILL_GRADIENT_HORIZONTAL_TOP_TO_BOTTOM As Long
Public FILL_GRADIENT_HORIZONTAL_BOTTOM_TO_TOP As Long
Public FILL_GRADIENT_HORIZONTAL_EDGES_TO_CENTER As Long
Public FILL_GRADIENT_VERTICAL_LEFT_TO_RIGHT As Long
Public FILL_GRADIENT_VERTICAL_RIGHT_TO_LEFT As Long
Public FILL_GRADIENT_VERTICAL_EDGES_TO_CENTER As Long
Public FILL_GRADIENT_DIAGONAL_UP_UPPER_LEFT_TO_BOTTOM_RIGHT As Long
Public FILL_GRADIENT_DIAGONAL_UP_BOTTOM_RIGHT_TO_UPPER_LEFT As Long
Public FILL_GRADIENT_DIAGONAL_UP_CORNERS_TO_CENTER As Long
Public FILL_GRADIENT_DIAGONAL_DOWN_UPPER_RIGHT_TO_BOTTOM_LEFT As Long
Public FILL_GRADIENT_GRADIENT_DIAGONAL_DOWN_BOTTOM_LEFT_TO_UPPER_RIGHT As Long
Public FILL_GRADIENT_GRADIENT_DIAGONAL_DOWN_CORNERS_TO_CENTER As Long
Public FILL_GRADIENT_GRADIENT_FROM_UPPER_LEFT_CORNER As Long
Public FILL_GRADIENT_GRADIENT_FROM_UPPER_RIGHT_CORNER As Long
Public FILL_GRADIENT_GRADIENT_FROM_BOTTOM_LEFT_CORNER As Long
Public FILL_GRADIENT_GRADIENT_FROM_BOTTOM_RIGHT_CORNER As Long
Public FILL_GRADIENT_GRADIENT_FROM_CENTER As Long

Sub Initialize()
    FILL_GRADIENT_NONE = 0
    FILL_GRADIENT_HORIZONTAL_TOP_TO_BOTTOM = 1
    FILL_GRADIENT_HORIZONTAL_BOTTOM_TO_TOP = 2
    FILL_GRADIENT_HORIZONTAL_EDGES_TO_CENTER = 3
    FILL_GRADIENT_VERTICAL_LEFT_TO_RIGHT = 4
    FILL_GRADIENT_VERTICAL_RIGHT_TO_LEFT = 5
    FILL_GRADIENT_VERTICAL_EDGES_TO_CENTER = 6
    FILL_GRADIENT_DIAGONAL_UP_UPPER_LEFT_TO_BOTTOM_RIGHT = 7
    FILL_GRADIENT_DIAGONAL_UP_BOTTOM_RIGHT_TO_UPPER_LEFT = 8
    FILL_GRADIENT_DIAGONAL_UP_CORNERS_TO_CENTER = 9
    FILL_GRADIENT_DIAGONAL_DOWN_UPPER_RIGHT_TO_BOTTOM_LEFT = 10
    FILL_GRADIENT_GRADIENT_DIAGONAL_DOWN_BOTTOM_LEFT_TO_UPPER_RIGHT = 11
    FILL_GRADIENT_GRADIENT_DIAGONAL_DOWN_CORNERS_TO_CENTER = 12
    FILL_GRADIENT_GRADIENT_FROM_UPPER_LEFT_CORNER = 13
    FILL_GRADIENT_GRADIENT_FROM_UPPER_RIGHT_CORNER = 14
    FILL_GRADIENT_GRADIENT_FROM_BOTTOM_LEFT_CORNER = 15
    FILL_GRADIENT_GRADIENT_FROM_BOTTOM_RIGHT_CORNER = 16
    FILL_GRADIENT_GRADIENT_FROM_CENTER = 17
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