DataJuggler.Excelerate 1.1.4

.NET 5.0 This package targets .NET 5.0. The package is compatible with this framework or higher.
There is a newer version of this package available.
See the version list below for details. 
dotnet add package DataJuggler.Excelerate --version 1.1.4                

                    
                

            
NuGet\Install-Package DataJuggler.Excelerate -Version 1.1.4
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<PackageReference Include="DataJuggler.Excelerate" Version="1.1.4" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add DataJuggler.Excelerate --version 1.1.4                

                    
                

            
#r "nuget: DataJuggler.Excelerate, 1.1.4"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package. 
// Install DataJuggler.Excelerate as a Cake Addin
#addin nuget:?package=DataJuggler.Excelerate&version=1.1.4

// Install DataJuggler.Excelerate as a Cake Tool
#tool nuget:?package=DataJuggler.Excelerate&version=1.1.4

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 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.  net9.0 was computed.  net9.0-android was computed.  net9.0-browser was computed.  net9.0-ios was computed.  net9.0-maccatalyst was computed.  net9.0-macos was computed.  net9.0-tvos was computed.  net9.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

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 377 11/26/2024
9.0.0 210 11/13/2024
8.0.10 690 9/13/2024
8.0.9 541 9/11/2024
8.0.8 2,188 5/19/2024
8.0.7 115 5/19/2024
8.0.6 118 5/19/2024
8.0.5 534 5/4/2024
8.0.4 1,286 12/29/2023
8.0.3 431 12/29/2023
8.0.2 1,343 12/26/2023
8.0.1 583 11/17/2023
8.0.0 1,785 11/14/2023
7.4.6 1,242 8/28/2023
7.4.5 1,343 8/26/2023
7.4.4 888 8/13/2023
7.4.3 455 8/13/2023
7.4.2 665 7/24/2023
7.4.1 443 7/24/2023
7.4.0 508 7/23/2023
7.3.21 649 7/22/2023
7.3.20 662 7/22/2023
7.3.1 473 7/21/2023
7.3.0 489 7/16/2023
7.2.12 2,251 4/10/2023
7.2.11 535 4/10/2023
7.2.10 544 4/5/2023
7.2.9 602 4/2/2023
7.2.8 546 4/2/2023
7.2.7 527 4/1/2023
7.2.6 534 3/28/2023
7.2.5 537 3/28/2023
7.2.4 522 3/28/2023
7.2.3 531 3/28/2023
7.2.2 510 3/28/2023
7.2.1 510 3/28/2023
7.2.0 527 3/28/2023
7.1.12 541 3/28/2023
7.1.11 528 3/28/2023
7.1.10 534 3/28/2023
7.1.9 8,593 12/25/2022
7.1.8 6,037 12/16/2022
7.1.7 644 12/16/2022
7.1.6 949 12/11/2022
7.1.5 843 12/11/2022
7.1.4 2,702 12/4/2022
7.1.3 818 12/4/2022
7.1.2 644 12/4/2022
7.1.1 838 12/4/2022
7.1.0 4,420 11/15/2022
7.0.16 1,171 11/11/2022
7.0.15 693 11/11/2022
7.0.14 684 11/11/2022
7.0.12 666 11/11/2022
7.0.11 675 11/11/2022
7.0.10 643 11/10/2022
7.0.9 871 11/10/2022
7.0.8 665 11/10/2022
7.0.7 651 11/10/2022
7.0.6 654 11/10/2022
7.0.5 642 11/9/2022
7.0.4 867 11/9/2022
7.0.4-rc1 455 11/8/2022
7.0.3-rc1 485 11/7/2022
7.0.2-rc1 530 11/7/2022
7.0.1-rc1 438 11/7/2022
7.0.0-rc1 449 10/31/2022
6.0.3 932 9/28/2022
6.0.2 749 9/28/2022
6.0.1 1,026 4/1/2022
6.0.0 1,011 1/23/2022
1.7.3 763 11/30/2021
1.7.2 637 11/30/2021
1.7.1 635 11/30/2021
1.7.0 652 11/30/2021
1.6.0 628 11/29/2021
1.5.0 730 11/10/2021
1.4.4 741 11/8/2021
1.4.3 669 11/8/2021
1.4.2 684 11/8/2021
1.4.1 668 11/8/2021
1.4.0 670 11/8/2021
1.3.12 636 11/7/2021
1.3.10 668 11/7/2021
1.3.9 719 11/7/2021
1.3.8 756 11/7/2021
1.3.7 747 11/7/2021
1.3.6 801 11/7/2021
1.3.5 746 11/5/2021
1.3.4 745 11/5/2021
1.3.3 719 11/5/2021
1.3.2 756 11/5/2021
1.3.1 667 11/2/2021
1.3.0 647 11/2/2021
1.2.8 701 11/1/2021
1.2.7 659 10/31/2021
1.2.6 655 10/31/2021
1.2.5 733 10/31/2021
1.2.4 767 10/31/2021
1.2.3 730 10/31/2021
1.2.2 696 10/31/2021
1.2.1 693 10/31/2021
1.2.0 750 10/31/2021
1.1.9 653 10/16/2021
1.1.8 731 10/16/2021
1.1.7 690 10/14/2021
1.1.6 662 10/13/2021
1.1.5 695 9/21/2021
1.1.4 694 9/20/2021
1.1.3 678 9/20/2021
1.1.2 701 9/17/2021
1.1.1 675 9/17/2021
1.0.3 612 9/15/2021
1.0.2 643 9/14/2021
1.0.1 653 9/14/2021
1.0.0 687 9/14/2021

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.