We'd like to export data from an asp.net-page to excel. We tried this :
Dim oExcel as Excel.application
Dim OBook as Excel.Workbook
Dim oSheet as Excel.Worksheet
oExcel = New Excel.Application()
oBook = oExcel.Workbooks.Add
oSheet = oBook.Worksheets(1)
oSheet.Cells(1,1) = "hello"
oExcel.Visible = True
oExcel.UserControl = True
But we get an error :
Acces denied.
The ASP.NET process is not authorized to access the requested resource. For security reasons the default ASP.NET process identity is '(machinename)\ASPNET', which has limited privileges. Consider granting access rights to the resource to the ASP.NET process identity.
Can anyone help us please?
Thx a lot
greetz, gd082
Dim oExcel as Excel.application
Dim OBook as Excel.Workbook
Dim oSheet as Excel.Worksheet
oExcel = New Excel.Application()
oBook = oExcel.Workbooks.Add
oSheet = oBook.Worksheets(1)
oSheet.Cells(1,1) = "hello"
oExcel.Visible = True
oExcel.UserControl = True
But we get an error :
Acces denied.
The ASP.NET process is not authorized to access the requested resource. For security reasons the default ASP.NET process identity is '(machinename)\ASPNET', which has limited privileges. Consider granting access rights to the resource to the ASP.NET process identity.
Can anyone help us please?
Thx a lot
greetz, gd082