DataJuggler.Excelerate
1.3.2
See the version list below for details.
dotnet add package DataJuggler.Excelerate --version 1.3.2
NuGet\Install-Package DataJuggler.Excelerate -Version 1.3.2
<PackageReference Include="DataJuggler.Excelerate" Version="1.3.2" />
paket add DataJuggler.Excelerate --version 1.3.2
#r "nuget: DataJuggler.Excelerate, 1.3.2"
// Install DataJuggler.Excelerate as a Cake Addin
#addin nuget:?package=DataJuggler.Excelerate&version=1.3.2
// Install DataJuggler.Excelerate as a Cake Tool
#tool nuget:?package=DataJuggler.Excelerate&version=1.3.2
Still testing Save.
| 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, ValidationComponent 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.4 | 922 | 12/29/2023 |
| 8.0.3 | 371 | 12/29/2023 |
| 8.0.2 | 1,239 | 12/26/2023 |
| 8.0.1 | 512 | 11/17/2023 |
| 8.0.0 | 1,300 | 11/14/2023 |
| 7.4.6 | 1,149 | 8/28/2023 |
| 7.4.5 | 1,254 | 8/26/2023 |
| 7.4.4 | 821 | 8/13/2023 |
| 7.4.3 | 420 | 8/13/2023 |
| 7.4.2 | 607 | 7/24/2023 |
| 7.4.1 | 408 | 7/24/2023 |
| 7.4.0 | 467 | 7/23/2023 |
| 7.3.21 | 602 | 7/22/2023 |
| 7.3.20 | 613 | 7/22/2023 |
| 7.3.1 | 432 | 7/21/2023 |
| 7.3.0 | 446 | 7/16/2023 |
| 7.2.12 | 2,141 | 4/10/2023 |
| 7.2.11 | 490 | 4/10/2023 |
| 7.2.10 | 496 | 4/5/2023 |
| 7.2.9 | 554 | 4/2/2023 |
| 7.2.8 | 503 | 4/2/2023 |
| 7.2.7 | 481 | 4/1/2023 |
| 7.2.6 | 490 | 3/28/2023 |
| 7.2.5 | 501 | 3/28/2023 |
| 7.2.4 | 485 | 3/28/2023 |
| 7.2.3 | 495 | 3/28/2023 |
| 7.2.2 | 471 | 3/28/2023 |
| 7.2.1 | 475 | 3/28/2023 |
| 7.2.0 | 491 | 3/28/2023 |
| 7.1.12 | 501 | 3/28/2023 |
| 7.1.11 | 487 | 3/28/2023 |
| 7.1.10 | 503 | 3/28/2023 |
| 7.1.9 | 8,315 | 12/25/2022 |
| 7.1.8 | 5,861 | 12/16/2022 |
| 7.1.7 | 607 | 12/16/2022 |
| 7.1.6 | 902 | 12/11/2022 |
| 7.1.5 | 796 | 12/11/2022 |
| 7.1.4 | 2,606 | 12/4/2022 |
| 7.1.3 | 770 | 12/4/2022 |
| 7.1.2 | 601 | 12/4/2022 |
| 7.1.1 | 797 | 12/4/2022 |
| 7.1.0 | 4,286 | 11/15/2022 |
| 7.0.16 | 1,128 | 11/11/2022 |
| 7.0.15 | 648 | 11/11/2022 |
| 7.0.14 | 644 | 11/11/2022 |
| 7.0.12 | 625 | 11/11/2022 |
| 7.0.11 | 636 | 11/11/2022 |
| 7.0.10 | 603 | 11/10/2022 |
| 7.0.9 | 825 | 11/10/2022 |
| 7.0.8 | 625 | 11/10/2022 |
| 7.0.7 | 611 | 11/10/2022 |
| 7.0.6 | 617 | 11/10/2022 |
| 7.0.5 | 607 | 11/9/2022 |
| 7.0.4 | 824 | 11/9/2022 |
| 7.0.4-rc1 | 417 | 11/8/2022 |
| 7.0.3-rc1 | 453 | 11/7/2022 |
| 7.0.2-rc1 | 501 | 11/7/2022 |
| 7.0.1-rc1 | 409 | 11/7/2022 |
| 7.0.0-rc1 | 406 | 10/31/2022 |
| 6.0.3 | 869 | 9/28/2022 |
| 6.0.2 | 710 | 9/28/2022 |
| 6.0.1 | 968 | 4/1/2022 |
| 6.0.0 | 957 | 1/23/2022 |
| 1.7.3 | 712 | 11/30/2021 |
| 1.7.2 | 595 | 11/30/2021 |
| 1.7.1 | 596 | 11/30/2021 |
| 1.7.0 | 616 | 11/30/2021 |
| 1.6.0 | 577 | 11/29/2021 |
| 1.5.0 | 686 | 11/10/2021 |
| 1.4.4 | 703 | 11/8/2021 |
| 1.4.3 | 616 | 11/8/2021 |
| 1.4.2 | 642 | 11/8/2021 |
| 1.4.1 | 626 | 11/8/2021 |
| 1.4.0 | 628 | 11/8/2021 |
| 1.3.12 | 595 | 11/7/2021 |
| 1.3.10 | 632 | 11/7/2021 |
| 1.3.9 | 683 | 11/7/2021 |
| 1.3.8 | 712 | 11/7/2021 |
| 1.3.7 | 708 | 11/7/2021 |
| 1.3.6 | 762 | 11/7/2021 |
| 1.3.5 | 706 | 11/5/2021 |
| 1.3.4 | 706 | 11/5/2021 |
| 1.3.3 | 686 | 11/5/2021 |
| 1.3.2 | 717 | 11/5/2021 |
| 1.3.1 | 629 | 11/2/2021 |
| 1.3.0 | 612 | 11/2/2021 |
| 1.2.8 | 660 | 11/1/2021 |
| 1.2.7 | 618 | 10/31/2021 |
| 1.2.6 | 620 | 10/31/2021 |
| 1.2.5 | 698 | 10/31/2021 |
| 1.2.4 | 721 | 10/31/2021 |
| 1.2.3 | 693 | 10/31/2021 |
| 1.2.2 | 663 | 10/31/2021 |
| 1.2.1 | 661 | 10/31/2021 |
| 1.2.0 | 719 | 10/31/2021 |
| 1.1.9 | 612 | 10/16/2021 |
| 1.1.8 | 692 | 10/16/2021 |
| 1.1.7 | 649 | 10/14/2021 |
| 1.1.6 | 625 | 10/13/2021 |
| 1.1.5 | 659 | 9/21/2021 |
| 1.1.4 | 653 | 9/20/2021 |
| 1.1.3 | 641 | 9/20/2021 |
| 1.1.2 | 662 | 9/17/2021 |
| 1.1.1 | 640 | 9/17/2021 |
| 1.0.3 | 578 | 9/15/2021 |
| 1.0.2 | 604 | 9/14/2021 |
| 1.0.1 | 614 | 9/14/2021 |
| 1.0.0 | 621 | 9/14/2021 |
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.