You might also find the Python library pandas useful. Its “DataFrames” can mirror your excel data 1:1 and you have convenience methods like to_excel(). Easy to combine with numpy for performant matrix math.
XLSX just becomes a container for storing/sharing your data, and while Python is used for analysis. I would use matplotlib for plotting rather than embedding in the sheet.