Replace image of an existing picture

Aspose.Cells Product Family
1

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

2

Hi,

We have added your requested feature in our issue tracking system as feature enhancement (issue id: CELLSNET-15655). We will look into this feature and get back to you soon.

Thank You & Best Regards,

3

Hi,

Please download and try the latest version of Aspose.Cells from the following location:

http://www.aspose.com/community/files/51/.net-components/aspose.cells-for-.net/entry231670.aspx

Please refer to the following sample code for your requirement.

Picture pic = book.Worksheets[0].Pictures[0];
byte[] data = File.ReadAllBytes(@"F:\FileTemp\chart1.emf");
pic.Data = data;

Thank You & Best Regards,

4

I tried downloading the new version and got a "Cannot connect to Internet Information Server" message. The installer window shows "Starting IIS Metabase Transaction" when that happens.

Is there a way to just get the Aspose.Cells.dll directly?

Thanks,

Sig Isaac

5

Hi,

Please download and try the latest version of Aspose.Cells (dll only) from the following location.

http://www.aspose.com/community/files/51/.net-components/aspose.cells-for-.net/entry232019.aspx

Thank You & Best Regards,

6

Hi,

Please re-download the installer Aspose.Cells for .NET
v4.9.0: http://www.aspose.com/community/files/51/.net-components/aspose.cells-for-.net/entry231670.aspx
and
try installing the product again. We have fixed a possible installation
issue for the machines having no IIS installed.

Please do let us
know if you still find any installation issue now.