CoreXLSX v0.10.0 Release Notes
Release Date: 2020-04-06 // almost 4 years ago-
๐ This is a release with bugfixes and a few improvements to usability of the spreadsheet cell values API. Thanks to all contributors and users, you provide an invaluable amount of feedback and help!
๐ New API:
The library now provides a simplified API to fetch string and date values from cells, which is much easier to use than the previous ๐ version (which is still available).
Here's how you can get all strings (including shared strings) in column "C" for example:
let sharedStrings = try file.parseSharedStrings() let columnCStrings = worksheet.cells(atColumns: [ColumnReference("C")!]) .compactMap { $0.stringValue(sharedStrings) }
๐ To parse a date value from a cell, use
dateValue
property on theCell
type:let columnCDates = worksheet.cells(atColumns: [ColumnReference("C")!]) .compactMap { $0.dateValue }
๐ฅ Breaking change:
The
type
property onCell
is no longer ofString
type. It was previously ๐ used to check if cell's type is equal to"s"
, which denoted a shared string. ๐ You should use enum values for that since this release, which for shared strings now is (unsurprisingly).sharedString
.Closed issues:
- ๐ Xcode 11 installation and build (#90)
- Reading Date values from cell (#89)
- Can't open xml (#82)
- Not able to read Numeric data from Sheet (#81)
- Getting the value of a cell with number format? (#71)
- Opening xlsx file Document Directory, Crashes (#52)
๐ Merged pull requests:
- officeDocument is misspelled in corePropreties Relationship (#95) via @mrkammoun
- โ Add cell type enum, date/sharedStrings helpers (#102) via @MaxDesiatov
- ๐ Make XLSXFile a class, not a struct (#100) via @MaxDesiatov
- ๐ Clarify lack of support for .xls files in README (#99) via @MaxDesiatov
- Clarify Xcode 11 and Xcode 10 project details (#98) via @MaxDesiatov
- โก๏ธ Update dependencies to their latest versions (#96) via @MaxDesiatov
- โก๏ธ Update SwiftFormat settings, add pre-commit (#97) via @MaxDesiatov
- ๐ Fix workbooks with no views, cleanup tests (#93) via @MaxDesiatov
- ๐ Test on Xcode 11.3 with macOS 10.15 (#92) via @MaxDesiatov
- โก๏ธ Update ZIPFoundation to 0.9.10 (#91) via @MaxDesiatov