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
Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
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,
Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
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,
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
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
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,
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.