Project and Portfolio Management Practitioners Forum
cancel

Validation that reads data from Excel sheet

Highlighted
Riepl Hansjoerg
Contributor.

Validation that reads data from Excel sheet

I need to create a validation that reads data from an Excel sheet an presents the data in an auto completion list. Any hints?
Thanks,
HJ
2 REPLIES
Erik Cole
Acclaimed Contributor.

Re: Validation that reads data from Excel sheet

Why does it need to read from Excel? Does the data change often?

Your easiest way probably is to import the data into a custom database table (you can even script this to automate refreshing from a new file) and have your validation be SQL against that table.
Riepl Hansjoerg
Contributor.

Re: Validation that reads data from Excel sheet

The provider of the data can only deliver the data in an Excel sheet