Dim Book As New XLS.Book() '定义一个Excel工作簿
Dim Sheet As XLS.Sheet = Book.Sheets(0) '引用工作簿的第一个工作表
Dim Style As XLS.Style
= Book.NewStyle() '定义新样式
Style.BorderTop = XLS.LineStyleEnum.Thin
Style.BorderBottom =
XLS.LineStyleEnum.Thin
Style.BorderLeft =
XLS.LineStyleEnum.Thin
Style.BorderRight =
XLS.LineStyleEnum.Thin
Style.BorderColorTop =
Color.Red
Style.BorderColorBottom = Color.Red
Style.BorderColorLeft =
Color.Red
Style.BorderColorRight = Color.Red
For r As
Integer = 1
to
5
For c As
Integer =1
To
5
Sheet(r,c).Style = Style
Next
Next
Book.Save("c:\reports\test.xls")
Dim Proc As New Process
Proc.File = "c:\reports\test.xls"
Proc.Start()