Excel.Labs 2.2.0

Source	Badges
Sponsorship
Workflows
Stats
License
Github Activity
Languages
Issue Tracking

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

Support or Contact

Please visit https://doxalabs.co.uk

License

Excel Labs is released under the MIT license.