Usage Examples

Creating an Empty Model

import ironcalc as ic

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

Loading from XLSX

import ironcalc as ic

model = ic.load_from_xlsx("example.xlsx", "en", "UTC", "en")

Modifying and Saving

model = ic.create("model", "en", "UTC", "en")
model.set_user_input(0, 1, 1, "123")
model.set_user_input(0, 1, 2, "=A1*2")
model.evaluate()

# Save to XLSX
model.save_to_xlsx("updated.xlsx")

# Or save to the binary format
model.save_to_icalc("my_workbook.icalc")