error while uploading same excel sheet again?

Question

0.00/5 (No votes)

See more:

System.IO.IOException: The process cannot access the file 'F:\Final\IQM SAMPLE WORK - Copy\File3\dotnet.xlsx' because it is being used by another process. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy) at System.IO.FileStream..ctor(String path, FileMode mode) at System.Web.HttpPostedFile.SaveAs(String filename) at System.Web.HttpPostedFileWrapper.SaveAs(String filename) at iqmsampleworks_project.Areas.admin.Controllers.adminController.import(HttpPostedFileBase file, HttpPostedFileBase file1) in f:\Final\IQM SAMPLE WORK - Copy\Areas\admin\Controllers\adminController.cs:line 69

Posted 16-Jan-14 18:28pm

sailaja12345672

Updated 19-Jan-14 18:07pm

Christian Graus

v2

Add a Solution

Comments

Sandeep Singh Shekhawat 17-Jan-14 0:36am

This file already opened before uploading. Please close the file and then try to upload it. It is not an MVC issue.

sailaja12345672 17-Jan-14 0:42am

im importing exel shhet once it works well while uploading and if a uploading second time it shoo close the file by codeong

2 solutions

Add a Solution

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

Christian Graus · Answer 1 · 2014-01-19T16:59:00

Solution 1

The error means what it says. You've done some file processing and left the file open, instead of closing it. Make sure you call 'close' methods and use using blocks for things that impliment idisposable.

Posted 19-Jan-14 16:59pm

Christian Graus

ZurdoDev · Answer 2 · 2014-01-20T06:02:00

Solution 2

You'll need to allow permissions to overwrite the file or you need to give it a different name when you save it the second time.

Posted 20-Jan-14 6:02am

ZurdoDev

Comments

Christian Graus 20-Jan-14 17:18pm

Wrong. The error does not mean it can't overwrite, it means it's already in use. No amount of permissions will change that. You are right that having a different name would make it work, but it would not fix the underlying issue.

ZurdoDev 20-Jan-14 17:42pm

Try it and you'll see.

Christian Graus 20-Jan-14 17:45pm

You're saying if I don't have permission to access a file, the error will say 'the file is open in another process' ?

ZurdoDev 20-Jan-14 17:48pm

No. The other process is IIS. Of course neither of us actually know since there is not enough information so settle down a little bit.

Christian Graus 20-Jan-14 17:51pm

Well, the fact is, I've seen this error, and it's NEVER been permissions, it's always been a handle left open. I am interested to know why you feel it could be anything else, because I've never seen a case where it was.

error while uploading same excel sheet again?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

error while uploading same excel sheet again?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us