属性

Cell的属性有:

Cell的方法有:

示例:

Dim Book As New XLS.Book() '定义一个Excel工作簿
Dim
Sheet As XLS.Sheet = Book.Sheets(0) '引用工作簿的第一个工作表
Dim
Style As XLS.Style = Book.NewStyle() '定义新样式
Style.ForeColor = Color.Red
'设置样式的字体颜色
Sheet(
0,0).Style = Style
Sheet(
0,0).Value = "邮件"
Sheet(
0,0).Hyperlink = "Mailto:zjtdr@21cn.net"
Sheet(1,0).Formula = "=1+3"
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/1160.htm