ExcelFromList 1.5.1

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