0

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.

reelyard
  • 931
  • 1
  • 8
  • 29
  • possible duplicate of [how to get file properties?](http://stackoverflow.com/questions/7861886/how-to-get-file-properties) – sphair Oct 14 '13 at 11:27
  • What have you tried? There are enough tools for working with file system and Excel in `.NET` – Guru Stron Oct 14 '13 at 11:29
  • This question probably answers your question. http://stackoverflow.com/questions/536636/write-array-to-excel-range – broodrooster Oct 14 '13 at 11:47

1 Answers1

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.
Bolu
  • 8,696
  • 4
  • 38
  • 70