如何在asp.net下调用excel?
我在asp.net下引用了excel 9.0,并在*.asp.vb文件中添加以下代码,
Imports System
Imports System.Data
Imports System.Data.SqlClient
Imports Excel
Private Sub 保存_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles 保存.Click
Dim xlApp As New Excel.Application()*这行出现错误*
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet
xlBook = xlApp.Workbooks().Add
xlSheet = xlBook.Worksheets("sheet1")
xlApp.Visible = True
End Sub
Private Sub EndDate_SelectionChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles EndDate.SelectionChanged
End Sub
但提示出现这样的错误:
异常详细信息: System.UnauthorizedAccessException: 拒绝访问。
未授权此 ASP.NET 进程访问所请求的资源。
大家知道这是怎么回事吗?谢谢回复。