IronCalc

Contents:

• Installation
• Usage Examples
  • Creating an Empty Model
  • Loading from XLSX
  • Modifying and Saving
• Top Level Methods
• Raw API Reference
  • evaluate()
  • set_user_input()
  • clear_cell_contents()
  • get_cell_content()
  • get_cell_type()
  • get_formatted_cell_value()
  • set_cell_style()
  • get_cell_style()
  • insert_rows()
  • insert_columns()
  • delete_rows()
  • delete_columns()
  • get_column_width()
  • get_row_height()
  • set_column_width()
  • set_row_height()
  • get_frozen_columns_count()
  • get_frozen_rows_count()
  • set_frozen_columns_count()
  • set_frozen_rows_count()
  • get_worksheets_properties()
  • set_sheet_color()
  • add_sheet()
  • new_sheet()
  • delete_sheet()
  • rename_sheet()
  • test_panic()
• User API Reference
  • save_to_xlsx()
  • save_to_icalc()
  • apply_external_diffs()
  • flush_send_queue()
  • set_user_input()
  • get_formatted_cell_value()
  • to_bytes()
• Objects
  • WorkbookError
  • PyCellType
  • PyStyle

IronCalc is a spreadsheet engine that allows you to create, modify and save spreadsheets.

A simple example that creates a model, sets a formula, evaluates it and gets the result back:

import ironcalc as ic

model = ic.create("model", "en", "UTC", "en")

model.set_user_input(0, 1, 1, "=21*2")
model.evaluate()

assert model.get_formatted_cell_value(0, 1, 1), 42