Display Text Whether Image Is Present

Legacy Poster

• 2013年11月04日 16:00

Hi all, can someone explain me how to display text (which is located in an excel DB) whether an image is present (also in the database excel) in a label template?

0

• 

  Permanently deleted user

  ★ BarTender Hero ★

  • 2013年11月06日 11:51

  How is the image included in the Excel spreadsheet?  As a filename in the cell, or embedded data?

   

  If it is a filename, in 10.1 you can add a print condition to the text, that will show the text object only when the specified field is not empty.  (In 10.0 and older this can be done by VB Script, but is harder to do.)

   

  If it is an image embedded directly into the cell, I'm not sure if you can do that.  We support images in MS Access fields but I don't think we can access images in Excel cells.  We use the OLEDB driver underneath and I don't think it supports reading the field as a binary "blob", therefore there's no way to detect whether it is empty or not.

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • 2013年11月06日 16:12

  I have 10.0. The filename is located in the excel sheet e.g. image1.png Can you help me out with an example VB script how it should look like?

  0

請登入寫評論。