Skip to content
Zoan Docs

Excel Close (Session)

Excel Close (Session)

Section titled “Excel Close (Session)”

Type: excel-close  ·  Package: Excel Activities v1.0.0

Saves and closes an open Excel session with Excel Open. It is the mandatory pairing of Excel Open in session mode: it releases the file and persists the changes to disk.

How it works

Section titled “How it works”

Save the pending changes to the session (unless you enter save = false) and close it. After you close it, the session can no longer be used.

Required parameters

Section titled “Required parameters”
ParameterEditorDescription
sessionexpressionThe session returned by Excel Open.

Optional parameters

Section titled “Optional parameters”
ParameterEditorDescription
savebooleanSave changes before closing. By default true. Set it to false to discard changes.

Example

Section titled “Example”
Excel Open   path = = asset("reporte.xlsx")   → output: libro
Write Excel Cell   session = = libro   cell = "A1"   value = "Hola"
Excel Close  session = = libro
Section titled “Related activities”