Excel.Labs

This tool provides a C# based solution to create Excel files Simple and Fast. This package supports Android, iOS, Linux, macOS and Windows.


Keywords
Excel, Office, xls, xlsx, IO, C#, OpenXml, Dataset, .NETStandard, csharp, github-page, netstandard20, nuget-package, unit-test
License
MIT
Install
Install-Package Excel.Labs -Version 2.0.0

Documentation

Source Badges
Sponsorship Sponsorship
Workflows Workflow-Build-and-Test
Stats Version Downloads
License License: MIT
Github Activity GitHub commit activity GitHub contributors GitHub last commit GitHub search hit counter GitHub code size in bytes GitHub repo size
Languages GitHub top language
Issue Tracking GitHub issues GitHub closed issues GitHub closed pull requests GitHub pull requests

Give a Star 🌟

If you want to support ExcelLabs then you may give a star or be one of the sponsors.


Welcome to Excel Labs

ExcelLabs is an Excel Helper library written in C#.

Features

This tool provides a C# based solution to create Excel files without complex queries. This package supports Android, iOS, Linux, macOS and Windows.

Installation

NuGet Package Manager

PM> Install-Package Excel.Labs

.NET CLI

> dotnet add package Excel.Labs

Definition

Model

public class Cellx
{
   public int RowIndex { get; set; }
   public string ColumnName { get; set; }
   public string Value { get; set; }
}

Usage

1. Create a Cell List
2. Add Some Data
3. Call SaveFile Function
string title = "Excel Labs NuGet";
string sheetName = "Simple and Fast";
string path = AppDomain.CurrentDomain.BaseDirectory;

// 1. create a cell list
List<Cellx> cells = new List<Cellx>();

// 2. values as an array
List<string> languages = new List<string>() {
    "Java", // A
    "C#", // B
    "Javascript", // C
    "Swift", // D
    "Php", // E
    "Python", // F
    "Go", // G
    "Swift", // H
    "", // I
    "", // J
    "", // K
    "Objective-C", // L
    "C++", // M
    "F#" // N
    };
    
foreach (string lang in languages)
{
    // no column name for ordered columns
    cells.Add(new Cellx(1, lang));
}

// 3. single value with column name
cells.Add(new Cellx(2, "Fortran", "A"));
cells.Add(new Cellx(2, "Cobol", "D"));
cells.Add(new Cellx(2, "Pascal", "I"));

// 4. single value without column name
cells.Add(new Cellx(3, "Visual Studio"));
cells.Add(new Cellx(3, "Webstorm"));
cells.Add(new Cellx(3, "Xcode"));
cells.Add(new Cellx(3, "Notepad"));

// call save function
ExcelLabs.SaveFile(title, path, sheetName, cells);

Screenshot

labs

Support or Contact

Please visit https://doxalabs.co.uk

License

Excel Labs is released under the MIT license.