DataJuggler.Excelerate
1.2.4
See the version list below for details.
dotnet add package DataJuggler.Excelerate --version 1.2.4
NuGet\Install-Package DataJuggler.Excelerate -Version 1.2.4
<PackageReference Include="DataJuggler.Excelerate" Version="1.2.4" />
paket add DataJuggler.Excelerate --version 1.2.4
#r "nuget: DataJuggler.Excelerate, 1.2.4"
// Install DataJuggler.Excelerate as a Cake Addin #addin nuget:?package=DataJuggler.Excelerate&version=1.2.4 // Install DataJuggler.Excelerate as a Cake Tool #tool nuget:?package=DataJuggler.Excelerate&version=1.2.4
Happy Halloween!
| 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 an ImageButton, ProgressBar, Sprite, TextBoxComponent which can display as a TextBox, Multi-line TextBox or a CheckBox, a ComboBox, CheckedListComboBox, CheckedListBox, Grid, Label and a brand new Calendar Component. The CSS file DataJuggler.Blazor.Components.css contains many useful classes to help style and position objects. This version is for .Net 8.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 |
|---|---|---|
| 8.0.10 | 171 | 9/13/2024 |
| 8.0.9 | 172 | 9/11/2024 |
| 8.0.8 | 1,434 | 5/19/2024 |
| 8.0.7 | 102 | 5/19/2024 |
| 8.0.6 | 105 | 5/19/2024 |
| 8.0.5 | 371 | 5/4/2024 |
| 8.0.4 | 1,249 | 12/29/2023 |
| 8.0.3 | 422 | 12/29/2023 |
| 8.0.2 | 1,334 | 12/26/2023 |
| 8.0.1 | 558 | 11/17/2023 |
| 8.0.0 | 1,722 | 11/14/2023 |
| 7.4.6 | 1,223 | 8/28/2023 |
| 7.4.5 | 1,325 | 8/26/2023 |
| 7.4.4 | 880 | 8/13/2023 |
| 7.4.3 | 441 | 8/13/2023 |
| 7.4.2 | 656 | 7/24/2023 |
| 7.4.1 | 433 | 7/24/2023 |
| 7.4.0 | 500 | 7/23/2023 |
| 7.3.21 | 642 | 7/22/2023 |
| 7.3.20 | 653 | 7/22/2023 |
| 7.3.1 | 459 | 7/21/2023 |
| 7.3.0 | 479 | 7/16/2023 |
| 7.2.12 | 2,240 | 4/10/2023 |
| 7.2.11 | 526 | 4/10/2023 |
| 7.2.10 | 533 | 4/5/2023 |
| 7.2.9 | 593 | 4/2/2023 |
| 7.2.8 | 537 | 4/2/2023 |
| 7.2.7 | 518 | 4/1/2023 |
| 7.2.6 | 524 | 3/28/2023 |
| 7.2.5 | 527 | 3/28/2023 |
| 7.2.4 | 510 | 3/28/2023 |
| 7.2.3 | 521 | 3/28/2023 |
| 7.2.2 | 498 | 3/28/2023 |
| 7.2.1 | 498 | 3/28/2023 |
| 7.2.0 | 509 | 3/28/2023 |
| 7.1.12 | 531 | 3/28/2023 |
| 7.1.11 | 518 | 3/28/2023 |
| 7.1.10 | 524 | 3/28/2023 |
| 7.1.9 | 8,582 | 12/25/2022 |
| 7.1.8 | 6,028 | 12/16/2022 |
| 7.1.7 | 635 | 12/16/2022 |
| 7.1.6 | 940 | 12/11/2022 |
| 7.1.5 | 834 | 12/11/2022 |
| 7.1.4 | 2,683 | 12/4/2022 |
| 7.1.3 | 807 | 12/4/2022 |
| 7.1.2 | 633 | 12/4/2022 |
| 7.1.1 | 827 | 12/4/2022 |
| 7.1.0 | 4,405 | 11/15/2022 |
| 7.0.16 | 1,157 | 11/11/2022 |
| 7.0.15 | 674 | 11/11/2022 |
| 7.0.14 | 673 | 11/11/2022 |
| 7.0.12 | 655 | 11/11/2022 |
| 7.0.11 | 661 | 11/11/2022 |
| 7.0.10 | 624 | 11/10/2022 |
| 7.0.9 | 860 | 11/10/2022 |
| 7.0.8 | 648 | 11/10/2022 |
| 7.0.7 | 638 | 11/10/2022 |
| 7.0.6 | 643 | 11/10/2022 |
| 7.0.5 | 631 | 11/9/2022 |
| 7.0.4 | 849 | 11/9/2022 |
| 7.0.4-rc1 | 447 | 11/8/2022 |
| 7.0.3-rc1 | 472 | 11/7/2022 |
| 7.0.2-rc1 | 523 | 11/7/2022 |
| 7.0.1-rc1 | 429 | 11/7/2022 |
| 7.0.0-rc1 | 440 | 10/31/2022 |
| 6.0.3 | 910 | 9/28/2022 |
| 6.0.2 | 736 | 9/28/2022 |
| 6.0.1 | 1,010 | 4/1/2022 |
| 6.0.0 | 993 | 1/23/2022 |
| 1.7.3 | 748 | 11/30/2021 |
| 1.7.2 | 620 | 11/30/2021 |
| 1.7.1 | 622 | 11/30/2021 |
| 1.7.0 | 638 | 11/30/2021 |
| 1.6.0 | 617 | 11/29/2021 |
| 1.5.0 | 713 | 11/10/2021 |
| 1.4.4 | 730 | 11/8/2021 |
| 1.4.3 | 658 | 11/8/2021 |
| 1.4.2 | 673 | 11/8/2021 |
| 1.4.1 | 657 | 11/8/2021 |
| 1.4.0 | 659 | 11/8/2021 |
| 1.3.12 | 622 | 11/7/2021 |
| 1.3.10 | 655 | 11/7/2021 |
| 1.3.9 | 708 | 11/7/2021 |
| 1.3.8 | 745 | 11/7/2021 |
| 1.3.7 | 733 | 11/7/2021 |
| 1.3.6 | 790 | 11/7/2021 |
| 1.3.5 | 732 | 11/5/2021 |
| 1.3.4 | 731 | 11/5/2021 |
| 1.3.3 | 707 | 11/5/2021 |
| 1.3.2 | 742 | 11/5/2021 |
| 1.3.1 | 654 | 11/2/2021 |
| 1.3.0 | 634 | 11/2/2021 |
| 1.2.8 | 679 | 11/1/2021 |
| 1.2.7 | 646 | 10/31/2021 |
| 1.2.6 | 638 | 10/31/2021 |
| 1.2.5 | 720 | 10/31/2021 |
| 1.2.4 | 755 | 10/31/2021 |
| 1.2.3 | 719 | 10/31/2021 |
| 1.2.2 | 685 | 10/31/2021 |
| 1.2.1 | 682 | 10/31/2021 |
| 1.2.0 | 738 | 10/31/2021 |
| 1.1.9 | 641 | 10/16/2021 |
| 1.1.8 | 714 | 10/16/2021 |
| 1.1.7 | 675 | 10/14/2021 |
| 1.1.6 | 650 | 10/13/2021 |
| 1.1.5 | 679 | 9/21/2021 |
| 1.1.4 | 674 | 9/20/2021 |
| 1.1.3 | 667 | 9/20/2021 |
| 1.1.2 | 688 | 9/17/2021 |
| 1.1.1 | 664 | 9/17/2021 |
| 1.0.3 | 601 | 9/15/2021 |
| 1.0.2 | 630 | 9/14/2021 |
| 1.0.1 | 639 | 9/14/2021 |
| 1.0.0 | 672 | 9/14/2021 |
10.31.2021: (Take Five)
Version 1.2.4: I fixed the Active field = boolean. I need an else so the data type didn't get set to Int further in the AttemptToDetermineDataType method.
10.31.2021: (Take Four)
Version 1.2.3: Added a check for data type boolean. To make this work, convert Excel bool values to True False vs 0 and 1.
10.31.2021 (Take Three)
Version 1.2.2: Code generation is fixed with a reference to System is needed since Guid RowId has been added.
10.31.2021 (Take Two)
Version 1.2.1: I messed up the code generation in Version 1.2.0 because the RowId field wasn't getting a field name written. Should work now.
10.31.2021:
Version 1.2.0: The code generation of the RowId seems to work, so the 1.2 version starts the Saving features.
10.31.2021
Version 1.1.10: I added RowNumber and Id (Guid) to class Row to help in saving, which I am just starting.
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.