AnsweredAssumed Answered

Has anyone used Nintex Powershell action to get sheetname from an Excel file?

Question asked by smithaj on Jun 8, 2016
Latest reply on Jun 9, 2016 by cju@evolusys.ch

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!

Outcomes