C;Y2;X2;K22 C;Y3;X2;K33 E would be displayed like this when read by an appropriate spreadsheet: for numeric formatting The formatting of 2 decimal digits is applied to Column 2 using F;P2;C2 where P0 is for General, P1 is for no decimal, P2 is for 2 digits, P3 has leading $ sign with 2 decimal points as defined below. ID;P P;PGeneral P;P_(* #,##0_);;_(* \-#,##0_);;_(* "-"_);;_(@_) P;P_(* #,##0.00_);;_(* \(#,##0.00\);;_(* "-"??_);;_(@_) P;P_("$"* #,##0.00_);;_("$"* \(#,##0.00\);;_("$"* "-"??_);;_(@_) C;Y1;X1;K"Row 1" C;Y2;X1;K"Row 2" C;Y3;X1;K"Total" C;Y1;X2;K11 C;Y2;X2;K22 C;Y3;X2;K0;ER1C2+R2C2 F;P2;C2 E would be displayed like this when read by an appropriate spreadsheet: for column width defines the widths of a group of columns: [S] one space < n1 > the first column < n2 > the last column < n3 > the width of columns in number of characters For example: Adding these SYLK codes will adjust the column width of column 1 and 2 to 20 and 30 respectively. F;W1 1 20 F;W2 2 30 cell formatting properties F; < cl > < n > < c2 > < cl > one of the following 1-character formatting codes: D default C continuous cross-cell display E scientific exponentiation F fixed decimal point G general format $ leading $ and 2 decimal points * bar graph, one asterisk per unit (5 would be *****) < n > the number of digits. < c2 > one of the following 1-character alignment codes: D default C center G general(textleft, numbersright) L left justify R right justify For example: The following SYLK code demonstrates the cell formatting properties: ID;P P;PGeneral C;Y1;X1;K"Row 1 Left Justify" F;P0;FG0L C;Y2;X1;K"Row 2 Right Justify" F;P0;FG0R C;Y3;X1;K"Total at Center" F;P0;FG0C C;Y1;X2;K11 C;Y2;X2;K22 C;Y3;X2;K0;ER1C2+R2C2 F;Y1;X2;FF2L F;Y2;X2;FF2R F;Y3;X2;F$2C F;W1 2 25 E SYLK syntax SYLK_file ::= Record + Record ::= RecordType Field* newline ID record Use: A header to identify spreadsheet type and creator. Must be first record in the file. Record type: ID Mandatory fields: P program file creator possible creators include: MP (Multiplan) XL (Excel) Possible fields: N If present, file uses ;N style cell protection If absent, file uses ;P style cell protection E If present, NE records are redundant If absent, NE records are not redundant B record Use: Tells number of rows and columns in the spreadsheet. Recommended that it come before C and F records Record type: B Mandatory fields: X columns tells maximum number of columns Y rows tells maximum number of rows C record