Page 1 of 1

How to Insert Image in Spreadsheet using vb.net

PostPosted: Mon Dec 02, 2019 10:32 am
by npandit
Can anyone suggest how to insert image into spreadsheet using vb.net code
I Want to insert one image at button click tried all the code available nothing seems to work
Can someone please provide code to insert the image?
Its really urgent

Re: How to Insert Image in Spreadsheet using vb.net

PostPosted: Mon Dec 02, 2019 3:44 pm
by JeJe
I suggest you look at threads like this and try and adapt:

viewtopic.php?f=20&t=81549

From the number of people here, there aren't many people using vb.net to automate OO - it might even be just you here who does that. And its going to be difficult for anyone who isn't to look at your problem.

Re: How to Insert Image in Spreadsheet using vb.net

PostPosted: Mon Dec 02, 2019 11:25 pm
by Lupp
npandit wrote:I want to insert one image at button click...


If you can tell where to get the image from, where to insert it, and in what way to anchor it...
...the described task might really be solvable in a simple way with good old Basic. Without describing to some detail what actually needs be done, you won't get anywhere.

To insist on using vb.net is next to certainly a useless complication.

Re: How to Insert Image in Spreadsheet using vb.net

PostPosted: Tue Dec 03, 2019 7:16 am
by npandit
I inserted image in calc sucessfully.
sSize.Width = 15500
sSize.Height = 15500
but after changing the height and width no image is displayed.Sheet remains blank
Can anyone suggest how to solve this issue?