SpreadJS XLSX Editor for VSCode
Powered by SpreadJS, this extension provides a full Excel-like experience for working with spreadsheets in VS Code. Support for XLSX, XLSM, XLTM, CSV as well as SpreadJS formats like SJS and SSJSON.

About SpreadJS
SpreadJS is the most complete enterprise JavaScript spreadsheet solution for delivering Microsoft® Excel-like spreadsheet experiences, fast. SpreadJS also provides full support for React, Vue, Angular, and TypeScript.
This enterprise-grade JavaScript spreadsheet supports many popular features such as a powerful formula engine (500+ functions), native Excel input and output, PivotTables, charting, slicers, sparklines, conditional formatting, tables, international localization, printing, sorting, filtering, drag-fill, grouping, undo/redo, data validation, input controls, and much more.

Features
- Open and edit
.xlsx, .xlsm, .xltm, .csv, .sjs, .ssjson files
- Full-featured Excel-like editing experience embedded in VS Code
- Create new blank workbooks via command palette
Commands
SpreadJS: New Blank Workbook(.sjs) - Create a new .sjs file
SpreadJS: New Blank Workbook(.ssjson) - Create a new .ssjson file
SpreadJS: New Blank Workbook(.xlsx) - Create a new .xlsx file
SpreadJS: New Blank CSV File - Create a new .csv file
Extension Settings
| Setting |
Description |
spreadjs.language |
Designer UI language (en, zh, ja, ko, or follow VS Code) |
spreadjs.culture |
Culture for number/date formatting (en-us, zh-cn, ja-jp, ko-kr, or follow language setting) |
spreadjs.ribbonMode |
Ribbon display mode (classic or toolbar) |
spreadjs.workbookOptions |
Default options for new workbooks |
spreadjs.openOptions |
Options for opening .sjs files |
spreadjs.importOptions |
Options for importing .xlsx files |
spreadjs.importCsvOptions |
Options for importing .csv files |