ExcelFromList 1.1.1

ExcelFromList

Straightforward and easy way to create stylized excel workbooks from lists. Add an image, title, subtitles and overal cell styles/formats. This uses the EPPlus engine, you can check them out at: https://github.com/EPPlusSoftware/EPPlus

In the below examples outputFileName is a string identifying a full path file name and shelfLifeData is a list of ShelfLife type objects.

You can run these same examples in the Testing project.

Default styles (no style object provided)

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

For the rest of the examples a style object has been provided

With title and subtitles

  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"
      }
  };

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

With title, subtitles and image

  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..." // string trucated for brevity of example
      }
  };

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

With title, subtitles, image, 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,
      BorderAround = true,
      Border = true,
      BorderColor = Color.CadetBlue,
      HeaderBackgroundColor = Color.Yellow,
      HeaderFontColor = Color.Black
  };

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

Documentation

Available in the 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

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 <i>* Uses Excel type data formatting</i>

Data cell configs

FontColor: Gets or sets data cell font color, defaults to null BackgroundColor: Gets or sets data cell background color, defaults to null Border: Enable to draw a border around each data cell, defaults to false BorderAround: Enable to draw a border around the data range, defaults to false BorderColor: Gets or sets the border color around each data cell, defaults to Color.Black BorderAroundColor: Gets or sets the border color around the data range, defaults to Color.Black BorderStyle: Gets or sets the border style around each data cell, defaults to ExcelBorderStyle.Thin BorderAroundStyle: 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

Available in the ExcelWorkBook class

Methods

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 SaveAs(): Saves the workbook to an Excel file Open(): Opens saved Excel file with OS default program

For new features you can contact me at raulmarquezi@gmail.com