Main Menu

Excel Office 2019

Started by ODYSSEUS, August 12, 2019, 12:45:24 PM

Previous topic - Next topic

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?
...where DIR is the name of a directory/folder containing the images.  On Mac/Linux/PowerShell, use single quotes (') instead of double quotes (") around arguments containing a dollar sign ($).

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
...where DIR is the name of a directory/folder containing the images.  On Mac/Linux/PowerShell, use single quotes (') instead of double quotes (") around arguments containing a dollar sign ($).

ODYSSEUS


Phil Harvey

I get this with the file you sent:

> 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
...where DIR is the name of a directory/folder containing the images.  On Mac/Linux/PowerShell, use single quotes (') instead of double quotes (") around arguments containing a dollar sign ($).

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
...where DIR is the name of a directory/folder containing the images.  On Mac/Linux/PowerShell, use single quotes (') instead of double quotes (") around arguments containing a dollar sign ($).

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
...where DIR is the name of a directory/folder containing the images.  On Mac/Linux/PowerShell, use single quotes (') instead of double quotes (") around arguments containing a dollar sign ($).

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
...where DIR is the name of a directory/folder containing the images.  On Mac/Linux/PowerShell, use single quotes (') instead of double quotes (") around arguments containing a dollar sign ($).