读书人

Dim sheet As Excel.Worksheet = work

发布时间: 2011-12-20 22:26:41 作者: rapoo

Dim sheet As Excel.Worksheet = worksheets.Item(1)出错。。
全部代码如下
Dim app As New Excel.Application
Dim workbooks As Excel.Workbooks
Dim workbook As Excel._Workbook = workbooks.Add(XlWBATemplate.xlWBATWorksheet)
Dim worksheets As Excel.Sheets = workbook.Worksheets
Dim sheet As Excel.Worksheet = worksheets.Item(1)

最后一句提示: Option Strict On 不允许从“System.Object”到“Excel.Worksheet”的隐式转换。
什么原因啊?


[解决办法]
Dim sheet As Excel.Worksheet = worksheets.Item(1)
改为
Dim sheet As Excel.Worksheet = worksheets.Sheets(1)

读书人网 >VB Dotnet

热点推荐