public class DocumentPrinter
{
  public void PrintDocument(string documentName)
  {
    var repository = new DocumentRepository();
    var formatter = new DocumentFormatter();         
    var printer = new Printer();              
    var document = repository                        
      .GetDocumentByName(documentName);               
    var formattedDocument = formatter.Format(document);    
    printer.Print(formattedDocument); 
  }
}

var documentPrinter = new DocumentPrinter();
documentPrinter.PrintDocument(@"c:\doc.doc");

public class DocumentPrinter
{
  private DocumentRepository _repository;
  private DocumentFormatter _formatter;       
  private Printer _printer;              
  public DocumentPrinter(             
    DocumentRepository repository,               
    DocumentFormatter formatter,      
    Printer printer)                  
  {                                   
    _repository = repository;         
    _formatter = formatter;           
    _printer = printer;               
  }
  public void PrintDocument(string documentName)
  {
    var document = _repository.GetDocumentByName(documentName);
    var formattedDocument = _formatter.Format(document);
    _printer.Print(formattedDocument);
  }
}

var repository = new DocumentRepository();
var formatter = new DocumentFormatter();
var printer = new Printer();
var documentPrinter = new DocumentPrinter(repository, formatter, printer);
documentPrinter.PrintDocument(@"c:\doc.doc");

public interface IDocumentRepository
{
  Document GetDocumentByName(string documentName);
}

public class DocumentPrinter
{
  private IDocumentRepository _repository;                        
  private IDocumentFormatter _formatter;                          
  private IPrinter _printer;                                      
  public DocumentPrinter(
    IDocumentRepository repository,
    IDocumentFormatter formatter,
    IPrinter printer)
  {
    _repository = repository;
    _formatter = formatter;
    _printer = printer;
  }
  public void PrintDocument(string documentName)
  {
    var document = _repository.GetDocumentByName(documentName);
    var formattedDocument = _formatter.Format(document);
    _printer.Print(formattedDocument);
  }
}

ObjectFactory.Configure(cfg =>
{
  cfg.For<IDocumentRepository>().Use<FilesystemDocumentRepository>();
  cfg.For<IDocumentFormatter>().Use<DocumentFormatter>();
  cfg.For<IPrinter>().Use<Printer>();
});

        /// <summary>
        /// Insert values from an object into a string pattern. To specify the object's property you have to use the '{propertyName}'.
        /// </summary>
        /// <remarks>
        /// This method is a replacement to String.Format, but it has two differences:
        /// <list type="simple">
        /// <item>It reverese the order you call the functionality, instead of writing String.Format(pattern, args) you write pattern.FillByObject(args). This makes the code look cleaner.</item>
        /// <item>You supply the pattern with an object and specify insertion points by property names.</item>
        /// </list>
        /// <example>
        /// <![CDATA[
        /// "First name:{firstName}, Sur name:{Surname}".FillByObject(new {firstName = "Sam", lastName="Naseri"});
        /// ]]>
        /// </example>
        /// </remarks>
        /// <seealso cref="Fill"/>
        /// <typeparam name="T">Type of bindingValue.</typeparam>
        /// <param name="bindingPattern">The pattern to fill.</param>
        /// <param name="bindingValue">The object providing values to fill in the pattern.</param>
        /// <returns>The pattern filled with values.</returns>
        public static string FillByObject<T>(this string bindingPattern, T bindingValue)
        {
            var properties = GetProperties(typeof(T)).ToList();
            var values = properties.Select(property => property.GetValue(bindingValue, new object[] { })).ToList();
            var result = bindingPattern;
            for (int index = 0; index < properties.Count; index++)
            {
                var property = properties[index];
                var propPattern = "{" + property.Name + "}";
                var old = result;
                result = result.Replace(propPattern, values[index] != null ? values[index].ToString() : "");
            }
            return result;
        }

private static IEnumerable<PropertyInfo> GetProperties(Type t)
{
    return t.GetProperties(BindingFlags.Public | BindingFlags.Instance);
}

/// <summary>
/// A simple replacement for String.Format which only makes the codes look nicer.
/// </summary>
/// <param name="pattern">The source string that you want to replace insertion points on it.</param>
/// <param name="args">Values to be replaced in the pattern.</param>
/// <returns></returns>
public static string Fill(this string pattern, params object[] args)
{
    return string.Format(pattern, args);
}

using System.Data;
using System.IO;
using OfficeOpenXml;
using OfficeOpenXml.Drawing.Chart;
using OfficeOpenXml.Style;
using OfficeOpenXml.Table;

namespace EPPlusTest
{
  class Program
  {
      static void Main(string[] args)
      {
          var newFile = new FileInfo("Test.xlsx");
          if (newFile.Exists)
          {
              newFile.Delete();
          }

          //ایجاد یک سری اطلاعات دلخواه
          var table = createDt();

          using (var package = new ExcelPackage(newFile))
          {
              // اضافه کردن یک ورک شیت جدید
              ExcelWorksheet worksheet = package.Workbook.Worksheets.Add("مخارج");             

              //اضافه کردن یک جدول جدید از دیتاتیبل دریافتی
              worksheet.Cells["A1"].LoadFromDataTable(table, true, TableStyles.Dark9);

              //نمایش جمع ستون هزینه‌های ماه‌ها
              var tbl = worksheet.Tables[0];
              //زیر آخرین ردیف یک سطر اضافه می‌کند
              tbl.ShowTotal = true;
              //فرمول نحوه‌ی محاسبه جمع ستون انتساب داده می‌شود
              tbl.Columns[1].TotalsRowFunction = RowFunctions.Sum;

              //تعیین عرض ستون‌های جدول
              worksheet.Column(1).Width = 14;
              worksheet.Column(2).Width = 12;

              //تنظیم متن هدر
              worksheet.HeaderFooter.oddHeader.CenteredText = "مثالی از نحوه‌ی استفاده از ایی پی پلاس";              

              //می‌خواهیم سرستون‌ها در وسط ستون قرار گیرند
              worksheet.Cells["A1"].Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;
              worksheet.Cells["B1"].Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;

              //افزودن یک نمودار جدید به شیت جاری
              var chart = worksheet.Drawings.AddChart("chart1", eChartType.Pie3D);
              chart.Title.Text = "نمودار هزینه‌های سال";
              chart.SetPosition(Row: 2, RowOffsetPixels: 5, Column: 3, ColumnOffsetPixels: 5);
              chart.SetSize(PixelWidth: 320, PixelHeight: 360);
              chart.Series.Add("B2:B13", "A2:A13");
              chart.Style = eChartStyle.Style26;

              //تنظیم یک سری خواص فایل نهایی
              package.Workbook.Properties.Title = "مثالی از ایی پی پلاس";
              package.Workbook.Properties.Author = "وحید";
              package.Workbook.Properties.Subject = "ایجاد فایل اکسل بدون نرم افزار اکسل";

              //تنظیم نحوه‌ی نمایش فایل زمانیکه در نرم افزار اکسل گشوده می‌شود
              worksheet.View.PageLayoutView = true;
              worksheet.View.RightToLeft = true;

              // ذخیر سازی کلیه موارد اعمالی در فایل
              package.Save();
          }
      }

      private static DataTable createDt()
      {
          var table = new DataTable("مخارج");
          table.Columns.Add("ماه", typeof(string));
          table.Columns.Add("هزینه", typeof(decimal));

          table.Rows.Add("فروردین", 100);
          table.Rows.Add("اردیبهشت", 250);
          table.Rows.Add("خرداد", 80);
          table.Rows.Add("تیر", 300);
          table.Rows.Add("مرداد", 200);
          table.Rows.Add("شهریور", 150);
          table.Rows.Add("مهر", 250);
          table.Rows.Add("آبان", 200);
          table.Rows.Add("آذر", 400);
          table.Rows.Add("دی", 100);
          table.Rows.Add("بهمن", 130);
          table.Rows.Add("اسفند", 80);
          return table;
      }
  }
}