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
Office, Excel, xls, IO, Dataset, xlsx, C#, OpenXml, .NETStandard, csharp, github-page, interop, netstandard20, nuget-package, unit-test
License
MIT
Install
Install-Package Excel.Labs -Version 2.0.0

Documentation

GitHub Actions status Version Downloads

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 LabsCell
{
   public int RowIndex { get; set; }
   public int ColumnIndex { get; set; }
   public dynamic Value { get; set; }
}

Usage

1. Init ExcelLabs
2. Create a Cell List
3. Add Some Data
4. Call Save Function
// excel filename
string title = "Excel Labs NuGet";
// where do you want to save?
// you can define subfolder too
string path = AppDomain.CurrentDomain.BaseDirectory + @"Files\";

// init
ExcelLabs excel = new ExcelLabs(title, path, Extension.Xls);

// create a cell list
List<LabsCell> cells = new List<LabsCell>();

// define row and column indexes then add your data
cells.Add(new LabsCell(10, 20, "Your Value"));

// add some data to cell list
for (int i = 1; i < 20; i++)
{
   cells.Add(new LabsCell(i, i, i));
}

// call save function with the cell list
excel.Save(cells);

Support or Contact

Please visit http://doxalabs.co.uk

License

Excel Labs is released under the MIT license.