Set the Cell's Formula to a Formula Value

Set the formula of a cell in an Excel sheet.

📘

Note: This operation is part of the Excel Book (BDK). To use this book, you need to first learn it in your agent.

Input Concepts

ConceptDescriptionTypeRequired
cellThe reference to the Excel cell.excel cell referenceYes
formula valueThe formula to set in the cell.textYes

Examples

Set the formula of a cell in an Excel sheet.

get the first cell
use the above as the cell
set the cell's formula to "=A1+B1"