Picture file lock after write image to an excel file

[bruce.luk]

hi Support
I am using asp.net to write a picture to an excel file.
I get a problem that such original picture file is locked by w3wp.exe process after excel is saved.
Please help. Thanks
Bruce

[Suvi.Wu]

Hello Bruce,

Sorry for the inconvenience caused by us and thank you for your inquiry. We simulated what you did(using asp.net to write a picture to an excel file), it works well. Would you please send us more informations to help us reproduce the issue? I also attached you the simple demo, please have a look.

Thanks in advance.
Have a great day.

BR
Suvi
e-iceblue support team

[bruce.luk]

hi Suvi,

I have sent an email to you describe the problem details. Please check whether you have received it.
Write picture to excel function works well. But the file will then be locked by web server w3wp.exe process. The file cannot be deleted unless we restart the IIS application pools.

Please help.

Thanks
Bruce

[Suvi.Wu]

Hello Bruce,

Sorry for this inconvenience caused by us and thank you for your patience with our support team.

We have sent you an E-mail to solve this problem. Please check your E-mail.

Have a great day.

BR
Suvi
e-iceblue support

[bruce.luk]

hi Suvi,

Received your email. Thanks for your follow up. It works for your suggested coding.

However, i cannot find the way to add multiple pictures in the same file. Please suggest.

Thanks & Best Regards,
Bruce

[bruce.luk]

hi Suvi, Harry,

Thank you for your suggested solution.
The coding works.

Best Regards,
Bruce

[harry.support]

You are welcome.
Please let us know if you have any other question.

[1030072]

hi Support,

i also have the same issue " the file will then be locked by web server w3wp.exe process. ",
would you kind give the solution..

Thanks.
Best Regards.

[Betsy.jiang]

Dear 1030072,

Thanks for your inquiry.
Here is a solution which may solve your issue, please have a try.

Code: Select all

Workbook wb = new Workbook();
Worksheet ws = wb.Worksheets[0];
String path = Server.MapPath("/adorable.jpg");
using (System.IO.FileStream stream = System.IO.File.OpenRead(path))
{
ws.Pictures.Add(1, 1, stream);
wb.SaveToFile(Server.MapPath("/test.xls"));
}

If the issue still persists, please provide us following information for investigation.
1)Input files.
2)The code you were using.
3)OS informtaion.

Thanks,
Betsy
E-iceblue support team

[Betsy.jiang]

Dear 1030072,

How is the issue now ?
I will appreciate it if you could give us some feedback.

Thanks,
Betsy
E-iceblue support team