printArea = 'A1:G20' // Set multiple Print Areas by separating print areas with '&' worksheet. eachSheet ( function ( worksheet, sheetId ) // Set Print Area for a sheet worksheet. Iterate over all sheets // Note: will still work but this is better workbook. To be clear, all contributions added to this library will be included in the library's MIT licence. Versions are updated on release and any change will most likely result in merge collisions. Note: Please try to avoid modifying the package version in a PR. 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.Įven a PR that just has a failing test is fine - I can analyse what the test is doing and fix the code from that. Merged Improvements for images (correct reading/writing possitions) #702.Ĭontributions are very welcome! It helps me know what features are desired or what bugs are causing the most pain. Many thanks to Rolando Romero for this contribution. Merged Fixed conditional format corrupting sheet #1305 #1574.įixes Errors when opening file in Excel after saving a file with conditional formatting #1305. Many thanks to Aleksey Kuznetsov for this contribution. Merged Ability to set tooltip for hyperlink #602. Many thanks to Jerebtw for this contribution. Many thanks to Alex Bjørlig for this contribution.
Merged Added Node v16 to the test suite #1731. Many thanks to Siemienik Pawel for this contribution.
#971Īnd ERROR in node_modules/exceljs/index.d.ts(1661,34): error TS2503: Cannot find namespace 'NodeJS'. Merged Update version to latest lts #1133.įixes ERROR in node_modules/exceljs/index.d.ts(1648,34): error TS2503: Cannot find namespace 'NodeJS'. Many thanks to Ilya I for this contribution. Many thanks to Daniel Gonçalves for this contribution.įixes npm run lint reports multiple violations #1598.
Merged Add type definition for lastColumn property (fixes #1453) #1629.įixes Add type for property of worsheet.lastcolumn #1453.
Many thanks to fpaupier for this contribution. Merged doc: add example for solid pattern usage #1649. Many thanks to Vasiliy Stavenko for this contribution. Many thanks to Tanawit Kritwongwiman for this contribution. Merged Add TS declarations of Workbook properties #1656. ExcelJS Translations Installation New Features! Contributions Contents Importing ⬆ ES5 Imports ⬆ Browserify ⬆ Interface ⬆ Create a Workbook ⬆ Set Workbook Properties ⬆ Set Calculation Properties ⬆ Workbook Views ⬆ Add a Worksheet ⬆ Remove a Worksheet ⬆ Access Worksheets ⬆ Worksheet State ⬆ Worksheet Properties ⬆ Worksheet Metrics ⬆ Page Setup ⬆ Headers and Footers ⬆ Worksheet Views ⬆ Frozen Views ⬆ Split Views ⬆ Auto filters ⬆ Columns ⬆ Rows ⬆ Add Rows ⬆ Handling Individual Cells ⬆ Merged Cells ⬆ Insert Rows ⬆ Splice ⬆ Duplicate a Row ⬆ Defined Names ⬆ Data Validations ⬆ Cell Comments ⬆ Cell Comments Properties ⬆ Cell Comments Margins Supported Margins Properties ⬆ Cell Comments Protection Supported Protection Properties ⬆ Cell Comments EditAs ⬆ Tables ⬆ Table Properties ⬆ Table Style Properties ⬆ Table Column Properties ⬆ Totals Functions ⬆ Table Style Themes ⬆ Modifying Tables ⬆ Styles ⬆ Number Formats ⬆ Fonts ⬆ Alignment ⬆ Borders ⬆ Fills ⬆ Pattern Fills ⬆ Gradient Fills ⬆ Rich Text ⬆ Cell Protection ⬆ Conditional Formatting ⬆ Expression ⬆ Cell Is ⬆ Top 10 ⬆ Above Average ⬆ Color Scale ⬆ Icon Set ⬆ Data Bar ⬆ Contains Text ⬆ Time Period ⬆ Outline Levels ⬆ Images ⬆ Add Image to Workbook ⬆ Add image background to worksheet ⬆ Add image over a range ⬆ Add image to a cell ⬆ Add image with hyperlinks ⬆ Sheet Protection ⬆ Sheet Protection Options ⬆ File I/O ⬆ XLSX ⬆ Reading XLSX ⬆ Writing XLSX ⬆ CSV ⬆ Reading CSV ⬆ Writing CSV ⬆ Streaming I/O ⬆ Streaming XLSX ⬆ Streaming XLSX Writer(#contents) Streaming XLSX Reader(#contents) Iterating over all events(#contents) Readable stream(#contents) Browser ⬆ Prebundled ⬆ Value Types ⬆ Null Value ⬆ Merge Cell ⬆ Number Value ⬆ String Value ⬆ Date Value ⬆ Hyperlink Value ⬆ Formula Value ⬆ Shared Formula ⬆ Formula Type ⬆ Array Formula ⬆ Rich Text Value ⬆ Boolean Value ⬆ Error Value ⬆ Interface Changes ⬆ 0.1.0 ⬆ Worksheet.eachRow ⬆ Worksheet.getRow ⬆ 0.1.1 ⬆ cell.model ⬆ 0.2.44 ⬆ Config ⬆ Caveats ⬆ Dist Folder ⬆ Known Issues ⬆ Testing with Puppeteer ⬆ Splice vs Merge ⬆ Release History ⬆ Major Version Change Changes Another Major Version Change Main Export is now the Original Javascript Source ES5 and Browserify are Still Included README.md
0 kommentar(er)
