Excelerate has been updated for .NET10. Use a 9x version for .NET9, Use an 8.x version for .NET8, a 7.x version for .NET7. All new development is on the .NET 10 version. Excelerate will change how you work with C# and Excel. Excelerate uses NPOI and it makes it easy to load Workbooks or Worksheets. Excelerate now has a code generation feature, you can create a C# class from a header row. Excelerate also has helper classes to allow you load and save entire workbooks or worksheets without ever having referring to a cell. Use my free site https://excelerate.datajuggler.com to code generate C# classes from Excel header rows. ExcelDataLoader will load a workbook by passing in a path or a Worksheet by passing in a a WorksheetInfo object to specify what to load. Background I have a couple of clients that I built programs that automate Excel processes. This project streamlines Excel development.
Get Started
$ dotnet add package DataJuggler.ExcelerateReadme
<img height=192 width=192 src=https://github.com/DataJuggler/Blazor.Excelerate/blob/main/wwwroot/Images/ExcelerateLogoSmallWhite.png>
Live Demo
Blazor.Excelerate https://excelerate.datajuggler.com Code Generate C# Classes From Excel Header Rows
Updates
7.22.2023: I am in the process of redoing SaveRow for the code generated objects. Now each class has two properties created. Loading, and ChangedColumns, which is a comma delimited string of column indexes that have chagned. The next phase will be only saving columns that have changes.
7.21.2023: I added a property to the column object called HasChanges. In conjunection with this the class ExcelHelper has an optional parameter to SaveBatch, SaveBatchItem and SaveRow to only save columns with HasChanges = true. For now, you have to set this property on the column manually. I am investigating ways to auto set this if the value changes from the time you loaded the object until you save it.\
7.16.2023: DataJuggler.UltimateHelper, DataJuggler.Net7 was updated.
Update 4.4.2023
I just released a cool project that uses this package.
DataJuggler.SQLSnapshot Export a SQL Server database and all data rows with just a connection string and the path to save the Excel file. Nuget DataJuggler.SQLSnapshot https://github.com/DataJuggler/SQLSnapshot
And a demo project for the above project https://github.com/DataJuggler/DemoSQLSnapshot
Update 11.11.2022: I am working on the Grid, and added a properties to the column object
and some code to the ValidationComponent to allow SetFocusOnFirstRender.
Update 11.9.2022 - 11.10.2022:
I added some new properties and enumerations for editing data in the Grid in DataJuggler.Blazor.Components.
Update 11.8.2022:
I added some new properties to the row and Column object for use with the Grid for DataJuggler.Blazor.Components.
Update 10.31.2022:
LoadWorksheetInfo.ExcludedColumnIndexes was added. This is a collection of integers to not load. I may expand this to column names also as an option.