Skip to main content

Hello,

I would like to insert a picture into a EXCEL CELL. I found a thread in this forum that explains how to insert a picture into an excel sheet :

   create application of excel handle in hexcelapp

   modify hexcelapp @SheetsInNewWorkBook = 1

   modify hexcelapp workbooks::add() giving hexcellibro

   inquire hexcellibro worksheets::item(1) in hexcelhoja

   modify hexcelhoja Pictures() giving hexcelpictures.

   modify hexcelpictures insert("c:\\iconta00\\infco.bmp")

   giving hexcelpicture.

   modify hexcelpicture @height = 150.

   modify hexcelpicture @width = 285.

   modify hexcelapp @visible = 1

  destroy hexcelhoja

  destroy hexcellibro

  destroy hexcelapp

but it is not enough for my needs.

I need to bind a cell to an image through its path.

Please, can you help me ?

thank you very much, regards.

Hello,

I would like to insert a picture into a EXCEL CELL. I found a thread in this forum that explains how to insert a picture into an excel sheet :

   create application of excel handle in hexcelapp

   modify hexcelapp @SheetsInNewWorkBook = 1

   modify hexcelapp workbooks::add() giving hexcellibro

   inquire hexcellibro worksheets::item(1) in hexcelhoja

   modify hexcelhoja Pictures() giving hexcelpictures.

   modify hexcelpictures insert("c:\\iconta00\\infco.bmp")

   giving hexcelpicture.

   modify hexcelpicture @height = 150.

   modify hexcelpicture @width = 285.

   modify hexcelapp @visible = 1

  destroy hexcelhoja

  destroy hexcellibro

  destroy hexcelapp

but it is not enough for my needs.

I need to bind a cell to an image through its path.

Please, can you help me ?

thank you very much, regards.

So you want to link an excel cell to an image right? Check following post and find some useful information.Big Smile

http://stackoverflow.com/questions/7406984/excel-2007-display-image-from-image-path

________________________________________

TAGS: Excel Reading   Add Image into Excel