ExcelFromList 1.6.0

ExcelFromList

Straightforward and easy way to create stylized excel workbooks from lists. Add an image, title, subtitles and overal cell styles/formats.

You can run these same examples in the Testing project.

With default styles (no style object provided)

var wb = new ExcelWorkBook();
wb.AddSheet("Shelf Life", shelfLifeData);
wb.SaveAs(outputFileName);

A style object has been provided for the rest of the examples

With title, subtitles, backdrop color and data background color

var wb = new ExcelWorkBook();
var style = new ExcelStyleConfig
{
      Title = "Product Shelf Life List",
      Subtitles = new string[]
      {
            "As of 2/1/06",
            "Compiled by the Food Bank",
            "From National Manufactures"
      },
      BackdropColor = Color.Lavender,
      DataBackgroundColor = Color.LightGoldenrodYellow
};

wb.AddSheet("Shelf Life", shelfLifeData, style);
wb.SaveAs(outputFileName);

With title, subtitles and image from Base64

var wb = new ExcelWorkBook();
var style = new ExcelStyleConfig
{
      Title = "Product Shelf Life List",
      Subtitles = new string[]
      {
            "As of 2/1/06",
            "Compiled by the Food Bank",
            "From National Manufactures"
      },
      TitleImage = new Picture()
      {
            FromBase64 = "iVBORw..."
      }
};

wb.AddSheet("Shelf Life", shelfLifeData, style);
wb.SaveAs(outputFileName);

With title, subtitles, image from file (sheetOneStyle) and url (sheetTwoStyle), two sheets and cell stylings

var wb = new ExcelWorkBook();
var sheetOneStyle = new ExcelStyleConfig
{
      Title = "Product Shelf Life List",
      Subtitles = new string[]
      {
            "As of 2/1/06",
            "Compiled by the Food Bank",
            "From National Manufactures"
      },
      TitleImage = new Picture()
      {
            FromFile = @"x:\titleImage.jpg"
      }
};
var sheetTwoStyle = new ExcelStyleConfig
{
      Title = "Food Nutrient Information",
      Subtitles = new string[]
      {
            "List of EDNP products",
            "Audited by category"
      },
      TitleImage = new Picture()
      {
            FromUrl = @"http://www.images.com/titleImage.jpg"
      },
      ShowGridLines = false,
      DataBorderAround = true,
      DataBorder = true,
      DataBorderColor = Color.CadetBlue,
      HeaderBackgroundColor = Color.Yellow,
      HeaderFontColor = Color.Black
};

wb.AddSheet("Shelf Life", shelfLifeData, sheetOneStyle);
wb.AddSheet("Food Nutrients", foodInfoData, sheetTwoStyle);
wb.SaveAs(outputFileName);

With title, subtitles, image from Base64, skipping two columns and cell stylings

var wb = new ExcelWorkBook();
var style = new ExcelStyleConfig
{
      Title = "Food Nutrient Information",
      Subtitles = new string[]
      {
            "List of EDNP products",
            "Audited by category"
      },
      TitleImage = new Picture()
      {
            FromBase64 = "iVBORw..."
      },
      ShowGridLines = false,
      DataBorderAround = true,
      DataBorder = true,
      DataBorderColor = Color.CadetBlue,
      HeaderBackgroundColor = Color.Yellow,
      HeaderFontColor = Color.Black,
      ExcludedColumnIndexes = new int[]
      {
            2, 4
      }
};

wb.AddSheet("Food Nutrients", shelfLifeData, style);
wb.SaveAs(outputFileName);

Documentation

ExcelStyleConfig class

Sheet configs

ShowHeaders: Enable to show headers (taken from the property name), defaults to true

ShowGridLines: Enable to show grid lines, defaults to true

AutoFitColumns: Enable to match the width of the column to the data length, defaults to true

FreezePanes: Enable to freeze the first row, defaults to true

PaddingColumns: Gets or sets the number of columns to insert before column A, defaults to 0

PaddingRows: Gets or sets the number of rows to insert before row 1, defaults to 0

ExcludedColumnIndexes: Gets or sets which columns to exclude by index, range must be between 1 and the total number of columns, defaults to new int[0]

UsePropDisplayName: Enable to use the propery DisplayName attribute value, if available, for the column name, defaults to true

BackdropColor: Gets or set the backdrop color of the entire sheet, defaults to null

Title configs

Title: Gets or sets the title of the sheet, defaults to null

Subtitles: Gets or sets the subtitles of the sheet, defaults to new string[0]

TitleImage: Gets or sets an image to be placed on the sheet, defaults to new Picture()

******FromBase64: Gets or sets image from Base64, defaults to null

******FromFile: Gets or sets image from file, defaults to null

******FromUrl: Gets or sets image from url, defaults to null

******HasValue: Indicates if at least one image source has value, defaults to false

******IsValid: Indicates if value is valid, no source or more than one source (false), only one source (true), defaults to false

Data type formatting

DateFormat: Gets or sets custom Excel format string, defaults to m/d/yyyy

DecimalFormat: Gets or sets custom Excel format string, defaults to #,##0.00_);[Red]-#,##0.00

DoubleFormat: Gets or sets custom Excel format string, defaults to #,##0.00_);[Red]-#,##0.00

IntFormat: Gets or sets custom Excel format string, defaults to #,##0_);[Red]-#,##0

• Uses Excel type data formatting

Data cell configs

DataFontColor: Gets or sets data cell font color, defaults to null

DataBackgroundColor: Gets or sets data cell background color, defaults to null

DataBorder: Enable to draw a border around each data cell, defaults to false

DataBorderAround: Enable to draw a border around the data range, defaults to false

DataBorderColor: Gets or sets the border color around each data cell, defaults to Color.Black

DataBorderAroundColor: Gets or sets the border color around the data range, defaults to Color.Black

DataBorderStyle: Gets or sets the border style around each data cell, defaults to ExcelBorderStyle.Thin

DataBorderAroundStyle: Gets or sets the border style around the data range, defaults to ExcelBorderStyle.Thin

Header cell configs

HeaderFontColor: Gets or sets the header font color, defaults to Color.LightGray

HeaderBackgroundColor: Gets or sets the header background color, defaults to Color.DarkSlateGray

HeaderBorder: Enable to draw a border around each header cell, defaults to false

HeaderBorderAround: Enable to draw a border around the header range, defaults to false

HeaderBorderColor: Gets or sets the border color around each header cell, defaults to Color.Black

HeaderBorderAroundColor: Gets or sets the border color around the header range, defaults to Color.Black

HeaderBorderStyle: Gets or sets the border style around each header cell, defaults to ExcelBorderStyle.Thin

HeaderBorderAroundStyle: Gets or sets the border style around the header range, defaults to ExcelBorderStyle.Thin

ExcelWorkBook class

FullFileName: Gets or sets the full file path for the generated Excel file

GetBytesArray(): Returns the ExcelWorkBook bytes array

AddSheet(string sheetName): Adds a sheet to the worksheet, will apply style config if provided

RemoveSheet(string sheetName): Removes a sheet from the worksheet

ClearWorkSheet(): Removes all sheets from worksheet

SheetExists(string sheetName): Checks if a specific sheet exists

Save(): Saves the workbook to an Excel (FullFileName property must be set)

SaveAs(): Saves the workbook to an Excel file

Open(): Opens saved Excel file with OS default program