View Single Post
  #1   Report Post  
mjohnson
 
Posts: n/a
Default How to add an image to a worksheet programmatically

I am trying automate adding a picture to an excel sheet using JScript
(I would imagine the language shouldn't matter that much). After doing
quite a bit of research I tried writing the following code but I get an
error saying that the 'Pictures' collection is null or not an object.
I can't seem to figure out what I should be doing:

var book = new ActiveXObject("OWC10.Spreadsheet");
var sheet = book.Worksheets[1];
var range = sheet.Range("A1");

range.Activate();
sheet.Pictures.Add( PATH_TO_LOGO_BMP );

Any suggestions? thanks for your help!