Syntax |
Example |
Description/Remarks |
EXCELCOM_WRITE |
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. |