3.3.1

What's happened since 3.3.0?

• We revived this library - people keep using it, and keep submitting patches. I'll support them in that.
• some concurrent testing issues were fixed and switched over to using the quicktest library inl ine with the bulk of the testing. (Thanks benedictjohannes.
• We support go1.2.1! (Thanks egon.nijns)
• A bunch of memory leaks have been fixed (Thanks Olivier Mengué)

3.3.0

Minor release comprising 18 months' worth of bug fixes and minor maintenance tasks.

What's Changed

• Improve wording in the README. by @xStrom in #741
• fix: memory leak risk when file write err by @echoface in #744
• fix datavalidation dorplist size by @yixinin in #720
• Allow to add names to the workbook by @LeonB in #733
• fix cell regex expression match f tag in a cell by @horsley in #740
• Upgrade CodeSee workflow to version 2 by @codesee-maps in #751
• fix(row-limit): add ns to close tag by @xieziheng1 in #757
• Bump golang.org/x/text from 0.3.3 to 0.3.8 by @dependabot in #753
• go.mod: upgrade Go to 1.18 to split dependencies by @dolmen in #758
• Upgrade dependencies by @dolmen in #759
• Upgrade GitHub CI by @dolmen in #760

New Contributors

• @echoface made their first contribution in #744
• @yixinin made their first contribution in #720
• @LeonB made their first contribution in #733
• @horsley made their first contribution in #740
• @codesee-maps made their first contribution in #751
• @xieziheng1 made their first contribution in #757
• @dependabot made their first contribution in #753
• @dolmen made their first contribution in #758

Full Changelog: v3.2.4...v3.2.5

3.2.4

Captures a number of fixes since the last release, for details see here.

v3.2.3

This release fixes a single issue that caused panics when writing files, derived from existing files, where one or more of the existing sheets had not been visited and thus had no currentRow set on the Sheet. See issue #644 for details.

v3.2.2

This release addresses critical flaws in v3.2.1 (see: https://github.com/tealeg/xlsx/milestone/14):

• Fixes #641
• Fixes #638

v3.2.1 [USE WITH CARE]

There are serious known bugs in this release. We're working to resolve them and a 3.2.2 will follow as soon as possible.

Issues resolved in this release - see v3.2.1 milestone :

• Empty cells are filled by the first column name - v3.2.0 #594
• High memory usage while creating a xlsx file and xlsx.UseDiskVCellStore not working #596
• Fixes internal links #620
• Combine cells in the same sheet and set the droplist. Excel is damaged #610

This release was requested as people are waiting on some of the bug fixes. All outstanding bugs for the milestone have been pushed onto the v3.3.0 milestone instead.

v3.2.0

This release comprises the following changes:

• The addition of Cell.GetCoordinates() and Row.GetCoordinate() functions that fix issue #586 .
• #581 allows the Row.WriteSlice method to accept slices as a target instead of just pointers to slices (the old behaviour is still supported).
• #582 polishes some code a little but has no external effects.

v3.1.1

Summary

Version 3.1.1 fixes a bug that causes cell values to be blanked (or actually be zero-value structs) when reading a sheet that contains hyperlinks. See issue #574 .

v3.1.0

Summary

Version 3.1.0 fixes a number of significant issues and adds support for font strike-through, but should otherwise be 100% compatible with v3.0.0.

Changes

A full list of changes can be found here

v3.0.0

Summary

Version 3.0.0 of the xlsx library fixes a significant number of issues, but breaks backwards compatibility in order to do so. For a full list of changes see the milestone.

DiskV backend

You can now optionally pass the UseDiskVCellStore operation to all methods that open, or create an xlsx.File. Selecting this option will result in much lower memory usage when handling large sheets, but will run slightly slower than the default in-memory cell store backend.

Streaming support removed

If you were previously using the StreamFileBuilder you should use V2 of this library of earlier.

Sheet.ForEachRow and Row.ForEachCell accept options.

You can indicate that you'd like to SkipEmptyRows or SkipEmptyCells.