I add a picture to column B in a worksheet through code. Later, based on few conditions, I have a requirement of deleting column A. The contents of column B move (left) except for the picture. It remains on 2nd column. Is there a way to make it move as well? Please note that I cannot use the “Move()” method available for Picture object as I delete column A after writing the entire worksheet and the worksheet has multiple pictures.
There are two ways to move pictures:
1. Put picture according if you will delete column
You can put picture at column A if you will delete the column and put it at column B if you won’t.
2. Use the Move method
Why can’t you call the move method? You can call it even you have written the whole worksheet. I enhanced Picture.Move method in latest hotfix. Please refer to http://www.aspose.com/Products/Aspose.Excel/Api/Aspose.Excel.Picture.Move.html.