使用VBA读取和列出EXIF数据 [英] Read and list exif data using vba

问题描述

我正在尝试在Excel电子表格中列出文件夹中每个图像的EXIF数据，例如焦距和曝光时间.有人有指针吗?我见过其他方法，但只列出了创建日期等内容，但没有列出EXIF数据(在图像属性的详细信息"选项卡中).我不确定这是否可以完成.

I am trying to list EXIF data for each image in a folder, such as focal length and exposure time, in an excel spreadsheet. Does anyone have any pointers? I have seen other method but only lists things like date created, etc., but never the EXIF data (in the "Details" tab in the image properties). I'm not sure this can even be done.

推荐答案

我认为这是一个好问题.您可以使用命令行工具exiv2提取exif以及iptc和xmp元数据.参见 http://www.exiv2.org/您可以从vba调用此工具，并按照以下说明获取结果: http://programmersheaven.com/discussion/167592/return-value-of-shell

I think that's a good question. You could use exiv2 a command line tool to extract exif as well as iptc and xmp metadata. see http://www.exiv2.org/ You could call this tool from vba and get the results back as described in: http://programmersheaven.com/discussion/167592/return-value-of-shell

我想知道是否有一个更简单的解决方案.

I wonder if there is an even simpler solution for that.

这篇关于使用VBA读取和列出EXIF数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！