excel

Modifications

• Modified Readme.md

Modifications

• Modified Readme.md

Breaking Changes

• CellIndex.indexByColumnRow() now requires non-null integers of row index and column index

Breaking Changes

• Renamed Formula to FormulaCellValue
• Cells value now represented by the sealed class CellValue instead of dynamic. Subtypes are TextCellValue FormulaCellValue, IntCellValue, DoubleCellValue, DateCellValue, TextCellValue, BoolCellValue, TimeCellValue, DateTimeCellValue and they allow for exhaustive switch (see Dart Docs (sealed class modifier)).

Added

• Added support for date, time and date-time values
• Added support for custom number formats
• Strict typing for cell values (that allow for exhaustive switch statements)

Fixed

• Issue where seamingly random values are converted to a date iso8601 string, caused by incorrect interpretation of numFmtId=164
• Fixed corrupt excel file when writing large datasets with improvements in shared_strings

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

Improved

• Add border functionality

Fixed

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

Improved

• Automated Publishing.

Improved

• Readme updated.

Improved

• Fix bug on header and footer.

Improved

• Forcefully initializing the variables on re-creation

Improved

• Fix of sharedStringTarget fail to initialize issue

Improved

• Fix of value not updating in cell

Improved

• Null-safety

Improved

• Fixes

Improved

• Improvement in speed of apeending the rows

Improved

• Improvement in speed of apeending the rows

Improved

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

Improved

• Health Improvement

Improved

• Bugs on deleting sheet

Added

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

Improved

• Faster Processing

Removed

• Bugs related to appendRows

Removed

• Bugs related to removal of rows

Added Functionality

• Find and Replace
• Add row / column from Iterables

Removed

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

Improved

• Analysis related changes
• Vertical Alignment Issue

Added

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

Improved

• Minor Bugs

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

• Initial Release