FsSpreadsheet.ExcelIO 1.0.0

• .NETStandard 2.0

  • DocumentFormat.OpenXml (= 2.12.3)
  • FSharp.Core (>= 6.0.7)
  • FsSpreadsheet (>= 1.0.0 && < 2.0.0)

Additions:
rename Missing to SheetEntity
allow cell, row and column builders yield optional or required operator
make SheetEntity type more robust
change target framework
Merge pull request #8 from CSBiology/DSL
allow message type to be exception
Merge pull request #9 from CSBiology/DSL
add csv writing capabilities
replace build script by build project
rename ok operator to some to match SheetEntity case name
change dsl operator names
update test project target framework to net7.
init restructuring in functional style
rows now carry cell collection
Add static methods for FsWorksheet & FsRow
Add functionality & Triple Slash docu
Add static methods for FsCell
Add (static & non-static) methods for FsCellsCollection
Format FsRow.fs
Add ((non-)static) methods to FsWorkbook.fs
Add static methods and ///-docu for XLSX writer extensions
Add FsTable import functionality
Move Table.toFsTable to FsExtensions
Add more alternative constructor for FsWorksheet
Rename OpenXML-based methods
Comment out unfinished code to prevent building errors
Comment out warn-inducing elements
Rename FsRangeAdress.fs into correct english
Add playground script file for testing/developing purposes
Rename WorkSheet.fs to match module name
Renamed file again because Git does not understand
Re-renamed file to correct name
Reuse method instead of copypasting 95 % of the code
Add annotation
Add function to tranlate CellValue to DataType
Format format
Add function to get Tables in WorksheetPart
Play around in playground
Restructure format of FsCellsCollection
Restructure format of FsWorksheet
Correct naming mistake
Add methods to check for FsCell presence
Change method name for consistency reasons
Restructure format of FsRow
Add static methods for retrieving FsCells
Add exception for creation with an inappropriate FsCellsCollection
Play around in playground
Add critical annotation to properties
Add method to more easily add FsCells
Play around in playground
Add blueprint of method to implement later
Add several add methods
Add alternate constructor (WIP)
Play around in playground
Add Unit Test for DataType
Reformat format of FsAddress for readability/findability
Rename ambiguous method
Add methods for FsAddress
Add unit tests for FsAddress
Add more unit tests for FsCell
Let `UpdateIndices` method return the object
Add ignore to not-used value
Play around in playground
Add XML tags to member description
Add XML tags to member description
Sheet Index and SheetId ambiguity
Add IO testing data
Add Test project for FsSpreadsheet.ExcelIO
Move data folder for Xlsx tests into FsSpreadsheet.ExcelIO folder
Add Expecto test call
Format format
Add Spreadsheet tests
Add Workbook tests
Add Sheet tests
Add more Spreadsheet tests
Change tested property
Add Cell tests
Refactoring FsCell
Merge FsCell Testing
Add FsWorksheet add FsCell
Add FsSparseMatrix
Add FsCell construtcor IConvertible value
Update `tryItem` to be 1-based like the OpenXML implementation
Update testCells to have their real values instead of SST index
Add FsWorkbook FromXlsxStream extension
Refactor FsWorkbook
Play around in playground
Add ///-XML tags
Add static method for reader method
Add FsWorksheet table methods alongside respective tests
Git still does not understand changes in letter case, part I
Git still does not understand changes in letter case, part II
Add `.AddTables` functionality (+ unit tests)
Reformat code structure
Add methods to get FsWorksheet by name + unit tests
Finalize `FromXlsxStream` method
Add unit tests for `FromXlsxStream` method (WIP)
Add CellValues to DataType conversion (+ unit tests)
Specify member description
Precise `ofXlsxCell` method alongside with unit tests
Update test Xlsx file
Play around in playground
Rename incorrectly named source file
Finalize unit tests for `fsWorkbookFromStream` method
Play around in playground
Add `fromXlsxFile` method
Add method for getting FsTables from FsWorkbooks
Add unit tests for `GetTables`
Add method to get the FsWorksheet of an FsTable
Add method to add several FsWorksheets + unit tests
Add some ///-description
Add more FsTable methods
Add address returning methods to FsCellsCollection
Change exception for 0,0 indices in `GetFirstAddress()`
Add FsCellsCollection tests (WIP)
Add FsTable tests (WIP)
Finalize current FsCellsCollection tests
Add ///-description
Update FsTable tests (WIP)
Add table field unit tests (WIP)
Add cellsColl deep copy (WIP)
Add rangeBase annotations
Add commented alternative constructor
Add static methods, update existing methods
Update index setter & `DataCells`
Finalize FsTableField unit tests
Update FsTable functionality (WIP)
Play around in playground
Add method to add several fields at once to table
Add unit tests to FsTable
Add method for creating range cols out of addresses
Adjust method return for FsAddress
Reformat FsCell structure
Setup docs, add some methods, downgrade to .NET 6, ...
Merge pull request #17 from CSBiology/datamodel
Add build.sh to sln
Update build and deploy actions
Update Logo
Add FsTable unit tests (WIP)
Add deep copy methods to all relevant classes
Deletions:
Add remove methods to FsCellsCollection
Add methods to remove FsCell values
Delete sample Unit Test
Delete wrong exception
Delete '.' from message due to it confusing YoloDev adapter
FsCell Remove alternatve constructors
Bugfixes:
Fix error (wrong member call)
Fix critical FsWorksheet error and add non-static methods for functionalities
Fix naming-related error
Fix critical error in getter method
Fix critical error according to the correct meaning of properties
Fix merge
Fix error when trying to get colIndex
Fix typo in test file
Fix critical XlsxCell error (+ respective unit test)
Fix null reference error (+ unit test)
Fix possible error due to hard coding
Fix typo
Add and fix table field functionality
Finalize FsTable, fix indexing error
Update table unit tests, fix XML comment typos
Fix critical return type error