Method for Converting SYLK to Fixed-Length File
Original Publication Date: 1986-Mar-01
Included in the Prior Art Database: 2005-Mar-08
A method is described which provides a way to convert a SYLK file to a "pre-padded" fixed-length file and reduce processing time. The SYLK file format is such that cells that appear contiguous in the spreadsheet may not be stored contiguously in the SYLK file, i.e., field 1 of record 1 may not be stored in close proximity to field 2 of record 1. This makes it impossible to go through the SYLK file sequentially and write out new records sequentially. We are converting to a fixed-length file, however, since after the first pass through the SYLK file the lengths of each field are known and how many records will be in the new file is also known, the offset from the beginning of the file where the field contents should be stored can be calculated for each field.