I am trying to figure out how to use Aspose.Cells.Net to open an existing Excel 2007 file and replace a shape/picture with an updated image while preserving all of the other shape/picture properties of the original such as shading and special effects. I can easily create a new picture with the new image and place it where the original picture was, but I can't find a way to duplicate all of the original special shape effects like rounded corners, etc, that were created interactively in Excel.
What I'm looking for is a method like Picture.SetImage(string path) that can be used with an existing picture. Trying to update the Picture.Data member does not work since it is a read-only member. Using the Picture.SourceFullName property doesn't seem to work either -- the Excel file fails to open, and besides I don't want the picture to be linked but rather embedded in the document.
So what would be the best way to achieve this?
Thanks,
Sig Isaac