DatasToExcel 1.0.0
There is a newer version of this package available.
See the version list below for details.
See the version list below for details.
dotnet add package DatasToExcel --version 1.0.0
NuGet\Install-Package DatasToExcel -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="DatasToExcel" Version="1.0.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add DatasToExcel --version 1.0.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: DatasToExcel, 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 DatasToExcel as a Cake Addin
#addin nuget:?package=DatasToExcel&version=1.0.0
// Install DatasToExcel as a Cake Tool
#tool nuget:?package=DatasToExcel&version=1.0.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
DatasToExcel
A 2D array to Excel file converter, support header first row and fixed headers. It uses .Net Core 3.0 as framework and only depends on the Open Xml SDK.
Dependencies
.Net Core >= 3.0
DocumentFormat.OpenXml = 2.10.1
Main Features
- 2D array to Excel
- Header first row (optional)
- Fixed first row (optional)
How to Use
Create a 2D array first.
string[,] datas = new string[,]
{
{ "Name", "Country", "Age", "Career" },
{ "Helen", "U.S.", "21", "Police" },
{ "Jucia", "Canada", "34", "Dancer" },
{ "Erik", "Canada", "13", "Student" },
{ "Bob", "British", "26", "Business person" },
{ "Nancy", "Russia", "64", "Fisherman" },
};
And convert it to Excel and save to a fixed path.
datas.GenerateExcel(filename); //Do not header first row
datas.GenerateExcel(filename, true); //Header first row
Or save it to a memory stream.
//Option 1
MemoryStream ms = datas.GenerateExcel(); //Do not header first row
MemoryStream ms = datas.GenerateExcel(true); //Header first row
//Option 2
using (MemoryStream ms = new MemoryStream())
{
datas.GenerateExcel(ms); //Do not header first row
datas.GenerateExcel(ms, true); //Header first row
}
License
This project is under the MIT License.
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net5.0 was computed. 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. |
.NET Core | netcoreapp3.0 is compatible. netcoreapp3.1 was computed. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
.NETCoreApp 3.0
- DocumentFormat.OpenXml (>= 2.11.3)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.