Here is a recipe for programmatically reading data from an Excel spreadsheet using Apache POI. Note that in this example, I'm using the spreadsheet to store test data. However, this is NOT an endorsement to manage your test data this way. This is just one practical...
Here is the recipe for automating the task of selecting a date from a Date Picker component. I illustrate this recipe with Selenium WebDriver and Java, however, the recipe itself can be used with any automation tool and programming language.
Recipe to Automate Date Picker Selection
Ingredients
...