Exif-Daten durch Excel(VBA)?

...komplette Frage anzeigen

1 Antwort

Zwei mögliche Ansätze

  1. VBA von Herber auf http://www.herber.de/forum/archiv/1192to1196/1192072_Exif_auslesen_bzw_Daten_aus_der_Datei.html
  2. das Commandline tool EXIFTOOL (Suchmaschine des Vertrauens findet das).  Als Beispiel liefert mir der Aufruf 
exiftool -a -u -g1 IMG_5924.jpg > out3.txt

dann den Output unten 

---- ExifTool ----

ExifTool Version Number : 8.50
Warning : [minor] Adjusted MakerNotes base by 4276
---- System ----
File Name : IMG_5924.jpg
Directory : .
File Size : 2.6 MB
File Modification Date/Time : 2008:04:09 12:47:30+02:00
File Permissions : rw-rw-rw-
---- File ----
File Type : JPEG
MIME Type : image/jpeg
Exif Byte Order : Big-endian (Motorola, MM)
Current IPTC Digest : b4190d6999d22df2010b591b6d2b9831
Image Width : 2336
Image Height : 3504
Encoding Process : Baseline DCT, Huffman coding
Bits Per Sample : 8
Color Components : 3
Y Cb Cr Sub Sampling : YCbCr4:4:0 (1 2)
---- JFIF ----
JFIF Version : 1.01
Resolution Unit : inches
X Resolution : 72
Y Resolution : 72
---- IFD0 ----
Make : Canon
Camera Model Name : Canon EOS 30D
Orientation : Horizontal (normal)
X Resolution : 72
Y Resolution : 72
Resolution Unit : inches
Software : Microsoft Windows Photo Gallery 6.0.6000.16386
Modify Date : 2008:04:05 18:05:25
Y Cb Cr Positioning : Co-sited
Copyright : Copyright (c) 2008. All rights reserved.
XP Comment : Urlaub auf Barbados, Bridgetown im April 2008
XP Subject : Urlaub auf Barbados, Bridgetown im April 2008
Padding : (Binary data 2060 bytes, use -b option to extract)
---- ExifIFD ----
Exposure Time : 1/250
F Number : 1.8
Exposure Program : Aperture-priority AE
ISO : 400
Exif Version : 0221
Date/Time Original : 2008:03:27 16:34:36
Create Date : 2008:03:27 16:34:36
Components Configuration : Y, Cb, Cr, -
Shutter Speed Value : 1/250
Aperture Value : 1.8
Exposure Compensation : 0
Metering Mode : Multi-segment
Flash : Off, Did not fire
Focal Length : 50.0 mm
User Comment : Urlaub auf Barbados, Bridgetown im April 2008
Flashpix Version : 0100
Color Space : sRGB
Exif Image Width : 2336
Exif Image Height : 3504
Focal Plane X Resolution : 3959.322034
Focal Plane Y Resolution : 3959.322034
Focal Plane Resolution Unit : inches
Custom Rendered : Normal
Exposure Mode : Auto
White Balance : Auto
Scene Capture Type : Standard
Padding : (Binary data 2060 bytes, use -b option to extract)
Offset Schema : 4222
---- Canon ----
Macro Mode : Normal
Self Timer : Off
Quality : Fine
Canon Flash Mode : Off
Continuous Drive : Single
Focus Mode : One-shot AF
Record Mode : CR2+JPEG
Canon Image Size : Large
Easy Mode : Manual
Digital Zoom : None
Contrast : Normal
Saturation : Normal
Sharpness : +3
Metering Mode : Evaluative
Focus Range : Not Known
Canon Exposure Mode : Aperture-priority AE
Lens Type : Unknown (-1)
Long Focal : 50 mm
Short Focal : 50 mm
Focal Units : 1/mm
Max Aperture : 1.8
Min Aperture : 22
Flash Activity : 0
Flash Bits : (none)
Focus Continuous : Single
Zoom Source Width : 0
Zoom Target Width : 0
Photo Effect : Off
Manual Flash Output : n/a
Color Tone : Normal
Focal Type : Fixed
Focal Length : 50 mm
Focal Plane X Size : 23.04 mm
Focal Plane Y Size : 15.37 mm
Canon Flash Info : 100 0 0 0
Auto ISO : 100
Base ISO : 400
Measured EV : 7.75
Target Aperture : 1.8
Target Exposure Time : 1/256
Exposure Compensation : 0
White Balance : Auto
Slow Shutter : None
Shot Number In Continuous Burst : 0
Optical Zoom Code : n/a
Camera Temperature : 25 C
Flash Guide Number : 0
Flash Exposure Compensation : 0
Auto Exposure Bracketing : Off
AEB Bracket Value : 0
Control Mode : Camera Local Control
F Number : 1.8
Exposure Time : 1/256
Measured EV 2 : 7.75
Bulb Duration : 0
Camera Type : EOS Mid-range
Auto Rotate : Rotate 270 CW
ND Filter : n/a
Self Timer 2 : 0
Canon Image Type : Canon EOS 30D
Canon Firmware Version : Firmware 1.0.5
Owner Name : unknown
Serial Number : 1230803901
Canon Model ID : EOS 30D
Num AF Points : 9
Valid AF Points : 9
Canon Image Width : 3504
Canon Image Height : 2336
AF Image Width : 3504
AF Image Height : 2336
AF Area Width : 78
AF Area Height : 78
AF Area X Positions : 8 -555 571 -931 8 947 -555 571 8
AF Area Y Positions : 504 270 270 4 4 4 -262 -262 -496
AF Points In Focus : 0,3,4,6
Thumbnail Image Valid Area : 0 159 7 112
Serial Number Format : Format 2
Canon 0x0019 : 1
Original Decision Data Offset : 0
File Number : 100-5924
Bracket Mode : Off
Bracket Value : 0
Bracket Shot Number : 0
Raw Jpg Quality : Fine
Raw Jpg Size : Large
Long Exposure Noise Reduction 2 : Off
WB Bracket Mode : Off
WB Bracket Value AB : 0
WB Bracket Value GM : 0
Filter Effect : None
Toning Effect : None
Lens Model : EF50mm f/1.8
Internal Serial Number : F0340546
Tone Curve : Standard
Sharpness : 3
Sharpness Frequency : n/a
Sensor Red Level : 0
Sensor Blue Level : 0
White Balance Red : 0
White Balance Blue : 0
Color Temperature : 5200
Picture Style : Standard
Digital Gain : 0
WB Shift AB : 0
WB Shift GM : 0
Measured RGGB : 840 1024 1024 537
Color Space : sRGB
VRD Offset : 0
Sensor Width : 3596
Sensor Height : 2360
Sensor Left Border : 84
Sensor Top Border : 19
Sensor Right Border : 3587
Sensor Bottom Border : 2354
Black Mask Left Border : 0
Black Mask Top Border : 0
Black Mask Right Border : 0
Black Mask Bottom Border : 0
Color Data Version : 1 (1DmkIIN/5D/30D/400D)
WB RGGB Levels As Shot : 1789 1024 1024 1896
Color Temp As Shot : 4295
WB RGGB Levels Auto : 1789 1024 1024 1896
Color Temp Auto : 4295
WB RGGB Levels Measured : 1788 1022 1025 1894
Color Temp Measured : 4295
WB RGGB Levels Daylight : 1978 1024 1024 1586
Color Temp Daylight : 5200
WB RGGB Levels Shade : 2280 1024 1024 1309
Color Temp Shade : 7000
WB RGGB Levels Cloudy : 2136 1024 1024 1436
Color Temp Cloudy : 6000
WB RGGB Levels Tungsten : 1621 1207 1207 2955
Color Temp Tungsten : 3200
WB RGGB Levels Fluorescent : 1824 1078 1078 2462
Color Temp Fluorescent : 3752
WB RGGB Levels Kelvin : 1978 1024 1024 1586
Color Temp Kelvin : 5190
WB RGGB Levels Flash : 2162 1024 1024 1393
Color Temp Flash : 6278
WB RGGB Levels PC1 : 8191 1024 1024 8191
Color Temp PC1 : 4461
WB RGGB Levels PC2 : 8191 1024 1024 8191
Color Temp PC2 : 4461
WB RGGB Levels PC3 : 8191 1024 1024 8191
Color Temp PC3 : 4461
WB RGGB Levels Custom : 1978 1024 1024 1586
Color Temp Custom : 5190
Camera Color Calibration 01 : -335 404 960 (10900K)
Camera Color Calibration 02 : -316 412 933 (10000K)
Camera Color Calibration 03 : -268 431 868 (8300K)
Camera Color Calibration 04 : -211 460 801 (7000K)
Camera Color Calibration 05 : -150 491 730 (6000K)
Camera Color Calibration 06 : -119 509 699 (5600K)
Camera Color Calibration 07 : -84 530 661 (5200K)
Camera Color Calibration 08 : -30 563 610 (4700K)
Camera Color Calibration 09 : 33 607 556 (4200K)
Camera Color Calibration 10 : 96 659 508 (3800K)
Camera Color Calibration 11 : 153 706 466 (3500K)
Camera Color Calibration 12 : 219 763 418 (3200K)
Camera Color Calibration 13 : 267 812 388 (3000K)
Camera Color Calibration 14 : 322 870 355 (2800K)
Camera Color Calibration 15 : 446 1028 294 (2400K)
Flash Output : 0%
Flash Battery Level : n/a
Measured RGGB Data : 48526 56942 56866 28745
Black Level : 129 129 129
Canon 0x4009 : 0 0 0
Custom Picture Style File Name :
Canon 0x4011 : [...]
---- CanonCustom ----
Set Function When Shooting : Default (no function)
Long Exposure Noise Reduction : Off
Flash Sync Speed Av : Auto
Shutter-AE Lock : AF/AE lock
AF Assist Beam : Emits
Exposure Level Increments : 1/3 Stop
Flash Firing : Fires
ISO Expansion : Off
AEB Sequence/Auto Cancel : 0,-,+/Enabled
Superimposed Display : On
Menu Button Display Position : Previous (top if power off)
Mirror Lockup : Disable
AF Point Selection Method : Normal
E-TTL II : Evaluative
Shutter Curtain Sync : 1st-curtain sync
Safety Shift In Av Or Tv : Disable
Magnified View : Image playback only
Lens AF Stop Button : AF stop
Add Original Decision Data : Off
---- InteropIFD ----
Interoperability Index : R98 - DCF basic file (sRGB)
Interoperability Version : 0100
---- IFD1 ----
Compression : JPEG (old-style)
X Resolution : 0.01041666667
Y Resolution : 0.01041666667
Resolution Unit : inches
Thumbnail Offset : 9188
Thumbnail Length : 4107
---- XMP-rdf ----
About : uuid:faf5bdd5-ba3d-11da-ad31-d33d75182f1b
---- XMP-xmp ----
Creatortool : Microsoft Windows Photo Gallery 6.0.6000.16386
---- XMP-tiff ----
Software : Microsoft Windows Photo Gallery 6.0.6000.16386
Orientation : Horizontal (normal)
---- XMP-dc ----
Description : Urlaub auf Barbados, Bridgetown im April 2008
Rights : Copyright (c) 2008. All rights reserved.
Subject : Urlaub, April 2008, Barbados
---- XMP-exif ----
User Comment : Urlaub auf Barbados, Bridgetown im April 2008
---- XMP-prefix48 ----
Location : Hilton Barbados Hotel
---- XMP-photoshop ----
Caption Writer : Hubert Daubmeier
City : Bridgetown
Country : Barbados
Urgency : 5 (normal urgency)
Date Created : 2008:03:27
---- XMP-microsoft ----
Last Keyword XMP : Urlaub, April 2008, Barbados
Last Keyword IPTC : Urlaub, April 2008, Barbados
---- IPTC ----
Caption-Abstract : Urlaub auf Barbados, Bridgetown im April 2008
Sub-location : Hilton Barbados Hotel
Writer-Editor : Hubert Daubmeier
City : Bridgetown
Country-Primary Location Name : Barbados
Copyright Notice : Copyright (c) 2008. All rights reserved.
Urgency : 5 (normal urgency)
Date Created : 2008:03:27
Keywords : Urlaub, April 2008, Barbados
---- Composite ----
Aperture : 1.8
Drive Mode : Single-frame Shooting
ISO : 400
Image Size : 2336x3504
Lens : 50.0 mm
Lens ID : Canon EF50mm f/1.8
Scale Factor To 35 mm Equivalent: 1.6
Shooting Mode : Aperture-priority AE
Shutter Speed : 1/250
Thumbnail Image : (Binary data 4107 bytes, use -b option to extract)
WB RGGB Levels : 1789 1024 1024 1896
Blue Balance : 1.851563
Circle Of Confusion : 0.019 mm
Field Of View : 26.0 deg
Focal Length : 50.0 mm (35 mm equivalent: 78.1 mm)
Hyperfocal Distance : 72.22 m
Lens : 50.0 mm (35 mm equivalent: 78.1 mm)
Light Value : 7.7
Red Balance : 1.74707

Was möchtest Du wissen?