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

  • 8 June 2016
  • 1 reply
  • 4 views

Badge +1

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!


1 reply

Userlevel 5
Badge +9

You can maybe get the name from the result of this web request (Resources URI for Excel Services REST API, Sample URI For Excel Services REST API):

http://<ServerName>/_vti_bin/ExcelRest.aspx/Docs/Documents/sampleWorkbook.xlsx/model?$format=workbook

Hope this helps

Reply