cancel
Showing results for 
Search instead for 
Did you mean: 

Loda data from Excel worksheet tab into a Collection results in an error.

PeterLomi
Level 3
We are loading data from an Excel worksheet tab into a Collection, using a copy of the MS Excel VBO object.  (We have added an action or two to the base VBO, but we have NOT modified any base code provided by BP.)  We are using the "Get Worksheet As Collection" action.  We get an error in the session log upon executing the action: "ERROR: Internal: Could not execute code stage because exception thrown by code stage: Value cannot be null.  Parameter name: s" in the session log when we run the action.  There are 3 input parameters and 2 output parameters associated with this action.  Of these, only 1 begins with an "s": sheetexists.  Please refer to the attached screenshots.  What is the cause of this error, and how can we fix it?  Thanks for your help.  
1 REPLY 1

Denis__Dennehy
Level 15
I would look closely at the worksheet you are importing because there is something wrong with the format of it.  I.e. are there blank column headers in the range you are loading?