How to read file properties from many different files and save them to Excel

Question

First, thanks for trying to answer my question.

Ok, so I have loads of files (somewhere in the excess of about 500) from which I need to grab some of their properties. I need the File Name, Date Created, and Author and I'd like them to be saved into an Excel sheet.

Any idea on how I'd go about doing this? I've got a little bit of C# and VB.Net programming skills but not a lot. Anything you can do to help will be greatly appreciated!

Thanks.

Answer 1

1. get a way of parsing through all the files (e.g. Loop through the return result of Directory.GetFiles)
2. create a FileInfo object for each file, and then check properties you are looking for.
3. find an API to create the Excel file (e.g Excel interop) to create an Excel and insert your information of each file into a row.