Structure of Excel Run-time/Design-time Template ? (e.g. in Read Excel Activity)
Hi guys,
can sombody tell me how a excel run-time and design-time template must be structured to import data from an Excel File.
I've already tried a few approaches, but without succsess:
"Object reference not set to an instance of an object."
Thanks in advance
Markus
-
Hi Markus,
Here are some high level steps to structure excel sheet in the Read Excel activity:
Create 2 columns (vertical or horizontal, your choice). 1 is for the field name, and the other is the value to store in AgilePoint.
Go to Forumulas -> Define Name
Create a field
To associate the created field with the value field, select the value field and select the fieldname from the top left corner dropdown
The error you are experiencing may be due to an error in the Excel sheet, but I would need more details to understand where the error is coming from.
Lucas
Please sign in to leave a comment.
Comments
2 comments