Hello, is it possible to get some metadata field info to a excel cell?
Example, I need to get object's status to a excel cell.
Can I import or call this with simple command or do I need some kind VBA script to it?
Hello, is it possible to get some metadata field info to a excel cell?
Example, I need to get object's status to a excel cell.
Can I import or call this with simple command or do I need some kind VBA script to it?
The Extension Kit add on has a module that should be able to do that.
https://catalog.m-files.com/shop/extension-kit-for-m-files/
You can also add M-Files properties in the Excel file via the M-Files tab: Add M-Files Property This is useful for instance when creating Excel templates.
I have used M-files tab, it only brings property from same excel's metadata.
What I need, is collect some metadata from other documents to together under a one excel sheet.
Excel_1
[PDF1] [Last modified][06.06.2023] <--------------------------------- PDF1 Last modified: 6.6.2023
[PDF2] [Last modified][12.11.2024] <--------------------------------- PDF2 Last modified: 12.11.2024
Alright, then you'll likely need some add-on like the Extension Kit suggested by bright-ideas.dk or develop this as a custom extension.
Hi,
The Excel Reader module in Extension Kit lets you search for objects you want to import into Excel and define the properties you'd like to include. Here's the documentation and use case examples for Excel Reader.
If you'd like to explore this and other modules in Extension Kit, you can sign up for a free trial: Unitfly Toolkit for M-Files | Free trial
Feel free to contact us here if you need more information or any further assistance.
Kind regards,
Ines from Unitfly
© 2024 M-Files, All Rights Reserved.