def click_get_file(self): dialog = GetFile(self.model.def_dir, self.model.ftype) files = dialog.get_files() if files == False: return False self.model.filepath = files for x in self.model.filepath: print(x)
def __init__(self): self.__def_dir = "DeskTop" self.__ftype = [("Excel2007ファイル", "*.xlsx")] self.picker = GetFile(self.__def_dir, self.__ftype) self.file_list = self.get_file_list() self.baseapp = ExcelApp() self.app = self.baseapp.app self.wb = ExcelWorkBook() self.item_shelf = ItemShelf() self.ws = None self.dto = None
class FilePicker(): def __init__(self): self.__def_dir = "DeskTop" self.__ftype = [("Excel2003ファイル", "*.xlsx")] self.picker = GetFile(self.__def_dir, self.__ftype) self.file_list = self.picker.get_files() def get_file_list(self): if self.file_list is False: quit() else: return self.file_list
class Excels(): def __init__(self): self.__def_dir = "DeskTop" self.__ftype = [("Excel2007ファイル", "*.xlsx")] self.picker = GetFile(self.__def_dir, self.__ftype) self.file_list = self.get_file_list() self.baseapp = ExcelApp() self.app = self.baseapp.app self.wb = ExcelWorkBook() self.item_shelf = ItemShelf() self.ws = None self.dto = None def get_file_list(self): result = self.picker.get_files() if result is False: quit() else: self.file_list = list(result) def open_wb(self, filepath): self.wb.open_wb(self.app, filepath) self.ws = self.wb.xlws return self.ws def close_app_wb(self): self.wb.close_workbook() def close_app(self): self.app.quit() def close_baseapp(self): self.baseapp.close_App() def close(self): self.close_app_wb() self.close_baseapp() def get_multi_dto(self, lists): n_cores = multi.cpu_count() with ProcessPoolExecutor(max_workers=n_cores) as executor: result = executor.map(self.get_excel_dto, lists) self.item_shelf.append(result) def test_code(self, lists): with Pool(4) as p: ret = p.map(self.get_excel_dto, lists) self.item_shelf.append(ret)
def __init__(self): self.__def_dir = "DeskTop" self.__ftype = [("Excel2003ファイル", "*.xlsx")] self.picker = GetFile(self.__def_dir, self.__ftype) self.file_list = self.picker.get_files()