How to Insert Image in Spreadsheet using vb.net

Creating a macro - Writing a Script - Using the API

How to Insert Image in Spreadsheet using vb.net

Postby npandit » Mon Dec 02, 2019 10:32 am

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
Open Office 4.1.7
npandit
 
Posts: 16
Joined: Mon Nov 11, 2019 10:09 am

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

Postby JeJe » Mon Dec 02, 2019 3:44 pm

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.
Openoffice 4.1.2
Windows 8
JeJe
Volunteer
 
Posts: 1028
Joined: Wed Mar 09, 2016 2:40 pm

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

Postby Lupp » Mon Dec 02, 2019 11:25 pm

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.
On Windows 10: LibreOffice 6.4 and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München
User avatar
Lupp
Volunteer
 
Posts: 2857
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

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

Postby npandit » Tue Dec 03, 2019 7:16 am

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?
Open Office 4.1.7
npandit
 
Posts: 16
Joined: Mon Nov 11, 2019 10:09 am


Return to Macros and UNO API

Who is online

Users browsing this forum: No registered users and 2 guests