DataJuggler.Excelerate
1.1.9
See the version list below for details.
dotnet add package DataJuggler.Excelerate --version 1.1.9
NuGet\Install-Package DataJuggler.Excelerate -Version 1.1.9
<PackageReference Include="DataJuggler.Excelerate" Version="1.1.9" />
paket add DataJuggler.Excelerate --version 1.1.9
#r "nuget: DataJuggler.Excelerate, 1.1.9"
// Install DataJuggler.Excelerate as a Cake Addin #addin nuget:?package=DataJuggler.Excelerate&version=1.1.9 // Install DataJuggler.Excelerate as a Cake Tool #tool nuget:?package=DataJuggler.Excelerate&version=1.1.9
Excelerate uses EPPPlus version 4.5.3.3 (last free version), 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.
I have a couple of clients that I build programs that automate combining columns from multiple Worksheets to form reports.
Rather than continue to write custom loaders, I really only need custom Exporters in most cases, so I created this project.
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net5.0 is compatible. net5.0-windows was computed. net6.0 was computed. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. |
-
net5.0
- DataJuggler.Net5 (>= 3.0.6)
- DataJuggler.UltimateHelper (>= 1.6.7)
- EPPlus (>= 4.5.3.3)
NuGet packages (2)
Showing the top 2 NuGet packages that depend on DataJuggler.Excelerate:
| Package | Downloads |
|---|---|
|
DataJuggler.Blazor.Components
This project consists of a TextBoxComponent, Multiline TextBox, CheckBox, ComboBox, CheckedListComboBox, CheckedListBox, Grid, Label, Calendar Component, Time Component and more. The CSS file DataJuggler.Blazor.Components.css contains many useful classes to help style and position objects. This version is for .Net 9.0. |
|
|
DataJuggler.SQLSnapshot
SQL Snapshot allows you to export a SQL Server database and all data rows to Excel with one line of code passing in a connectionstring and a path. |
GitHub repositories
This package is not used by any popular GitHub repositories.
| Version | Downloads | Last updated |
|---|---|---|
| 9.0.1 | 56 | 11/26/2024 |
| 9.0.0 | 186 | 11/13/2024 |
| 8.0.10 | 589 | 9/13/2024 |
| 8.0.9 | 485 | 9/11/2024 |
| 8.0.8 | 2,017 | 5/19/2024 |
| 8.0.7 | 108 | 5/19/2024 |
| 8.0.6 | 111 | 5/19/2024 |
| 8.0.5 | 507 | 5/4/2024 |
| 8.0.4 | 1,277 | 12/29/2023 |
| 8.0.3 | 426 | 12/29/2023 |
| 8.0.2 | 1,338 | 12/26/2023 |
| 8.0.1 | 564 | 11/17/2023 |
| 8.0.0 | 1,774 | 11/14/2023 |
| 7.4.6 | 1,233 | 8/28/2023 |
| 7.4.5 | 1,334 | 8/26/2023 |
| 7.4.4 | 883 | 8/13/2023 |
| 7.4.3 | 450 | 8/13/2023 |
| 7.4.2 | 660 | 7/24/2023 |
| 7.4.1 | 438 | 7/24/2023 |
| 7.4.0 | 503 | 7/23/2023 |
| 7.3.21 | 645 | 7/22/2023 |
| 7.3.20 | 657 | 7/22/2023 |
| 7.3.1 | 468 | 7/21/2023 |
| 7.3.0 | 484 | 7/16/2023 |
| 7.2.12 | 2,245 | 4/10/2023 |
| 7.2.11 | 529 | 4/10/2023 |
| 7.2.10 | 538 | 4/5/2023 |
| 7.2.9 | 596 | 4/2/2023 |
| 7.2.8 | 540 | 4/2/2023 |
| 7.2.7 | 521 | 4/1/2023 |
| 7.2.6 | 527 | 3/28/2023 |
| 7.2.5 | 530 | 3/28/2023 |
| 7.2.4 | 515 | 3/28/2023 |
| 7.2.3 | 524 | 3/28/2023 |
| 7.2.2 | 503 | 3/28/2023 |
| 7.2.1 | 503 | 3/28/2023 |
| 7.2.0 | 520 | 3/28/2023 |
| 7.1.12 | 534 | 3/28/2023 |
| 7.1.11 | 521 | 3/28/2023 |
| 7.1.10 | 527 | 3/28/2023 |
| 7.1.9 | 8,587 | 12/25/2022 |
| 7.1.8 | 6,031 | 12/16/2022 |
| 7.1.7 | 638 | 12/16/2022 |
| 7.1.6 | 943 | 12/11/2022 |
| 7.1.5 | 837 | 12/11/2022 |
| 7.1.4 | 2,694 | 12/4/2022 |
| 7.1.3 | 810 | 12/4/2022 |
| 7.1.2 | 636 | 12/4/2022 |
| 7.1.1 | 830 | 12/4/2022 |
| 7.1.0 | 4,412 | 11/15/2022 |
| 7.0.16 | 1,161 | 11/11/2022 |
| 7.0.15 | 685 | 11/11/2022 |
| 7.0.14 | 676 | 11/11/2022 |
| 7.0.12 | 658 | 11/11/2022 |
| 7.0.11 | 667 | 11/11/2022 |
| 7.0.10 | 633 | 11/10/2022 |
| 7.0.9 | 863 | 11/10/2022 |
| 7.0.8 | 657 | 11/10/2022 |
| 7.0.7 | 641 | 11/10/2022 |
| 7.0.6 | 646 | 11/10/2022 |
| 7.0.5 | 634 | 11/9/2022 |
| 7.0.4 | 859 | 11/9/2022 |
| 7.0.4-rc1 | 450 | 11/8/2022 |
| 7.0.3-rc1 | 481 | 11/7/2022 |
| 7.0.2-rc1 | 526 | 11/7/2022 |
| 7.0.1-rc1 | 432 | 11/7/2022 |
| 7.0.0-rc1 | 444 | 10/31/2022 |
| 6.0.3 | 924 | 9/28/2022 |
| 6.0.2 | 741 | 9/28/2022 |
| 6.0.1 | 1,018 | 4/1/2022 |
| 6.0.0 | 1,000 | 1/23/2022 |
| 1.7.3 | 753 | 11/30/2021 |
| 1.7.2 | 629 | 11/30/2021 |
| 1.7.1 | 627 | 11/30/2021 |
| 1.7.0 | 644 | 11/30/2021 |
| 1.6.0 | 620 | 11/29/2021 |
| 1.5.0 | 722 | 11/10/2021 |
| 1.4.4 | 733 | 11/8/2021 |
| 1.4.3 | 662 | 11/8/2021 |
| 1.4.2 | 676 | 11/8/2021 |
| 1.4.1 | 660 | 11/8/2021 |
| 1.4.0 | 662 | 11/8/2021 |
| 1.3.12 | 628 | 11/7/2021 |
| 1.3.10 | 660 | 11/7/2021 |
| 1.3.9 | 711 | 11/7/2021 |
| 1.3.8 | 748 | 11/7/2021 |
| 1.3.7 | 739 | 11/7/2021 |
| 1.3.6 | 793 | 11/7/2021 |
| 1.3.5 | 737 | 11/5/2021 |
| 1.3.4 | 736 | 11/5/2021 |
| 1.3.3 | 711 | 11/5/2021 |
| 1.3.2 | 747 | 11/5/2021 |
| 1.3.1 | 659 | 11/2/2021 |
| 1.3.0 | 639 | 11/2/2021 |
| 1.2.8 | 691 | 11/1/2021 |
| 1.2.7 | 651 | 10/31/2021 |
| 1.2.6 | 647 | 10/31/2021 |
| 1.2.5 | 725 | 10/31/2021 |
| 1.2.4 | 759 | 10/31/2021 |
| 1.2.3 | 722 | 10/31/2021 |
| 1.2.2 | 688 | 10/31/2021 |
| 1.2.1 | 685 | 10/31/2021 |
| 1.2.0 | 742 | 10/31/2021 |
| 1.1.9 | 644 | 10/16/2021 |
| 1.1.8 | 723 | 10/16/2021 |
| 1.1.7 | 682 | 10/14/2021 |
| 1.1.6 | 654 | 10/13/2021 |
| 1.1.5 | 687 | 9/21/2021 |
| 1.1.4 | 685 | 9/20/2021 |
| 1.1.3 | 670 | 9/20/2021 |
| 1.1.2 | 693 | 9/17/2021 |
| 1.1.1 | 667 | 9/17/2021 |
| 1.0.3 | 604 | 9/15/2021 |
| 1.0.2 | 633 | 9/14/2021 |
| 1.0.1 | 645 | 9/14/2021 |
| 1.0.0 | 677 | 9/14/2021 |
10.16.2021
Version 1.1.9: I added a new method LoadAllData, which returns a DataJuggler.Excelerate.Workbook, which contains all DataJuggler.Excelerate.Worksheets, which contain all DataJuggler.Excelerate.Rows of data.
10.16.2021:
Version 1.1.8: AppendPartialGuid is now an optional parameter, and only if true will the partial guid be appended to the filename.
10.14.2021:
Version 1.1.7: CodeGenerator.GenerateClassFromWorksheet now returns an object of type CodeGenerationResponse. Previous version only returns a boolean, which wasn't very helpful for the caller.
10.13.2021: New override for GetSheetNames takes a path argument.
I am working on a new Blazor project called Blazor.Excelerate to demo this project.
9.21.2021
Version 1.1.5:
I created an ExcelHelper class because I needed the GetColumnLetter feature of ExcelCellAddress.
9.20.2021
Version 1.1.4:
I updated ExcelDataLoader to havea LoadPackage method.
9.20.2021:
Version 1.1.3:
I added an OriginalFileName property to class Column, so the exported column header can be the same as the original.
9.17.2021
Version 1.1.2:
The Code Generator class is now finished, and a Load method has been updated to test for
a null row or null row.Columns just to be safer.
More updates may come in the future, but for now I have completed what I started this project for.
For the amount of effort I put into this, I think the return on investment is quite satisfactory as
now I can build Excel projects much faster.
9.17.2021
Version 1.1.1: I now code generate a Load method with the Code Generator, so a Row can be used to load an instance of the class created. This is still being tested.
9.15.2021
Version 1.0.3: I added a LoadWorksheet override, so clients do not have to load a Workbook to get
to a single worksheet.
This is the first release. I have just begun adding classes and helper methods to this. It does work for now to load a worksheet and all the Rows / Columns. Each column is loaded as an object ColumnValue, than properties exist that cast the ColumnValue as a bool, datetime, Decimal or other types.