On the second worksheet of a blank workbook, create a list, such as shown in Figure 1.Once you do so, make the list into a Table in Excel 2007 and later, or a List in Excel 2003 and earlier.
For starters, Excel Ant is focused on the testing numerically oriented sheets.
big problem 1: every time the new excel spreadsheet opens, i get the "excel found unreadable content" error.
i use almost identical code in another application - the big difference being i read that data from a sql server database table and not from another spreadsheet - and this doesn't give me that problem.
This sheet is shown below: This sheet calculates the principal and interest payment for a mortgage based on the amount of the loan, term and rate.
To write a simple Excel Ant test you need to tell Excel Ant about the file like this: This code sets up Excel Ant to access the file defined in the ant property Finally it tries to evaluate the B4 on the sheet named 'Mortgage Calculator'.
You can download the sample Drop Down Lists file here: Drop Down List Workbook.