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

[ODYSSEUS]

The metadata are put in them as request by microsoft

I send you a snapshot of the metadata ++ application where you can see that the metadata are iregistred as xml

So I send you in attachd files a zip file containing only the xls files (that's not strategical files)

and I pass the command

exiftool -xmp:all -csv -r table_xls > table_recap_xls.csv

whitout success (no errors but

[ODYSSEUS]

As I said previously the metadata exists (generated by the genuine microsoft application ) and as you can see on the snashot in my previous post yous can see them with metadata++ application registred as XML

PLease write me by mail

I send you the complete dir in zip files contains these xls using dropbox or else

[Phil Harvey]

Unfortunately, the "File not found" error is likely because of the special characters in the file name.  Support for Unicode characters in Windows file names has been a real headache for me.

- Phil

[ODYSSEUS]

Re bonjour Phil

It's easier to test in live, so I send you a onedrive's link by MP  where you can download the dir including the xls file

As I said previously the metadata are generated with the excel application and you can see them using metadat++ apllication whre you can see that there are registred under xml

I use that command

exiftool -xmp:all -csv -r table_xls > table_recap_xls.csv

in attached file, you will find the target file generated by exiftool

[Phil Harvey]

OK.  I'll look into this as soon as I get a chance.  Give me a couple of days.

- Phil

[ODYSSEUS]

Unfortunately, the "File not found" error is likely because of the special characters in the file name.  Support for Unicode characters in Windows file names has been a real headache for me.

I delete this file and folder

This not product none effect and the problem stay insolved

I know that the encode char is a nightmare for all of us and microsoft add one more .



Well the pb seems to come from the recursive -r option because remeber that if we test on a single file we get the metadata


Thank you take the time you need. of course  and good afternoon for you

[Phil Harvey]

Sorry for the delay.

I don't get the same thing as you.  When I run this command

exiftool -xmp:all -csv -r Table_xls > out.csv

on Windows 10 with ExifTool 11.63 I get the attached .csv output file that shows "Creator" information for all of the xlsx files (but none of the xls files).

When I look at the files individually, I see the same thing.

The file you sent earlier ("Fiche passagers.xlsx"), I get a different output than the version you sent in the whole zipped directory.  The earlier version contained XMP Title, Subject and Creator, while the new one has only Creator.

So I am not able to reproduce the problems you are having.

- Phil