SuperSimpleExcel 1.0.1
dotnet add package SuperSimpleExcel --version 1.0.1
NuGet\Install-Package SuperSimpleExcel -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="SuperSimpleExcel" Version="1.0.1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="SuperSimpleExcel" Version="1.0.1" />
<PackageReference Include="SuperSimpleExcel" />
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.
paket add SuperSimpleExcel --version 1.0.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: SuperSimpleExcel, 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.
#:package SuperSimpleExcel@1.0.1
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.
#addin nuget:?package=SuperSimpleExcel&version=1.0.1
#tool nuget:?package=SuperSimpleExcel&version=1.0.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
Super Simple Excel
Super Simple Excel is a lightweight .NET library for generating and reading Excel files with minimal settings, designed to keep things simple and straightforward. The library is based on OpenXML and supports .NET 8.
Features
- Generate Excel files easily.
- Read Excel files effortlessly.
- Minimal configuration needed.
- Built on OpenXML.
Installation
You can install Super Simple Excel via NuGet Package Manager:
dotnet add package SuperSimpleExcel
Usage
Generating an Excel File
Here's a simple example of how to generate an Excel file:
using (var stream = await SimpleExcelFactory.CreateInstance().ExportExcelAsync(new SimpleExcel.Models.ExportTemplateSetting<StudentModel>
{
Data = students,
Autofit = true,
SheetName = "Hello",
HeaderStyle = new SimpleExcel.Models.StyleSettings { FontSize = 12, TextBold = true },
FormatCellQueries = new Dictionary<string, SimpleExcel.Models.CellTemplateQuery<StudentModel>>
{
{
nameof(StudentModel.FirstName),
new SimpleExcel.Models.CellTemplateQuery<StudentModel> {
Query = student => student.YoB.HasValue && student.YoB.Value < 2000,
Style = new SimpleExcel.Models.StyleSettings {
ForeColorRgbHex = "FF0000"
}
} }
}
}))
{
using (FileStream fileStream = new FileStream("output.xlsx", FileMode.Create, FileAccess.Write))
{
stream.Seek(0, SeekOrigin.Begin);
await stream.CopyToAsync(fileStream);
}
}
License
This project is licensed under the MIT License - see the LICENSE file for details.
Contributing
Contributions are welcome! Please feel free to submit a pull request or open an issue.
Acknowledgments
This library is built on top of the OpenXML SDK.
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net8.0 is compatible. 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. net9.0 was computed. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. net10.0 was computed. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
net8.0
- DocumentFormat.OpenXml (>= 3.0.2)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.