CodedThought.Core.Data.ExcelSystem 8.0.0

CodedThought.Core.Data.ExcelSystem

A .NET Core Excel Read/Write Library

Installation

1. Reference the CodedThought.Core and CodedThought.Core.Configuration packages.
2. Reference the CodedThought.Core.Data.ExcelSystem package.

Usage

Set Up Data Aware Classes

Note: Please see the CodedThought.Core package README for more on using data aware classes.

// This example is a data aware class for a country object.
namespace Sample.Data {

    [ApiDataController("lookup")]
    [DataTable("COUNTRY", "", "dbo")]
    public class Country {

        #region Constructors

        public Country() {
        }

        #endregion Constructors

        #region Properties

        /// <summary>
        /// Gets or sets the name of the country.
        /// </summary>
        /// <value>
        /// The name of the country.
        /// </value>
        [DataColumn("CountryName", DbType.String, DataColumnOptions.PrimaryKey)]
        public string CountryName { get; set; }

        /// <summary>
        /// Gets or sets the region code.
        /// </summary>
        /// <value>
        /// The region code.
        /// </value>
        [DataColumn("RegionCode", DbType.String)]
        public string RegionCode { get; set; }

        /// <summary>
        /// Gets or sets the iso code.
        /// </summary>
        /// <value>
        /// The iso code.
        /// </value>
        [DataColumn("CountryCodeISO", DbType.String)]
        public string ISOCode { get; set; }

        /// <summary>
        /// Gets or sets the iso code3.
        /// </summary>
        /// <value>
        /// The iso code3.
        /// </value>
        [DataColumn("CountryCodeISO3", DbType.String)]
        public string ISOCode3 { get; set; }

        #endregion Properties
    }
}

Sample Code

This is a quick sample for creating an excel file based on the country data aware class above and returning it to an API content result

PropertyInfo[] ColumnNames = typeof(Country).GetProperties();
string fileName = $"ExcelOutput_{DateTime.Today:yyyyMMddHHmmss}.xlsx";
Stream output = ExcelOpenXmlWriter.CreateExcelDocumentAsStream(model.Countries, fileName);
FileContentResult fcr = new(_common.ConvertToByteArray(output), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet") {
    FileDownloadName = fileName
};