AnsweredAssumed Answered

Error Query Excel Services

Question asked by darren1372 on May 7, 2015
Latest reply on Jul 24, 2017 by c.odegard

I have created a form with start and end date binded fields. I want to use the form as part of a holiday leave request app.

Therefore I have uploaded an Excel Spread sheet that is using the -=NETWORKDAYS fx to omit weekends and chosen holidays. I have set the date column (A3) and (B3) in the excel spreadsheet to short date (08/05/2015)  and the result field (f5)  to number.

In my SharePoint list I'm using a date and time column type for start and end date columns, with only date chosen (no time)

I've uploaded the excel spreadsheet to a document library called "Excel".

 

To note, I am doing this on a Nintex trial site. Both the site collection and site feature for excel services has been activated.

 

In my workflow on the list I have added a Query Excel function as configured below:


config3.jpg

 

 

I hit run now and test the connection and result turns OK for connection, but when I put the two dates in for cells A3 and B3 respectively and click execute it returns an error, see below:

 

config2.jpg

My Excel Spreadsheet:

 

excel.jpg

Outcomes