I am using a stream to add an image to my worksheet and it is working fine. But when I create a second worksheet in a separate web request, the image from the first will show up in the second. This only seems to happen when I have excel already open with the first worksheet and then open the second from the browser. It does not happen if I select "save" instead of "open" in the browser dialog.
Here is the code I use to populate the image:
MemoryStream stream = new MemoryStream();
worksheet.Pictures.Add(1, 1, stream);