On occasion we have a need to create multiple document sets in a single library.
In the past I have always put the details (e.g. name and any other column values) into a csv file and used powershell to create the document sets using this data via import-csv and
$NewFolder = [Microsoft.Office.DocumentManagement.DocumentSets.DocumentSet]::Create($dlist.RootFolder,$docSetInfo.theName,$cType.Id, $docsetProperties)
However this time I need to take some values from a sharepoint list and use these as the values. Ordinarily I would export the list to a spreadsheet and then save the spreadsheet as a CSV file however one of the columns in the list is a multiple line of text column type and these values are lost in CSV format - probably due to line breaks in the values.
I see no corresponding import cmdlet for dealing with xlsx files so am woindering what my options are here?