The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Validation that reads data from Excel sheet

Highlighted
Riepl Hansjoerg
Occasional Advisor

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
Honored 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
Occasional Advisor

Re: Validation that reads data from Excel sheet

The provider of the data can only deliver the data in an Excel sheet
//Add this to "OnDomLoad" event