V4.4.7

Change Log:

New Feature

• 1: Add missing tooltip attribute to CellHyperlinkValue index.d.ts. Thank you @NiklasPor, Merged PR2350
• 2: Add support for dashed BorderStyle. Thank you @gltjk , Merged PR2309

BugFix

• 1: Fix xlsx parser can not compatible with rich text tags that are not closed. Thank you @WingMrL , Merged PR2001
• 2: Repair all 'c2fo.io' links ('c2fo.github.io'). Thank you @justintunev7, Merged PR2324

新的功能

• 1: 添加 CellHyperlinkValue.tooltip 的声明类型
• 2: 添加 BorderStyle dashed

BugFix

• 1: 读取xlsx时某些富文本类型报错问题
• 2: 替换过时的 fast-csv 文档地址

V4.4.6

Change Log:

New Feature

• 1: Add ignoreNodes parameter when reading excel to improve performance. Thank you hofnarwillie , Merged PR2132 and Merged #24, document：link

新的功能

• 1: 读取excel的时候加入忽略节点参数（ignoreNodes）用以提高性能, 文档地址：link

V4.4.5

Change Log:

New Feature

• 1: Add type definition for worksheet.properties.outlineProperties. Thank you @albeniraouf, Merged #20
• 2: Add type definition for color.indexed. Thank you @zurmokeeper , Merged #20
• 3: Add cell.removeNote func. Thank you dolbyzerr , Merged PR1746

BugFix

• 1: Fix multiple print areas error. Thank you @5kahoisaac , Merged #17

新的功能

• 1: 添加 worksheet.properties.outlineProperties 的声明类型
• 2: 添加 color.indexed 的声明类型和每个枚举值对应的具体颜色值
• 3: 添加单元格的移除注释的功能，cell.removeNote 方法

BugFix

• 1: 修复同时设置多个打印区域失败问题

New Contributor

• @albeniraouf
• @5kahoisaac

V4.4.4

Change Log:

New Feature

• 1: Added col breaks feature. Thank you StefanNedelchev, Merged PR13. Documentation is located:

新的功能

• 1: 支持给列加分页符，文档地址：

Code snippets: 

col.addPageBreak();

New Contributor

• @StefanNedelchev

V4.4.3

Change Log:

• 1: BugFix: Dropdown Excel js there is limitation of accepting 255 characters and beyond that throws error.
• 2: BugFix: cell.style.fill problems, Thank you styunan, Merged PR1573.

V4.4.2

Change Log:

• 1: Fixbug: Internal hyperlink does not work on wps office. (Break change) and support new internal hyperlink methods。
• 2：Add type definition for WorksheetModel.merges, Thank you ytjmt, Merged PR2281.
• 3：Add type definition for WorksheetProtection.spinCount,Thank you damingerdai, Merged PR2284.

PS: Since V4.4.2 @zurmokeeper/exceljs new cell insertion internal hyperlink support Sheet2!A1:B1 and A1:B1 and other forms, the original only supports Sheet2!A1, use the following way:：

const wb = new ExcelJS.Workbook();
const ws1 = wb.addWorksheet('Sheet1');
const ws2 = wb.addWorksheet('Sheet2');

'#' is required, @zurmokeeper/exceljs is to distinguish internal hyperlink by '#', the default will be considered non-internal hyperlink, older versions also need to manually add '#' , how not to add if
// internal hyperlink
ws1.getCell('A1').value = { text: 'Sheet2', hyperlink: '#Sheet2!A1' };

// internal hyperlink
ws1.getCell('A1').value = { text: 'Sheet2', hyperlink: '#Sheet2!A1:B1' };

// internal hyperlink
ws1.getCell('A1').value = { text: 'Sheet2', hyperlink: '#A1:B1' };

V4.4.1

Change Log:

• Add nested columns feature. Thank you jeka1985, Merged PR1889.

  Code snippets: 
  
  // new api: worksheet.makeColumns(headers)
  

• Add file encryption function.

  Code snippets: 
  
  await workbook.xlsx.writeFile(filename, {password: '123456'});
  

V4.4.0

Change Log:

• Add decryption of excel files with password encryption (Support frontend and backend)
• Bug fix

PS: The project code is forked from exceljs, based on the last commit on 2023-5-5, [commitid](https://github.com/exceljs/exceljs/commit/ ec92cb3b898bdf7f806ff9d7b8370c955ee8ba20), Since the latest version of exceljs is v4.3.0, sincere thanks to all the developers of the exceljs project. These commits were not released as new versions. So they are integrated in this commit and released as a new version