Loading and saving Excel files
What this guide will cover
Section titled “What this guide will cover”- Opening an
.xlsxfile directly as a spreadsheet in MathJet - Round-tripping (open, edit, save) without losing formulas or formatting
- Reading sheet/range data into a script via the polyglot formula bar
- Writing analysis results back to specific cells
- Known limitations of the
.xlsxround-trip
In the meantime, the short version is: File → Open an .xlsx and
it just works. Formulas, charts, and most cell styles round-trip
intact. Use the spreadsheet view as a first-class data source rather
than as an export target.