斜线设置

和斜线设置有关的属性:

示例

Dim Book As New XLS.Book()
Dim
Sheet As XLS.Sheet = Book.Sheets(0)
Dim
Style As XLS.Style = Book.NewStyle()
Style.DiagonalStyle= XLS.LineStyleEnum.Thin
Style.DiagonalColor =Color.Red
Style.Diagonal = XLS.DiagonalEnum.Backward

For
r As Integer = 1 to 2
   
For c As Integer =1 To 2
        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()

生成的工作表:


本页地址:http://www.foxtable.com/webhelp/topics/1164.htm