Exemple #1
0
 ///// <summary>
 ///// Returns a closed xml workbook
 ///// </summary>
 internal ExcelWorkbook(IArrayHelper arrayHelper, IClosedXMLHelper closedXmlHelper)
 {
     _arrayHelper       = arrayHelper;
     _closedXMLHelper   = closedXmlHelper;
     Package            = ExcelPackage.ClosedXml;
     _closedXmlWorkbook = new XLWorkbook();
 }
Exemple #2
0
        internal ExcelWorkbook(ExcelPackage excelPackage, string filePath, IArrayHelper arrayHelper,
                               IClosedXMLHelper closedXmlHelper)
        {
            Package          = excelPackage;
            _arrayHelper     = arrayHelper;
            _closedXMLHelper = closedXmlHelper;

            switch (excelPackage)
            {
            case ExcelPackage.ClosedXml:
                _closedXmlWorkbook = new XLWorkbook(filePath);
                break;

            default:
                _excelApplication = (Interop.Application)Marshal.GetActiveObject(_excelApplicationName);
                string workbookName = GetWorkbookName(filePath);
                _interopWorkbook = _excelApplication.Workbooks[workbookName];
                break;
            }
        }
Exemple #3
0
 public ExcelWorkbookFactory()
 {
     _arrayHelper     = new ArrayHelper();
     _closedXmlHelper = new ClosedXMLHelper();
 }