DatasToExcel 1.0.1
dotnet add package DatasToExcel --version 1.0.1
NuGet\Install-Package DatasToExcel -Version 1.0.1
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.1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add DatasToExcel --version 1.0.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: DatasToExcel, 1.0.1"
#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.1
// Install DatasToExcel as a Cake Tool
#tool nuget:?package=DatasToExcel&version=1.0.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
DatasToExcel
A 2D array to Excel file converter. Generate Microsoft Excel file from a 2D array in C#. Support making the first row headers and custom worksheet name. .Net Core 3.0 framework and depends on the Open Xml SDK.
Dependencies
.Net Core >= 3.0
DocumentFormat.OpenXml = 2.10.1
Main Features
- 2D array to Excel
- Making the first row headers
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" },
};
Convert it to a Excel file and save to a local file.
datas.GenerateExcel(filename); //First row as non-headers
datas.GenerateExcel(filename, true); //First row as headers
Or save it to a MemoryStream.
//Option 1
MemoryStream ms = datas.GenerateExcel(); //First row as non-headers
MemoryStream ms = datas.GenerateExcel(true); //First row as headers
//Option 2
using (MemoryStream ms = new MemoryStream())
{
datas.GenerateExcel(ms); //First row as non-headers
datas.GenerateExcel(ms, true); //First row as headers
}
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.