EXCELCOM_WRITE

Syntax

Example

Description/Remarks

EXCELCOM_WRITE
row_number
,
column_number
,
"value_or_formula"

EXCELCOM_WRITE 4, 1, [C1]

 

This template formula writes the value of template cell [C1] into the spreadsheet cell in row 4, column 1.

 

 

 

EXCELCOM_WRITE 4, 2, "=SUM(B1:B3)"

 

This template formula writes the Excel formula "=SUM(B1:B3)" into the spreadsheet cell in row 4, column 2.

 

 

 

See also: Creating a file in Microsoft Excel format.

This command writes a numeric value, text value, date/time value or Excel formula to the specified cell in the new file opened by the EXCELCOM_OPEN command.

Note:  Microsoft Excel must be installed on any workstation that will open and run a template containing the EXCELCOM_OPEN, EXCELCOM_WRITE or EXCELCOM_CLOSE commands.

The following parameters are required when writing to a cell:

Row_number

Specify the row number of the cell to be written.  Rows are counted 1, 2, 3, etc., just as they are labeled in Microsoft Excel.

Column_number

Specify the column number of the cell to be written.  Columns are counted 1, 2, 3, etc., and correspond to Microsoft Excel columns A, B, C, etc.  

Value_or_formula

The text, number, date/time or Excel formula to be entered in the cell.

Note:  The font, format, and alignment already applied to the specified cell will also be applied to the new value_or_formula that you supply.  For more information about these cell attributes, see EXCEL_WRITE.  

Microsoft Excel will correctly adjust the display of text and date/time values regardless of the format already applied to the cell.  However, numeric values entered in a cell with date/time formatting will be displayed as date/time values.