Browse Prior Art Database

Use of First Row in Spreadsheet for Field Names Disclosure Number: IPCOM000061659D
Original Publication Date: 1986-Sep-01
Included in the Prior Art Database: 2005-Mar-09

Publishing Venue


Related People

Chang, PY Dolifka, CS Sprott, CN [+details]


A method is described which is able to make use of field names when merging spreadsheet files with a shell document containing identical variable names. The Merge with File task in DisplayWrite* 3-type text processing programs uses field names to identify columns of related data in the shell document. Since spreadsheets do not require field names or column headings to be positioned in a specific spot on the spreadsheet, the DIF**- and SYLK***-type files created by spreadsheets do not differentiate between column headings and the data itself. So, the field names are stored in the same way the data is. In accordance with the method it is assumed that the first valid spreadsheet row is to be used for field names and a valid record is one containing at least one alphanumeric character.