Excel Office 2019

[ODYSSEUS]

Hi

I try to download in a csv file the metadata registred in Excel files. (subject and title)

I can see that the metadata exists in the files but anywhere in Xmp Dubli Core Shema xmp-dc else in an other file in FlahPix

So I can't build the command line to extract them

I try this

exiftool.exe -XPComment -csv -r -lang fr -charset latin -ext xls -ext xlx -ext xlsx -ext xlsm -xmp-dc:all - table > table_sourcefile.csv

and other whithout any success

I think that I don't use the command -ext:all

Other wise it seems to be possible  to do something like this - ext"?" to select all the files ase xls xlms xlsx  and so on

Thanks for your help

[Phil Harvey]

Maybe try something like this:

exiftool -charset latin -xmp:all -csv -ext xls -ext xlms -ext xlsx ... DIR > out.csv

- Phil

Edit:  I see this is very close to what you have already tried.  I tested this myself for a few XLS files, and they didn't seem to have any XMP metadata.  The format does support XMP metadata, but perhaps it just isn't being written to the file?

[ODYSSEUS]

Hi Phil

Thank's a lot buts las I dont'get the metadata

I'm sure that's the metada exist and I can see them using a soft named metadata++ (which is build on exiftools)

But microsoft love to give us dark nightmare  to there users

So you will find in attached file a snapshot of it  if you want i can send you an excel flile

[Phil Harvey]

Send me the Excel file and I'll take a look.  My email is philharvey66 at gmail.com

- Phil

[ODYSSEUS]

Thanks a lot that's done

[Phil Harvey]

I get this with the file you sent:

Code Select Expand

> exiftool -xmp:all -csv "Fiche passagers.xlsx"
SourceFile,Title,Subject,Creator
Fiche passagers.xlsx,Fiche de renseignement passager,Plan de voyage Fiche passager,Pierre LIBERAS

- Phil

[ODYSSEUS]

OK Phil

That's right BUT

not when I do the same with -r

as

exiftool -xmp:all -csv -r table > table_recap_xlsl.csv

or else I try exiftool  -r  -xmp:all -csv table > table_recap_xlsl.csv


It seems that the recursive fonction -r cause a disturb

[ODYSSEUS]

else additionaly I try

exiftool  -r  -xmp:all -csv table

the redirection to print a file doesn't matter (of course)

[Phil Harvey]

What is the output of this command?:

dir table

- Phil

[ODYSSEUS]

when I do

exiftool  -r  -xmp:all -csv table 

I don't redirect to a file. It's just for checking in the window's command line if the redirection is not in cause.

Anyway,  the correct syntax is

exiftool  -r  -xmp:all -csv table > table_recap_xlsl.csv

and with -r that's not ok

[Phil Harvey]

I need more details.  What do you mean by "not ok"?  What messages does ExifTool show?  What is the directory listing of the "table" directory (ie. the output of "dir table" as I asked)?

- Phil

[ODYSSEUS]

Hi

you wil find in attached file the output of dir and the the file generate by exiftool when I do

exiftool  -r  -xmp:all -csv table > table_recap_xlsl.csv

[ODYSSEUS]

Perhaps you need a full dir

[ODYSSEUS]

Sorry but I forget to tell you that's other commands quite similar runs perfectly

as for exemple

exiftool.exe -csv -r -lang fr -charset latin -ext pdf -FileTypeExtension -pdf:title -pdf:subject  -pdf:author -pdf:keywords -pdf:ModifyDate table >table_recap_pdf.csv

exiftool.exe -csv -r -lang fr -charset latin -ext html -Title -description -author  -Keywords -FileModifyDate -FileTypeExtension table > table_recap_html.csv

Just the same for xls meta don't give any result

[Phil Harvey]

It it works for other file types but not xls, then it is because the xls doesn't contain the metadata you are looking for.

(I feel we're running around in circles here.)

- Phil