ToDataTable.Helper
1.0.0
dotnet add package ToDataTable.Helper --version 1.0.0
NuGet\Install-Package ToDataTable.Helper -Version 1.0.0
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="ToDataTable.Helper" Version="1.0.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add ToDataTable.Helper --version 1.0.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: ToDataTable.Helper, 1.0.0"
#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 ToDataTable.Helper as a Cake Addin
#addin nuget:?package=ToDataTable.Helper&version=1.0.0
// Install ToDataTable.Helper as a Cake Tool
#tool nuget:?package=ToDataTable.Helper&version=1.0.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
ToDataTableHelper
¿Qué es ToDataTableHelper?
Es una libreria desarrollada en C# (C-Sharp) .Net Core 6, la cual nos permite generar un DataTable a partir de un resultado Json string o respuesta desde un Entity a una tabla de base de datos. <p>Ejemplo de Json String: <br /> <b>var jsonString = new { name = 'Armando', lastname = 'Montenegro', address = 'Panama' }</b></p>
Modo de uso
- Primero instalamos el Nuget de ToDataTable.Helper en nuestro proyecto
- Realizamos el respectivo import
- Proseguimos tal y como se muestra en la siguiente codificación →
ToDataTableHelper converter = new ToDataTableHelper();
DataTable dt = ToDataTableHelper.ToDataTable(results);
var stream = new MemoryStream();
using (var package = new ExcelPackage(stream))
{
var ws = package.Workbook.Worksheets.Add("Orders Details");
ws.Cells.LoadFromDataTable(dt, true);
package.Save();
}
stream.Position = 0;
string excelName = $"Report_{DateTime.Now.Year}-{DateTime.Now.Month}_{country}_{DateTime.Now.Millisecond}.xlsx";
var data = stream.ToArray();
En ese fragmento de código utilizamos un Nuget de generación de documentos Excel a partir de un DataTable el cual es generado por nuestro Helper.
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net6.0 is compatible. 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. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
net6.0
- Newtonsoft.Json (>= 13.0.1)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last updated |
---|---|---|
1.0.0 | 185 | 6/16/2022 |