Identifying Column Headings
As already discussed, the heart of creating corporate data from spreadsheets is the ability to identify meaningful context of values placed on the spreadsheet. The way this is done is to identify the column name and the row identifier for each value of data.
The row identifier is always easy to identify because it resides on the same physical line as the value. But the column name is another matter. The column name is found by aligning the xlstab occurrences with the value. But in order to even know that a column line signifies a column, the system must learn which line contains the column headings. As mentioned earlier, this can only be achieved manually, by entering the column heading line into the ssdef table.
