Wintrack scrollsheet file (.WTB) format
Representation of data...
The proprietary Wintrack scrollsheet file format matches the memory representation of scrollsheets. Full precision and all formatting are preserved. Each cell of a scrollsheet has its associated double precision variable. For numeric columns, it contains the cell's numeric value. For text type columns, it must be read as an offset into a character array which is associated with the column and contains the actual text delimited by \0 characters. If several cells contain the same text, this text is represented only once in the character array to save storage space.
File structure...
unsigned short number of columns in table, 16bit integer unsigned short number of rows in table, 16bit integer unsigned short number of fixed (not scrolled) columns in table, 16 bit integer unsigned short 16bit integer for control purposes; sum of number of columns and rows COLUMN* array of COLUMN structures (see below), one per column unsigned short 16bit integer for control purposes; sum of number of columns and rows double*... one array per column containing one double variable per row storing cell values or offsets into the column's lpszDat string. unsigned short 16bit integer for control purposes; sum of number of columns and rows char*... one character array per column holding text values, length as indicated by the uiTextLen member of the column's COLUMN struct unsigned short 16bit integer for control purposes; sum of number of columns and rows Definition of the COLUMN structure:
struct COLUMN { short iColWidth; // 16bit integer, column width in characters char lpszColName[33]; // variable name char lpszColCmnt[33]; // variable commentary char lpszColFmat[17]; // variable format string char far* lpszDat // text values double far* lpdDat; // variable values WORD wTextLen; // 16bit unsigned, total bytes of text, including \0 };The variable format string follows the conventions of ANSI C sprintf format strings.
Additional information...
- For an overview of Wintrack documents and files see Wintrack documents and files.
- For more information on scrollsheets read Inside scrollsheets.
