コード例 #1
0
        static void Main(string[] args)
        {
            // UtilityClassで疎結合をやってみるテスト
            utilityProvider = ServiceLocatorProvider.GetInstance.utilityCurrent.Resolve <IUtilityClassProvider>();
            utilityProvider.ITestMethod();

            // ファイルのフルパスの取得
            List <string> fileFullPath = new List <string>();

            ioFileNamesProvider = ServiceLocatorProvider.GetInstance.ioFileNameCurrent.Resolve <IIOFileNamesProvider>();
            fileFullPath.AddRange(ioFileNamesProvider.GetSpecifiedExtensionFileFullPath("xlsx"));
            Console.WriteLine(ioFileNamesProvider.GetSpecifiedExtensionFileNameToList(fileFullPath)[0]);

            // Excelファイルの最大シート数を取得
            ioExcelFilesProvider = ServiceLocatorProvider.GetInstance.ioExcelFileCurrent.Resolve <IIOExcelFilesProvider>();
            int maxSheetNumber = ioExcelFilesProvider.GetExcelSheetNumberMax(fileFullPath[0]);
            // Excelファイルのシート数を連番で取得
            List <int> serialNumber = new List <int>(ioExcelFilesProvider.GetExcelSheetNumberList(fileFullPath[0]));

            // List<XLWorkbook> workBookList = new List<XLWorkbook>();
            // List<string[][]> XLDataList = new List<string[][]>();
            // for(int xlFileCount = 1; xlFileCount <= fileFullPath.Count; ++xlFileCount)
            // {
            //     XLDataList.Add(ioe.ExtractionExcelData(xlFileCount, ioe.GetExcelObject(fileFullPath[xlFileCount -1])));
            // }
        }
コード例 #2
0
 public void GetInstance()
 {
     ioExcelFilesProvider   = ServiceLocatorProvider.GetInstance.ioExcelFileCurrent.Resolve <IIOExcelFilesProvider>();
     readExcelFilesProvider = ServiceLocatorProvider.GetInstance.ReadExcelCurrent.Resolve <IReadExcelFiles>();
 }