v0.17.1

What's Changed

We have fixed bugs in the image insertion feature.

• fix: inserting duplicated images has wrong relationships (#98)
• fix: the retention of unnecessary image data (#95)

Migration Guide

Please use setColOpts and setRowOpts instead of setColProps and setRowProps.
The term 'Props' is commonly used in React components, so it was changed to avoid confusion.

worksheet.setColOpts({
  index: 0,
  width: 12,
  style: { fill: { patternType: "solid", fgColor: "FFFFFF00" } },
});

worksheet.setRowOpts({
  index: 0,
  height: 20,
  style: { fill: { patternType: "solid", fgColor: "FFFFFF00" } },
});

changes: v0.17.0...v0.17.1

v0.17.0

What's Changed

We have split some functionalities into modules.
By using only the necessary functions, it is possible to reduce the bundle size.
To easily benefit from this, classes named WorkbookS have been added.

• feat: Modules (#94)
• feat: support JPEG, PNG, GIF image formats (#89)

changes: v0.16.0...v0.17.0

v0.16.0

What's Changed

Image insertion capability added. Users can now insert images into worksheets.
This enhancement facilitates visual explanations.

• feat: images (#75)

changes: v0.15.0...v0.16.0

v0.15.0

What's Changed

Enhanced Conditional Formatting.

• feat: conditional formatting for date (#69)
• feat: dataBar conditional formatting (#71)
• feat: colorScale conditional formatting (#72)
• feat: iconSet conditional formatting (#73)
• feat: iconSet conditional formatting 2 (#74)

changes: v0.14.0...v0.15.0

v0.14.0

What's Changed

Conditional formatting for strings is now supported!

• feat: conditional formatting for strings (#66)
• fix: ConditionalFormatting is not exported (#67)
• fix: the empty sharedStringsXml (#68)

changes: v0.13.0...v0.14.0

v0.13.0

What's Changed

Conditional formatting for comparing numbers is now supported!

• feat: top and bottom conditional formatting (#60)
• feat: above average conditional formatting (#62)
• feat: duplicate values conditional formatting (#63)
• feat: conditional fomatting for comparing numbers (#64)

changes: v0.12.0...v0.13.0

v0.12.0

What's Changed

This release includes significant changes to col props and row props

• feat: setColProps (#57)
• feat: setRowProps (#56)

Migration Guide

Please use setColProps when setting the width and style of Col.
Similarly, use setRowProps for setting the height and style of Row.

worksheet.setColProps({
  index: 0,
  width: 12,
  style: { fill: { patternType: "solid", fgColor: "FFFFFF00" } },
});

worksheet.setRowProps({
  index: 0,
  height: 20,
  style: { fill: { patternType: "solid", fgColor: "FFFFFF00" } },
});

Thank you for your continued support!

changes: v0.11.0...v0.12.0

v0.11.0

What's Changed

This release includes significant changes to our file generation functionalities.

• feat: generateXlsxSync and generateXlsx (#54)

Migration Guide

For users migrating, please note the following:

• For as synchronous file generation, you should now switch to generateXlsxSync to maintain the same behavior.
• For as asynchronous file generation, use async/await syntax to treat the generateXlsx as a promise.

generateXlsx

async function save(){
  const xlsx = await wb.generateXlsx();
}

generateXlsxSync

function save(){
  const xlsx = await wb.generateXlsxSync();
}

We believe these updates will greatly enhance the flexibility and performance of your file handling operations.
Thank you for your continued support!

changes: v0.10.0...v0.11.0

V0.10.0

What's Changed

This version modified the hyperlink to accommodate multiple worksheets.
The usage of the new feature wordwrap is as follows.

ws.setCell(0, 0, {
  type: "string",
  value: "abcdefghijklmn",
  style: {
    alignment: {
      wordwrap: true,
    },
  },
});

• fix: hyperlinks with multiple sheets (#51)
• feat: wordwrap (#53)

changes: v0.9.0...v0.10.0

v0.9.0

Hyperlinks have been enhanced.

External links, internal links, and email links are available for use.

// external-link
ws.setCell(3, 0, {
  type: "hyperlink",
  linkType: "external",
  text: "google",
  value: "https://www.google.com/",
});

// internal-link
ws.setCell(3, 1, {
  type: "hyperlink",
  linkType: "internal",
  text: "to A1",
  value: "Sheet1!A1",
});

// email-link
ws.setCell(3, 2, {
  type: "hyperlink",
  linkType: "email",
  text: "sample",
  value: "sample@example.com",
});

What's Changed

• feat: hyperlink with text (#48)
• feat: Internal Hyperlink (#49)
• feat: email hyperlink (#50)

changes: v0.8.0...v0.9.0