excel 3.0.0

A flutter and dart library for reading, creating, editing and updating excel sheets with compatible both on client and server side.

Changelog

All notable changes to this project will be documented in this file.

The format is based on Keep a Changelog, and this project adheres to Semantic Versioning.

[Unreleased]

[3.0.0] - 2023-07-30

Breaking Changes

• Renamed getColAutoFits() to getColumnAutoFits(), and changed return type to Map<int, bool> in Sheet
• Renamed getColWidths() to getColumnWidths(), and changed return type to Map<int, double> in Sheet
• Renamed getColAutoFit() to getColumnAutoFit() in Sheet
• Renamed getColWidth() to getColumnWidth() in Sheet
• Renamed setColAutoFit() to setColumnAutoFit() in Sheet
• Renamed setColWidth() to setColumnWidth() in Sheet

Added

• Add setMergedCellStyle() to Sheet, allowing to set style for merged cells
• Add setDefaultRowHeight(), setDefaultColumnWidth() to Sheet
• Add defaultRowHeight and defaultColumnWidth properties to Sheet
• Add getRowHeights(), getRowHeight() and setRowHeight to Sheet
• Add pub topics

Improved

• Support sharedStrings absolute path
• Loosen up dependency constraints
• Clean up markdown files
• Clean up code

Fixed

• Fixed many instances of missing/wrong data by comparing strings instead of hashes
• Ignore shared text in 'rPh' element
• Fix findAndReplace() not doing anything

[2.1.0] - 2023-03-30

Improved

• Add border functionality

Fixed

• Fix Header and Footer with special characters
• Fix sheet.merge()

[2.0.4] - 2023-03-12

Improved

• Automated Publishing.

[2.0.3] - 2023-03-12

Improved

• Readme updated.

[2.0.2] - 2023-03-12

Improved

• Fix bug on header and footer.

[2.0.0-null-safety-4] - 2022-02-15

Improved

• Fix saving XLXS bug on archive 3.2.0

[2.0.0-null-safety-3] - 2021-04-29

Improved

• Forcefully initializing the variables on re-creation

[2.0.0-null-safety-2] - 2021-04-29

Improved

• Fix of sharedStringTarget fail to initialize issue

[2.0.0-null-safety-1] - 2021-04-29

Improved

• Fix of value not updating in cell

[2.0.0-null-safety] - 2021-03-28

Improved

• Null-safety

[1.1.5] - 2020-08-17

Improved

• Fixes

[1.1.4] - 2020-07-23

Improved

• Improvement in speed of apeending the rows

[1.1.3] - 2020-07-23

Improved

• Improvement in speed of apeending the rows

[1.1.2] - 2020-07-18

Improved

• Iterating Sheet's Data Object to operate on particular cells

[1.1.1] - 2020-07-18

Improved

• Health Improvement

[1.1.0] - 2020-06-26

Improved

• Bugs on deleting sheet

[1.0.9] - 2020-06-06

Added

• Copy
• Rename
• Delete
• Link Sheets
• Un-Link Sheets
• Font Family
• Font Size
• Italic
• Underline
• Bold

Improved

• Faster Processing

[1.0.8] - 2020-05-23

Removed

• Bugs related to appendRows

[1.0.7] - 2020-05-21

Removed

• Bugs related to removal of rows

[1.0.6] - 2020-05-21

Added Functionality

• Find and Replace
• Add row / column from Iterables

[1.0.5] - 2020-05-15

Removed

• Bugs related to Spanning
• Unwanted removal of rows and columns from spanned cells

[1.0.4] - 2020-05-10

Improved

• Analysis related changes
• Vertical Alignment Issue

[1.0.3] - 2020-05-10

Added

• Merging of Rows and Columns
• Un-Merging of Rows and Columns
• Font Color
• Background Color
• Setting Default Sheet

[1.0.2] - 2020-02-18

Improved

• Minor Bugs

[1.0.1] - 2020-02-18

Added

• TextWrapping and (Clip in Google Sheets) / (ShrinkToFit in Microsoft Excel)
• Horizontal and Vertical Alignment
• Update Cell by Cell-Name ("A1")

Improved

• Health Maintenance

Fixes

• Minor Bug Fixes

[1.0.0] - 2020-02-18

• Initial Release