Formula Analysis

Extract and analyze Excel formulas.

Formula parsing and analysis utilities for spreadsheets.

class sheetwise.formula_parser.FormulaTokenizer

Helper class to tokenize Excel formulas safely.

tokenize(formula)

Split formula into tokens while preserving structure.

Return type:

List[str]

extract_args(token_stream)

Extract arguments from a function call, handling nested parenthesis.

Return type:

List[str]

class sheetwise.formula_parser.FormulaParser

Extracts, analyzes and simplifies Excel formulas from spreadsheets. Optimized for memory usage with streaming reads.

CELL_REF_PATTERN = re.compile('([A-Z]+[0-9]+|[A-Z]+\\:[A-Z]+|[0-9]+\\:[0-9]+|[A-Z]+[0-9]+\\:[A-Z]+[0-9]+)')

__init__()

Initialize the formula parser.

extract_formulas(excel_path, sheet_name=None)

Extract all formulas from an Excel file using Memory-Efficient Streaming.

Parameters:

• excel_path (str) – Path to the Excel file

• sheet_name (Optional[str]) – Optional specific sheet to parse (saves time)

Return type:

Dict[str, str]

Returns:

Dictionary mapping cell addresses to formulas

build_dependency_graph()

Build a graph of cell dependencies based on extracted formulas.

Return type:

Dict[str, Set[str]]

extract_cell_references(formula)

Extract all cell references from a formula.

Return type:

List[str]

simplify_formula(formula)

Generate a simplified explanation using robust tokenization. Handles nested functions better than Regex.

Return type:

str

get_formula_impact(cell_address)

Analyze the impact of a formula cell.

Return type:

Dict[str, Any]

encode_formulas_for_llm(formulas=None)

Generate LLM-friendly encoding.

Return type:

str

class sheetwise.formula_parser.FormulaDependencyAnalyzer(formula_parser=None)

Specialized analyzer for formula dependencies.

__init__(formula_parser=None)

find_calculation_chains()

Return type:

List[List[str]]

identify_critical_cells()

Return type:

List[str]