DataJuggler.Excelerate
1.3.3
See the version list below for details.
dotnet add package DataJuggler.Excelerate --version 1.3.3
NuGet\Install-Package DataJuggler.Excelerate -Version 1.3.3
<PackageReference Include="DataJuggler.Excelerate" Version="1.3.3" />
paket add DataJuggler.Excelerate --version 1.3.3
#r "nuget: DataJuggler.Excelerate, 1.3.3"
// Install DataJuggler.Excelerate as a Cake Addin #addin nuget:?package=DataJuggler.Excelerate&version=1.3.3 // Install DataJuggler.Excelerate as a Cake Tool #tool nuget:?package=DataJuggler.Excelerate&version=1.3.3
Still testing Save functionality.
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.8)
- 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 |
11.4.2021 (Take Two)
Version 1.3.3: My previous Save method had the return value in the wrong place.
Hopefully this fixes it. I am too lazy to add the project and propertly debug it.
11.4.2021
Version 1.3.2: While working on Save I realized I needed to return the row from the code generated Save method
so Excel can be updated. Save is still being tested, so use with caution.
11.2.2021 (Take Two)
Version 1.3.1: The previous version code generated the Save method incorrectly. This should fix it.
11.2.2021
Version 1.3.0: I now code generate a Save method, so the current Row.Column's ColumnValues are updated with the current value of this object.
11.1.2021
Version 1.2.8: I updated Worksheet.Columns is now set to first row.Columns when the Worksheet is loaded.
I added a NewRow method, that returns a new row with the columns set.
I updated AttemptToDetermineDataType to set ZipCode and PostalCode fields to a string, not an integer.
Code Generating a Save method is next I think.
10.31.2021 (Take Eight)
This time, DataJuggler.UlimateHelper was updated. The ParseBoolean method got an upgrade.
10.31.2021 (Take Seven)
Version 1.2.6: I updated ParseBoolean to use DataJuggler.UltimateHelper.BooleanHelper.ParseBoolean. We will see if this converts a 1 to a true and a zero to a false. I think it does after 11 years.
10.31.2021: (Take Six)
Version 1.2.5: I fixed Active being a boolean, and discovered the LoadMethod was trying to set bool columns to a string value.
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.