I am using Muhimbi convert document action to convert .csv file to .xlsx format to be loaded into a SharePoint list. After I convert the file, I am using the Query Excel Services action to extract the column data into Collections. However, the Query Excel Services action REQUIRES that you provide the sheet name and the sheet name is changed through the convert action. Can I use Nintex Powersheel to get the sheet name from the .xlsx file? Can someone provide an example?
Thanks!