WRITE_SYLK

The WRITE_SYLK function writes the contents of an IDL variable to a SYLK ( Symbolic Link) format spreadsheet data file. The function returns TRUE if the write operation was successful.

NOTE: This routine writes only numeric and string SYLK data. It cannot handle spreadsheet and cell formatting information (cell width, text justification, font type, date, time, monetary notations, etc.). A given SYLK data file cannot be appended with data blocks through subsequent calls.

This routine is written in the IDL language. Its source code can be found in the file write_sylk.pro in the lib subdirectory of the IDL distribution.

Calling Sequence

Result = WRITE_SYLK( File , Data )

Arguments

File

A scalar string specifying the full path name of the SYLK file to write.

Data

A scalar, vector, or 2D array to be written to File .

Keywords

STARTCOL

Set this keyword to the first column of spreadsheet cells to write. If not specified, the write operation begins with the first column found in the file (column 0).

STARTROW

Set this keyword to the first row of spreadsheet cells to write. If not specified, the write operation begins with the first row of cells found in the file (row 0).

Example

Suppose you wish to write the contents of a 2 by 2 floating-point array, data , to a SYLK data file called "bar.slk" such that the matrix would appear with it's upper left data at the cell in the 10th row and the 20th column. Use the following command:

status = WRITE_SYLK("bar.slk", data, STARTROW = 9, STARTCOL = 19)

The IDL variable status will contain the value 1 if the operation was successful.