vue使用luckyexcel实现在线表格

# ExcelJS [](https://github.com/exceljs/exceljs/actions?query=workflow%3AExcelJS) [](https://lgtm.com/projects/g/exceljs/exceljs/context:javascript) [](https://lgtm.com/projects/g/exceljs/exceljs/alerts) Read, manipulate and write spreadsheet data and styles to XLSX and JSON. Reverse engineered from Excel spreadsheet files as a project. # Translations * [中文文档](README_zh.md) # Installation ```shell npm install exceljs ``` # New Features! <ul> <li> Merged <a href="https://github.com/exceljs/exceljs/pull/1656">Add TS declarations of Workbook properties #1656</a>. Many thanks to <a href="https://github.com/kaoths">Tanawit Kritwongwiman</a> for this contribution. </li> <li> Merged <a href="https://github.com/exceljs/exceljs/pull/201">Fix issue #178 #201</a>. Many thanks to <a href="https://github.com/stavenko">Vasiliy Stavenko</a> for this contribution. </li> <li> Merged <a href="https://github.com/exceljs/exceljs/pull/1649">doc: add example for solid pattern usage #1649</a>. Many thanks to <a href="https://github.com/fpaupier">fpaupier</a> for this contribution. </li> <li> Merged <a href="https://github.com/exceljs/exceljs/pull/1629">Add type definition for lastColumn property (fixes #1453) #1629</a>. Fixes <a href="https://github.com/exceljs/exceljs/issues/1453">Add type for property of worsheet.lastcolumn #1453</a>. Many thanks to <a href="https://github.com/masterzeus05">Daniel Gonçalves</a> for this contribution. </li> <li> Merged <a href="https://github.com/exceljs/exceljs/pull/1599">fix #1598 lint violations #1599</a>. Fixes <a href="https://github.com/exceljs/exceljs/issues/1598">[BUG] npm run lint reports multiple violations #1598</a>. Many thanks to <a href="https://github.com/iva2k">Ilya I</a> for this contribution. </li> <li> Merged <a href="https://github.com/exceljs/exceljs/pull/1133">Update @types/node version to latest lts #1133</a>. Fixes <a href="https://github.com/exceljs/exceljs/issues/971">ERROR in node_modules/exceljs/index.d.ts(1648,34): error TS2503: Cannot find namespace 'NodeJS'. #971</a> and <a href="https://github.com/exceljs/exceljs/issues/997">ERROR in node_modules/exceljs/index.d.ts(1661,34): error TS2503: Cannot find namespace 'NodeJS'. #997</a>. Many thanks to <a href="https://github.com/Siemienik">Siemienik Pawel</a> for this contribution. </li> <li> Merged <a href="https://github.com/exceljs/exceljs/pull/1731">Added Node v16 to the test suite #1731</a>. Many thanks to <a href="https://github.com/alexbjorlig">Alex Bjørlig</a> for this contribution. </li> <li> Merged <a href="https://github.com/exceljs/exceljs/pull/1708">Readme moment to dayjs #1708</a>. Many thanks to <a href="https://github.com/jerebtw">Jerebtw</a> for this contribution. </li> <li> Merged <a href="https://github.com/exceljs/exceljs/pull/602">Ability to set tooltip for hyperlink #602</a>. Many thanks to <a href="https://github.com/kalexey89">Aleksey Kuznetsov</a> for this contribution. </li> <li> Merged <a href="https://github.com/exceljs/exceljs/pull/1574">Fixed conditional format corrupting sheet #1305 #1574</a>. Fixes <a href="https://github.com/exceljs/exceljs/issues/1305">[BUG] Errors when opening file in Excel after saving a file with conditional formatting #1305</a>. Many thanks to <a href="https://github.com/rolandostar">Rolando Romero</a> for this contribution. </li> <li> Merged <a href="https://github.com/exceljs/exceljs/pull/702">Improvements for images (correct reading/writing possitions) #702</a>. Many thanks to <a href="https://github.com/Siemienik">Siemienik Pawel</a> for this contribution. </li> </ul> # Contributions Contributions are very welcome! It helps me know what features are desired or what bugs are causing the most pain. I have just one request; If you submit a pull request for a bugfix, please add a unit-test or integration-test (in the spec folder) that catches the problem. Even a PR that just has a failing test is fine - I can analyse what the test is doing and fix the code from that. Note: Please try to avoid modifying the package version in a PR. Versions are updated on release and any change will most likely result in merge collisions. To be clear, all contributions added to this library will be included in the library's MIT licence. # Contents <ul> <li><a href="#importing">Importing</a></li> <li> <a href="#interface">Interface</a> <ul> <li><a href="#create-a-workbook">Create a Workbook</a></li> <li><a href="#set-workbook-properties">Set Workbook Properties</a></li> <li><a href="#workbook-views">Workbook Views</a></li> <li><a href="#add-a-worksheet">Add a Worksheet</a></li> <li><a href="#remove-a-worksheet">Remove a Worksheet</a></li> <li><a href="#access-worksheets">Access Worksheets</a></li> <li><a href="#worksheet-state">Worksheet State</a></li> <li><a href="#worksheet-properties">Worksheet Properties</a></li> <li><a href="#page-setup">Page Setup</a></li> <li><a href="#headers-and-footers">Headers and Footers</a></li> <li> <a href="#worksheet-views">Worksheet Views</a> <ul> <li><a href="#frozen-views">Frozen Views</a></li> <li><a href="#split-views">Split Views</a></li> </ul> </li> <li><a href="#auto-filters">Auto Filters</a></li> <li><a href="#columns">Columns</a></li> <li><a href="#rows">Rows</a> <ul> <li><a href="#add-rows">Add Rows</a></li> <li><a href="#handling-individual-cells">Handling Individual Cells</a></li> <li><a href="#merged-cells">Merged Cells</a></li> <li><a href="#insert-rows">Insert Rows</a></li> <li><a href="#splice">Splice</a></li> <li><a href="#duplicate-a-row">Duplicate Row</a></li> </ul> </li> <li><a href="#defined-names">Defined Names</a></li> <li><a href="#data-validations">Data Validations</a></li> <li><a href="#cell-comments">Cell Comments</a></li> <li><a href="#tables">Tables</a></li> <li><a href="#styles">Styles</a> <ul> <li><a href="#number-formats">Number Formats</a></li> <li><a href="#fonts">Fonts</a></li> <li><a href="#alignment">Alignment</a></li> <li><a href="#borders">Borders</a></li> <li><a href="#fills">Fills</a></li> <li><a href="#rich-text">Rich Text</a></li> </ul> </li> <li><a href="#conditional-formatting">Conditional Formatting</a></li> <li><a href="#outline-levels">Outline Levels</a></li> <li><a href="#images">Images</a></li> <li><a href="#sheet-protection">Sheet Protection</a></li> <li><a href="#file-io">File I/O</a> <ul> <li><a href="#xlsx">XLSX</a> <ul> <li><a href="#reading-xlsx">Reading XLSX</a></li> <li><a href="#writing-xlsx">Writing XLSX</a></li> </ul> </li> <li><a href="#csv">CSV</a> <ul> <li><a href="#reading-csv">Reading CSV</a></li> <li><a href="#writing-csv">Writing CSV</a></li> </ul> </li> <li><a href="#streaming-io">Streaming I/O</a> <ul> <li><a href="#reading-csv">Streaming XLSX</a></li> </ul> </li> </ul> </li> </ul> </li> <li><a href="#browser