Display Text Whether Image Is Present Follow

0
Avatar
Legacy Poster

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?

2 comments

0
Avatar
Ian Einman
Comment actions Permalink

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
Avatar
Legacy Poster
Comment actions Permalink

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?

Please sign in to leave a comment.