Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Mon Aug 26, 2019 12:29 pm

Hello,
is it possible to extract an image plus shapes(line arrows) on top of it ? I am extracting the image with
Code: Select all
ExcelPicture picture = sheet.Pictures[0];
but am not able to see the line arrows, because they are added on top.
Code: Select all
sheet.PrstGeomShapes
is empty but i can inspect
Code: Select all
sheet.Shapes.InnerList
i assume the line arrows i need are in there, but i can't access them due to protection level.
Is there a way to get the image with the shapes on top ? Or atleast the shapes separately.

i am using the free version of spire.xls.

NikoBele
 
Posts: 2
Joined: Mon Aug 26, 2019 12:12 pm

Tue Aug 27, 2019 7:32 am

Hi,

Thanks for your inquiry.
Are the picture and the shape grouped in the Excel file?
Could you please offer us your input file for further investigation?

Best wishes,
Amber
E-iceblue support team
User avatar

Amber.Gu
 
Posts: 525
Joined: Tue Jun 04, 2019 3:16 am

Thu Aug 29, 2019 8:47 am

Hi,

i fixed it by grabbing the whole sheet as imga via
Code: Select all
Image image = sheet.ToImage(0, 0, 0, 0);


This works for me.

NikoBele
 
Posts: 2
Joined: Mon Aug 26, 2019 12:12 pm

Thu Aug 29, 2019 9:40 am

Hi,

Thank for your reply and glad to hear that you have managed to solve the issue by yourself.
Any question, welcome to contact us.

Best wishes,
Amber
E-iceblue support team
User avatar

Amber.Gu
 
Posts: 525
Joined: Tue Jun 04, 2019 3:16 am

Return to Spire.XLS