Most efficient way to collect input file metadata?

[mlauber71]

@jcjaldin you could use a list file node and a loop to get information (paths) and append them like this:

Can knime help me input words in excel automatically

I would’ve used a Chunk Loop Start node to isolate the individual rows of URLs generated by the List Files node. The Output of this node gets split into 2 branches: the 1st branch goes to a Table Row to Variable node which converts the URL into a variable which can then be used to tell an Excel Reader node which file to grab. the 2nd branch leads to a Cell Splitter node with an appropriate delimiter such as the forward slash, which allows you to isolate the file name portion of the URL. You c…

You might have to use newer nodes instead of deprecated ones.

Then you can extract further meta informations from files like when they have last been changed, size and so on:

Files/Folders Meta Info

And then specific to Excel you can use OpenPyxl from the bundled Python to extract specific informations from the Excel file itself (like author …):

Extract "Date Modified" from an Excel file

@salazachou in addition I built something to extract the properties via Python script. The time although seems to be UTC so might have to be converted. [image]