Creating document sets from a spreadsheet

Question

I have a list of offices that I need to create document sets for using a custom document set content type. Anyone have any idea how to create a Powershell script to read the spreadsheet and create the document set?

Answer 1

First you need to access Excel Services with PowerShell and read your data. Then you need to Create a document set from that data. This is not an easy task. I would consider other alternatives.