Display Text Whether Image Is Present 关注

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 评论

0
Avatar
Ian Einman
评论操作 固定链接

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
评论操作 固定链接

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?

请先登录再写评论。