JW/EMIS.Utility/AsposeExcelModel.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Aspose.Cells;

namespace EMIS.Utility
{
    public enum HeaderAndFooterSection
    {
        Left = 0,
        Center = 1,
        Right = 2
    }

    public class HeaderAndFooterFormater
    {
        public HeaderAndFooterSection Section { get; set; }
        public Func<string, string> Formater { get; set; }
    }

    public class InsertColumnItem
    {
        public int ColumnIndex { get; set; }
        public int InsertCount { get; set; }
    }
    public class AsposeCellItem : CellItem
    {
        public Func<Workbook, Style> Style { get; set; }
    }

    public class AsposeListItem : ListItem
    {
        public AsposeListItem()
        {
            StyleList = new List<AsposeExcelCellStyle>();
            MergeList = new List<CellArea>();
            IsInsertRow = true;
        }

        public bool IsInsertRow { get; set; }
        public List<AsposeExcelCellStyle> StyleList { get; set; }
        public List<CellArea> MergeList { get; set; }
    }

    public class AsposePageItem : PageItem
    {
        public AsposePageItem()
            : base()
        {
            MergeList = new List<CellArea>();
            InsertColumnItemList = new List<InsertColumnItem>();
            HeaderFormaterList = new List<HeaderAndFooterFormater>();
            FooterFormaterList = new List<HeaderAndFooterFormater>();
        }

        public List<InsertColumnItem> InsertColumnItemList { get; set; }
        public List<CellArea> MergeList { get; set; }
        public List<HeaderAndFooterFormater> HeaderFormaterList { get; set; }
        public List<HeaderAndFooterFormater> FooterFormaterList { get; set; }
    }

    internal class AsposeExcelStyle
    {
        public int Row { get; set; }
        public int Col { get; set; }
        public Style Style { get; set; }
    }
}