Note :: Declare in Separate module
'********************* Start Module Excel Variable declartion ********************
Public xlsApplication As Object
Public xlsWorkbook As Object
Public xlsSheet As Object
Public HeaderColumnNumber As Integer, HeaderRowNumber As Integer
Enum amdVerticalAlignment
amdCenter = -4108
amdBottom = -4107
amdTop = -4160
amdVjustify = -4130
End Enum
Enum amdHorizontalAlignment
amdJustify = -4130
amdLeft = -4131
amdCenter = -4108
amdRight = -4152
End Enum
Enum amdCellBroder
RightEdge = 2
LeftEdge = 1
TopEdge = 3
BottonEdge = 4
AllEdge = 5
End Enum
Enum amdBorderline
amdThink = 1
amdThick1 = 2
amdThick2 = 3
amdThick3 = 4
End Enum
Enum amdColors
Black = 1
White = 2
Red = 3
BrightGreen = 4
Blue = 5
Yellow = 6
Pink = 7
Turquoise = 8
DarkRed = 9
Green = 10
DarkBlue = 11
DarkYellow = 12
Violet = 13
Teal = 14
Grey25Per = 15
Grey50Per = 16
SkyBlue = 33
LightTurtoise = 34
LightGreen = 35
LightYellow = 36
PaleBlue = 37
Rose = 38
Lavender = 39
Tan = 40
LightBlue = 41
Aqua = 42
Lime = 43
Gold = 44
LightOrange = 45
Orange = 46
BlueGray = 47
Gray40Per = 48
DarkTeal = 49
SeaGreen = 50
DarkGreen = 51
OliveGreen = 52
Brown = 53
Plum = 54
Indigo = 55
Gray80Per = 56
End Enum
Enum ImgPosition
PageHeader = 0
PageFooter = 1
End Enum
Enum ImgPositionAlign
AlignLeft = 0
Alignright = 1
AlignCenter = 2
End Enum
'********************* end Module Excel Variable declartion ********************
Continue in Vb.Net - Write Excel File for all version Part 2 .....
No comments:
Post a Comment