Browse Prior Art Database

Use of First Row in Spreadsheet for Field Names

IP.com Disclosure Number: IPCOM000061659D
Original Publication Date: 1986-Sep-01
Included in the Prior Art Database: 2005-Mar-09
Document File: 1 page(s) / 11K

Publishing Venue

IBM

Related People

Chang, PY: AUTHOR [+3]

Abstract

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.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 100% of the total text.

Page 1 of 1

Use of First Row in Spreadsheet for Field Names

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. Therefore, the spreadsheet can have blank lines or lines of non- alphanumeric characters preceding the actual field names which will be ignored. The field name row will not be treated as data and included in the merge, but the contents of those columns will be stored as field names. * Trademark of IBM Corporation. ** Trademark of Software Arts Products Corporation. *** Trademark of Microsoft Corporation.

1