Cannot access read-only document 'excel_filename.xls'

mary jean ligas

Iam working on c# console. what iam trying to do is to get excel template and insert all records in in excell and create a copy to save the excel to network shared folder using a impersonated specific user..but the error was "Cannot access read-only document 'excel_filename.xls'."" please see my code snippet see error SaveAsCopy

15 Replies

Know the answer? Post it — somebody with the same question will find it here.

mary jean ligas10y ago
Hi Sir Raj the error says "The name ReadOnly does not exists in the current context"
0
Rajeev Punhani10y ago
Hi Mary,
Please try
xlWorkBook = xlApp.Workbooks.Open(strReportTemplate, oMissing, false,
oMissing, oMissing, oMissing, oMissing, oMissing, oMissing,
oMissing, oMissing, oMissing, oMissing, oMissing, oMissing);
0
mary jean ligas10y ago
Thanks
0
Amatya Agyey10y ago
I dont know dear.. Have to wait for someone to reply... Its better to talk to your Server Admin.
0
mary jean ligas10y ago
what is the proper setting you will recommend?
0
Amatya Agyey10y ago
Oh... so make the setting proper dear
0
mary jean ligas10y ago
scenario: i use my pc with accouunt: mjtligas then in program i swicth account impersonated: s-iosgxrsu the shared folder in network drive in other pc has a full persmission to s-iosgxrsu in saving the file cannot access read-only document..that is the error
+1
Amatya Agyey10y ago
Your suspection might be right. Have you asked to your system admin to solve the issue?
0
mary jean ligas10y ago
hi sir Amtya I applied full permission in a file but I suspect that in launching excel file the user impersonated didn't applied so that in saving over the network the file is read only..
0
Amatya Agyey10y ago
Dear, If its working in ur local system, then in share folder you have to give the permission. Better ask to your System Admin. I think some restriction they have applied
0
mary jean ligas10y ago
have you seen my code?
0
mary jean ligas10y ago
sir Raj we have full permission set-up to the user account..i don't know how to why it is not working. The error is occur in SaveAsCopy part..
0
Rajeev Punhani10y ago
Hi Mary,
This issue can occur if you are saving to a network drive and you do not have sufficient privileges to save to that drive. Thus, you might not be able to access the file. File might be read-only and user is not allowed to access it. Read-only nature of a file implies that it is not allowed to access or modify a file. Please check folder permission.

0
mary jean ligas10y ago
it is working if the it is saved loacally but the target is to save it to shared network drive..please help
0
Rajeev Punhani10y ago
Hi Mary,
Try to save the Excel file locally and then check if you are able to access it.

0