---
title: "extract_formulas"
---

[< Back to Reference](../reference.qmd) | [View source](https://codeberg.org/usrbinr/tidychain/src/branch/main/R/extract_formulas.R#L23)

# `extract_formulas()`

Extract and Parse Formulas from Excel

## Usage

```r
extract_formulas(path)
```

## Arguments

| Argument | Description |
|----------|-------------|
| `path` | Path to an .xlsx file. |

## Value

A tibble containing:

- `sheet`: Sheet name

- `cell`: Cell reference (e.g., "A1")

- `formula`: The Excel formula

- `references`: List column of cells this formula depends on

- `has_references`: TRUE if formula references other cells

## Description

Extracts all formulas from an Excel workbook and parses their cell references
to understand dependencies between cells.

## Examples

```r
## Not run: 
formulas <- extract_formulas("spreadsheet.xlsx")
print(formulas)

## End(Not run)
```

