Excel Poke

ExcelPoke sets specific cell values at specific cell references in an Excel spreadsheet sheet.

Note

Note:

This function supports files that have been created using Microsoft Excel 2007 or later (.xlsx file extension). You do not need to have Excel installed to use this function.

---

Properties

File path

The file path to the xlsx file to write to.

Sheet name

The name of the sheet to write to. If the file does not contain a sheet with the specified name, a new sheet with that name will be created.

Values

The collection of cell values to set. Each item is an object with the following properties:

• Cell is the cell reference to set, specified using the A1 reference style, e.g. 'A1' or 'C3'.
• Value is the value to set for that cell.

---

Caution

Formula Recalculation

The Excel plugin does not support programmatic recalculation of formula cells. After writing data using the ExcelPoke function, open the Excel file to trigger automatic recalculation of all formula cells. Function values are only calculated by Excel and trigger once the workbook is opened.

Data Formatting Requirements

Format cells containing formula dependencies correctly before saving:

• Set explicit data types when writing data programmatically to ensure proper formula recalculation
• Ensure data is entered in the correct format when inputting data into cells
• Format cells as appropriate types (Number, General) rather than text
• Avoid text formatting for numeric data as this prevents formula recalculation

This ensures formulas recalculate correctly when the file opens in Excel.

Links

Office Open XML file format

Office Support: The A1 reference style