What are recommendations to model an Excel spreadsheet with a programming language, e.g. python (but not restricted to it)?
A "spreadsheet" is a workbook, that contains worksheets, that contains ranges/cells. Workbooks and worksheets have countless properties. There are also countless methods to set range/cells values, formats, etc... (apologies for the wording "properties", "methods" that may note be so Excel-like).
E.g. I would like my code opens a workbook, gets into a workbooks, reads and set cells values, also controls calculation mode of the workbook, etc ...
What is the right design to "code a spreadsheet", please? What shall be a property or method of my class? etc... ?
I mean it is not crazy use case. Someone else must have already done it.
Any thought, source, snippet code-ready-to-use much welcome.
Merci.