access denied when downloading file from server, on local server working properly- shows error: 80070005 Access is denied

Question

0.00/5 (No votes)

See more:

C#

Response.AddHeader(&quot;content-disposition", "attachment;filename= Salary Slip.xls")
       Response.ContentType = "application/octectstream"

       Dim path As String = Server.MapPath("~/exportedfiles")
       If (Directory.Exists(path) = False) Then
           Directory.CreateDirectory(path)
       End If
       File.Delete(path + "Salary Slip.xlsx")


       Dim xlAppToExport As Microsoft.Office.Interop.Excel.Application = New Microsoft.Office.Interop.Excel.Application
       xlAppToExport.Workbooks.Add("")


       Dim xlWorkSheetToExport As Excel.Worksheet
       xlWorkSheetToExport = DirectCast(xlAppToExport.Sheets("Sheet1"), Excel.Worksheet)

Posted 21-Jan-16 19:01pm

neeraj_

Updated 21-Jan-16 20:29pm

v4

Add a Solution

Comments

Sinisa Hajnal 22-Jan-16 2:53am

The user who is logged in in your app (or the application account itself) has no access to server folder (and rightly so). You have to create public folder on the server for such access or provide a safe way to download and upload the file.

neeraj_ 22-Jan-16 3:51am

sir my data is not in a foder
thats are simple label value in asp:table control
which i want to download in a excel sheet

F-ES Sitecore 22-Jan-16 4:03am

What line throws the exception? Also what you're doing (automating Excel) isn't supported, it might work ok on your local machine but it's not going to work on a production environment, and you're almost certainly in violation of your license agreement.

neeraj_ 22-Jan-16 4:26am

Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005 Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)).

F-ES Sitecore 22-Jan-16 4:47am

I asked what line the error occurs on.

neeraj_ 22-Jan-16 5:13am

there are no error on local system
error occurred when run on server

F-ES Sitecore 22-Jan-16 5:16am

Again, not what I asked.

I wouldn't bother trying to fix this to be honest, you're not going to get it to work. Use the Excel ODBC driver, the XML SDK, or something like Aspose...those libraries are designed to manipulate excel files via asp.net, the code you are using isn't.

neeraj_ 22-Jan-16 6:02am

sir I'm ising follows-

Dim iRowCnt As Int16 = 4

xlWorkSheetToExport.Cells(2, 2) = "Salary Slip"

Dim range As Excel.Range = xlWorkSheetToExport.Cells(1, 4)

xlWorkSheetToExport.Range("A2:D2").MergeCells = True
xlWorkSheetToExport.Range("A2:D33").Borders.Value = 10

Dim q As Int16 = 9
For p As Int16 = 31 To ds.Tables(0).Columns.Count - 1
If ds.Tables(0).Columns(p).Caption = "Net" Then

xlWorkSheetToExport.Cells(33, 4) = ds.Tables(0).Rows(0)(p)
xlWorkSheetToExport.Cells(33, 3) = ds.Tables(0).Columns(p).Caption
Else
xlWorkSheetToExport.Cells(q - 1, 3) = ds.Tables(0).Columns(p).Caption
xlWorkSheetToExport.Cells(q - 1, 4) = ds.Tables(0).Rows(0)(p)

End If

q += 1
Next

For k As Int16 = 0 To ds.Tables(0).Columns.Count - 1
If k <= 30 Then
xlWorkSheetToExport.Cells(iRowCnt - 1, 1) = ds.Tables(0).Columns(k).Caption
If IsDBNull(ds.Tables(0).Rows(0)(k)) = True Then
xlWorkSheetToExport.Cells(iRowCnt - 1, 2) = 0

Else
xlWorkSheetToExport.Cells(iRowCnt - 1, 2) = ds.Tables(0).Rows(0)(k)
End If
iRowCnt += 1
Else
Exit For
End If
Next

Dim range1 As Excel.Range = xlAppToExport.ActiveCell.Worksheet.Cells(4, 1)
range1.AutoFormat()
xlWorkSheetToExport.SaveAs(path + "Salary Slip.xlsx")

xlAppToExport.Workbooks.Close()
xlAppToExport.Quit()
xlAppToExport = Nothing
xlWorkSheetToExport = Nothing
ScriptManager.RegisterClientScriptBlock(Me, GetType(Page), UniqueID, "javascript:alert('Downloaded Successfully');", True)

koolprasad2003 27-Jan-16 7:34am

Does issue resolved ?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Gunaprasad Shetty · Answer 1 · 2016-01-25T00:59:00

Hey hi,

The problem here is about setting the rights on the server,

On server you need to set the access rights to the Network User,
Please provide the rights to the IUSR and the Network User, also provide
the Network user to the folder in which the file is present.

The issue is caused because of access right conflicts.

koolprasad2003 · Answer 2 · 2016-01-25T01:18:00

When you code interop object in web based application, when you deploy your code in IIS you need below access permission/settings.
This is a COM permissions problem.
follow below steps
1.Start > Run > dcomcnfg (or "mmc -32" and then add the Component Services snap-in manually if you can’t find the app under step 3)
2.Navigate to Component Services > Computers > My Computer > DCOM Config
3.Locate the MS application giving you trouble (eg: "Microsoft Excel Application" for Excel or "Microsoft Word 97 – 2003 Document" for Word)
4.Right click > Properties
5.On the security tab: Select Customize under Launch and Activation Permissions and click Edit…
6.Add the account under which the site is running (eg: Network Service) and assign Local Launch & Local Activation permissions
------------------------------------

This seems to be an issue with Excel/Word/etc not having access to a profile when being started via the interop route.
1.Open Windows Explorer
2.Depending on whether you installed a 32bit or 64bit version of office you will need to do one┬á (or both) of the following:
1.32bit Office installation: Navigate to C:\Windows\System32\config\systemprofile
2.64bit Office installation: Navigate to C:\Windows\SysWOW64\config\systemprofile
3.Verify the folder "Desktop" exists (create it if it's not there)
4.Right click > Properties
5.On the security tab: Add the account under which the site is running (eg: Network Service) with default permissions (Read & execute; List folder contents; Read)

access denied when downloading file from server, on local server working properly- shows error: 80070005 Access is denied

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0