1.7.2 Bug Fixes: resolves https://github.com/natergj/excel4node/issues/283 to fix issue when comment drawing changing after save 1.7.1 Bug Fixes: resolves https://github.com/natergj/excel4node/issues/269 to fix issue where multiple complex strings could not be used merges https://github.com/natergj/excel4node/pull/264 to fix README typo merges https://github.com/natergj/excel4node/pull/272 to fix license format merges https://github.com/natergj/excel4node/pull/275 to address https://github.com/natergj/excel4node/issues/258 1.7.0 Bug Fixes: resolves https://github.com/natergj/excel4node/issues/238 to fix issue with certain emoji characters merges https://github.com/natergj/excel4node/pull/240 to fix issue with workbook validation using .Net validation library provided by Microsoft resolves https://github.com/natergj/excel4node/issues/236 where first tab will still be shown even if it is hidden Enhancements: merges https://github.com/natergj/excel4node/pull/243 to add basic cell comment functionality 1.6.0 Bug Fixes: merges https://github.com/natergj/excel4node/pull/232 to fix issue where emoji were not being added to worksheets Enhancements: addresses https://github.com/natergj/excel4node/issues/194 by adding ability to set Print Area for worksheets addresses https://github.com/natergj/excel4node/issues/233 by adding ability to set Page Breaks for worksheets 1.5.1 Bug Fixes: resolves https://github.com/natergj/excel4node/issues/218 where library crashed when null or undefined value was sent to cell string method resolves https://github.com/natergj/excel4node/issues/226 where default font would not be applied to dates when opening workbook in LibreOffice merges https://github.com/natergj/excel4node/pull/225 which removes error when attempting to bundle application with excel4node as dependency Enhancements: merges https://github.com/natergj/excel4node/pull/230 which reduces library size by only installed specific lodash functions 1.5.0 Bug Fixes: resolves https://github.com/natergj/excel4node/issues/156 where an error will be thrown if no Worksheet is specified prior to attempting to write a Workbook Enhancements: merge https://github.com/natergj/excel4node/pull/211 & https://github.com/natergj/excel4node/pull/212 remove default logger dependency in favor of much smaller simple logger (reduces library dependencies and size) add ability specify custom logger 1.4.0 Bug Fixes: resolves https://github.com/natergj/excel4node/issues/196 where unicode filenames could not be used with HTTP Response write handler Enhancements: merge https://github.com/natergj/excel4node/pull/201 to add ability to hide worksheets 1.3.6 Bug Fixes: resolves https://github.com/natergj/excel4node/issues/182 to allow column widths to be set as floats resolves https://github.com/natergj/excel4node/issues/184 to properly handle setting row autofilter with no arguments merge https://github.com/natergj/excel4node/pull/181 to fix typo in documentation 1.3.5 Bug Fixes: merge https://github.com/natergj/excel4node/pull/141 to properly handle unicode and emoji merge https://github.com/natergj/excel4node/pull/172 to correct issue with row spans causing errors when opening workbooks with a large number of lines 1.3.4 Bug fixes: resolved issue where if multiple conditional formatting rules were specified for a single sheet, only the first rule would apply resolves https://github.com/natergj/excel4node/issues/164 to resolve issue adding multiple dataValidations that did not include a formula to a single worksheet Enhancements: merge https://github.com/natergj/excel4node/pull/165 to improve performance with shared strings 1.3.2 Bug fixes: resolves https://github.com/natergj/excel4node/issues/152 after 1.3.0 re-introduced issue #84 1.3.1 Bug fixes: resolves https://github.com/natergj/excel4node/issues/148 for uncatchable thrown errors resolves https://github.com/natergj/excel4node/issues/106 for incorrectly generated links resolves https://github.com/natergj/excel4node/issues/147 for missing fills in conditional formatting 1.3.0 Enhancements: merge https://github.com/natergj/excel4node/pull/117 to add option to hide view lines merge https://github.com/natergj/excel4node/pull/109 to add code coverage checking merge https://github.com/natergj/excel4node/pull/138 to allow for image from buffer support commit 1c4a7bf990160b47ad8e0f49c00a536dca7ab672 add options for workbook view commit ff629a225335dc784933c06aabd20ddca5fcdbef fix issue where ony first data validation per sheet would take effect Bug fixes: merge https://github.com/natergj/excel4node/pull/99 to fix issue when adding 2nd image of same extension merge https://github.com/natergj/excel4node/pull/115 to fix deprecated lodash function warning merge https://github.com/natergj/excel4node/pull/125 to fix link in README merge https://github.com/natergj/excel4node/pull/119 to remove babel-register runtime dependency merge https://github.com/natergj/excel4node/pull/132 to fix issue with summaryBelow and summaryRight commit 78180e6a0a1f0a50e43b588902da37fdee5be7bb use latest version of mime module commit b96f01a2923e2823377f10c28a97a3fe2c5c5f50 update dependencies commit b3fcb8aa6674c644838f81a9170f2b6d975803b6 fixes date translations to match published spec commit 1c4a7bf990160b47ad8e0f49c00a536dca7ab672 fix issue where workbook would always open as smallest possible window size 1.2.1 Fix Workbook#createStyle creating duplicates and slow performance [#100] 1.2.0 merged https://github.com/natergj/excel4node/pull/91 from miguelmota to expose writeToBuffer method allowing excel zip buffer to be piped to other streams added documentation to README fixed some errors in README 1.1.2 dependency cleanup updated to version 3.x.x of jszip 1.1.1 Improved effeciency when writing Workbooks to help address Issue #83. Tested with 50 columns and 30,000 rows. 1.1.0 Fixed issue where defaultRowHeight set in Workbook opts was not being properly handled. 1.0.9 Fixed issue #90 which would result in a type error being thrown if a dataValidation errorTitle was set and errorStyle was not 1.0.8 Removed debug line that had been missed prior to publish 1.0.7 Fixed issue #89 which would result in dates showing a 1 hour offset if date was in daylight savings time 1.0.6 Fixed issue #87 which would result in non-logical behaviour of showDropDown="true" for dataValidations Fixed issue #88 which would result in fonts set as default for workbook not having all of their attributes respected for cells that had a style assigned to them that only included a subset of the font attributes. 1.0.5 Fixed issue #84 which would result in Office 2013 on Windows crashing when attempting to print a workbook. 1.0.4 Fixed issue #82 which would result in call stack size being exceeded when workbook was being written 1.0.3 Fixed issue where border.outline property was not applying border only to cells on out the outside of the cell block Fixed issue where an excessive number of style xfs may have been added to styles.xml file 1.0.2 Fixed some inaccuracies in the README.md file 1.0.1 Removed a missed remnant of old code that wasn't removed during the merge Excluded development tests folder from npm published code 1.0.0 Complete rewrite of library in ES2015 This is a breaking change for API. Library is much more javascripty 0.5.1 Merged pull request 76 from https://github.com/bhuvanaurora to fix issue that would arise if you tried to add an emoji to an excel document 0.5.0 Merged pull request 74 from https://github.com/pindinz to add support for specifying specific paper size 0.4.1 Fixed issue causing problems when trying to bundle 0.4.0 Merged pull requests 67, 59, 60, 64, 66, 67 from https://github.com/dgofman Added ability to create cells with complex multiple formatting within a single cell Added ability to include headers and footers in worksheets Added ability to repeat specific rows or columns on every printed page (https://support.office.com/en-us/article/Repeat-specific-rows-or-columns-on-every-printed-page-0d6dac43-7ee7-4f34-8b08-ffcc8b022409) removed allowInterrupt options. It was causing issues Added ability to set a default font across workbook Fixed issues with images Fixed issue with print orientation and scaling 0.3.1 Merged https://github.com/natergj/excel4node/pull/53 from https://github.com/bugeats. More tests added Added support for limited number of conditional formatting rules 0.3.0 Merged https://github.com/natergj/excel4node/pull/52 from https://github.com/bugeats. Code cleanup refactor, added .eslintrc.js file and tests. 0.2.23 Merged https://github.com/natergj/excel4node/pull/50 from https://github.com/dmnorc to fix bug with setting size of font through Cell.Format methods. 0.2.22 Added the ability to reference Cells in another sheet in validations Merged pull request https://github.com/natergj/excel4node/pull/48 from https://github.com/dteunkenstt to add ability to set Cells with Boolean values 0.2.21 Fixed issue where files with spaces in their names were not correctly downloading in Firefox. 0.2.20 Added the ability to add "Protection" to Workbooks and Worksheets Fixed issue where Row.Filter() would not filter the correct row if workbook opened in LibreOffice or uploaded to GoogleSheets Added the .Border() function to individual cell ranges rather than requiring borders to be defined within a Style Added opts.allowInterrupt which will use an asynchronous forEach function in order not to block other operations if reports are being generated on the same thread as other operations. 0.2.19 Fixed issue that would cause Excel to crash when filtered columns were sorted 0.2.18 Fixed issue where page would not scroll vertically if row was frozen Fixed issue where internal Row.cellCount() function would not return the correct number of cells if there were more than 9 Fixed issue where invalid workbooks would be generated on write if write was called multiple times on the same workbook. 0.2.17 Set string function to remove characters not compatible with XMLStringifier. merged pull request https://github.com/natergj/excel4node/pull/38 from https://github.com/nirarazi to add support for Right to Left languages 0.2.16 merged pull request https://github.com/natergj/excel4node/pull/37 from https://github.com/pomeo to add ability to insert hyperlinks into cells 0.2.15 fixed issue where Column functions were not returning Column objects and could not be chained fixed date issues with Cell Date function when invalid date was sent. fixed issue where merged cells would apply values to all cells in range rather than just top left cell. This would cause issues when summing rows and columns with merged cells. fixed issue where multiple images could not be added to a workbook 0.2.14 Added ability to Group columns Merged pull request (https://github.com/natergj/excel4node/pull/34) from https://github.com/kylepixel which greatly optimizes conversion of numeric to and from alpha representations of columns 0.2.13 Fixed issue where default style would inherit style alignement if it was delared prior to any other font declaration 0.2.12 Added ability to Hide a Row or Column 0.2.11 Merged pull request (https://github.com/natergj/excel4node/pull/32) from https://github.com/stefanhenze to add ability to set the fit to page on print Added the abilty to rotate text in cell fixed validation issue that would cause an error if a cell were written to as a formula after already being written to as a number or string 0.2.10 Merged pull request (https://github.com/natergj/excel4node/pull/29) from https://github.com/atsapenko to fix issue when chaining style for date cell. 0.2.9 Merged pull request (https://github.com/natergj/excel4node/pull/29) from https://github.com/atsapenko to add ability to set dropdown validation 0.2.8 Merged pull request (https://github.com/natergj/excel4node/pull/27) from https://github.com/pookong to fix issue that would cause a numberformat to not apply to a cell 0.2.7 fixed issue that would prevent cells to be written to columns over 702 (26^2 + 26) column AAA or higher Merged pull request (https://github.com/natergj/excel4node/pull/26) from https://github.com/RafaPolit to fixe continuing issue with merging cells 0.2.6 fixed to merge issues after the 52nd column 0.2.5 fixed the 2nd sort function needed for proper cell merging in all cases. 0.2.4 fixed issue with cells not merging if one of the cells is after the 26th column. fixed xml validation issue if not style has been specified on the workbook. 0.2.3 fixed issue where groupings would cause an XML validation error when summaryBelow was set to true greatly reduced memory usage when added data to worksheets deprecated Workbook.Settings.outlineSummaryBelow() call. This will be removed in version 1 and a console log entry created when used. 0.2.2 fixed issue where incorrect string was displayed if cell had changed from a string to a number 0.2.1 fixed issue that would cause failure if no cells had been added to a worksheet prior to write function called 0.2.0 Near complete refactor. adds efficiency and speed and much more readable code. Added ability to create workbook with options. jszip options are first. more to come. Issue #20 Added ability to create workshets with options. margins, zoom and centering on print first. more to come. Issue #19 Added ability to add a Date to worksheet and set type as Date Fixed issue #22 where empty string would print 'undefined' in cell Fixed issue #21 where foreign characters would cause issue. 0.1.7 Merged pull request (https://github.com/natergj/excel4node/pull/18) from https://github.com/daviesjamie Added Asynchronous abilty to write function 0.1.6 added ability to set a row to be a Filter row finished Grouping feature 0.1.5 fixed issue where some Excel features (sorting, grouping, etc) where not available on first sheet of workbook if more than one worksheet existed continuing work on experimental Grouping features 0.1.4 fixed issue where sheet would not scroll properly if Freezing both a row and a column allowed for usage of color definitions in multiple formats 0.1.3 added ability to Freeze Rows 0.1.2 fixed issue with Font Alignment when applied directly to a cell module will no longer crash when String is passed an undefined value fixed sample to properly identify if it is running from within the module or not fixed issue where border would not always be applied to the correct cell range. 0.1.1 added ability to merge cells added ability to apply styles to range of cells added ability to apply formatting to cells and cell ranges without first creating a style fixed issue that would cause error when applying a row height if row had populated cells 0.0.10 merged pull request https://github.com/natergj/excel4node/pull/11 0.0.9 fixed issue where if a Worksheet was added, but then no cells added, execution would stop fixed issue where workbooks would cause MS Excel for Windows to crash on print preview fixed issue where if undefined or 0 value was passed to cell or row function, execution would stop added changelog 0.0.8 fixed issue where when adding a cell in a row not in sequence would cause corrupted excel data. 0.0.7 added ability to add borders to cells 0.0.6 added ability to include images in workbooks 0.0.5 added ability to Freeze columns from horizontal scrolling fixed bug where if a Cell had been previously set to a String and is changed to a Number, the cell would reference the shared string key of the number rather than displaying the number. 0.0.4 added ability to set text alignment of cells added ability to set text wrapping in cells fixed issue where fill were not being applied in certain circumstances 0.0.3 fixed bug where excel data was corrupted if write function was called twice. 0.0.1 initial push