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]))); // } }
public void GetInstance() { ioExcelFilesProvider = ServiceLocatorProvider.GetInstance.ioExcelFileCurrent.Resolve <IIOExcelFilesProvider>(); readExcelFilesProvider = ServiceLocatorProvider.GetInstance.ReadExcelCurrent.Resolve <IReadExcelFiles>(); }