def __init__(self, root): self.root = root dirname = os.path.dirname(__file__) # =================================== self.imagelogopath = PathSteel(dir_path=dirname, Is_Directory_Path_To_SubFolder=True, FileName="logo.png", subfolder="img") self.pathconfig1 = PathSteel(dir_path=dirname, Is_Directory_Path_To_SubFolder=True, FileName="hrdata_modified.csv", subfolder="config") self.pathconfig = resource_path_is_from_pyinstall_and_dev( self.pathconfig1.refpath()) pathconfigexell = PathSteel(dir_path=dirname, Is_Directory_Path_To_SubFolder=True, FileName="conf_ex.xlsx", subfolder="config") self.pathconfigexell = resource_path_is_from_pyinstall_and_dev( pathconfigexell.refpath()) self.imagelogo = ImageTk.PhotoImage(file=self.imagelogopath.refpath()) # path to config of excel to copy self.pathconfigexcelcopy = resource_path_is_from_pyinstall_and_dev( PathSteel(dir_path=dirname, Is_Directory_Path_To_SubFolder=True, FileName="config_hm.xlsx", subfolder="config").refpath()) self.pathtokey = resource_path_is_from_pyinstall_and_dev( refullpath(dirpath=dirname, filename="key.key", folderchild="config")) self.pathtovaluecsv_key = resource_path_is_from_pyinstall_and_dev( refullpath(dirpath=dirname, folderchild="config", filename="fn.csv")) self.ser_key = resource_path_is_from_pyinstall_and_dev( refullpath(dirpath=dirname, folderchild="config", filename="seri.key")) self.valueser_key = resource_path_is_from_pyinstall_and_dev( refullpath(dirpath=dirname, folderchild="config", filename="ser.csv")) k = key_license(pathtokey=self.pathtokey, pathtoserial_key=self.ser_key, root=self.root, pathtovaluecsv_key=self.pathtovaluecsv_key, pathvalueser_key=self.valueser_key) print("returnk", k) # account authentication """
def __init__(self, parent, controller): self.parent = parent self.controller = controller tk.Frame.__init__(self, parent) self.inyname = Label(self, text="INPUT YOUR NAME", width=17, bg="SteelBlue2", fg="black") # create full path self.pathcre = r"C:\NLT" Path(self.pathcre).mkdir(parents=True, exist_ok=True) # return path full ps = PathSteel(dir_path=self.pathcre, FileName="nhuan.csv") self.pathf = ps.refpath() rinput = rcsv(pathtor=self.pathf, indexarrtoget=[0]) row = rinput.Rerowbyindxaindexarr() row = list(set(row)) self.inynamein = ttk.Combobox(self, values=row) self.button = tk.Button(self, text="Next", command=lambda: self.checkinputyourname()) self.inyname.pack() self.inynamein.pack() self.button.pack()
def getdirpathfromorigin(output1): # Get path full global pathinout pathinout = getpathfromtk(output1) filename = ExtractFileNameFromPath(pathinout) filename1 = getfilenamewoexten(filename) # get dirpath from full path dn = getdirpath(pathinout) ps = PathSteel(dir_path=dn, FileName=filename1 + ".csv") pathf = ps.refpath() return pathf
def __init__(self, pathfolder=None, fileparent="WHITEX - TONG HOP NGAN SACH.xlsx", filekid="AZB-INPUT.xlsx", subfolderinput="0.input", subfolderoutput="1.output", kipnamesheet=[ "AZB-20", "AZB-40", "AZB-50", "AZB-60", "AZB-70", "AZB-80" ], runforexcel="both"): self.fileparent = fileparent self.pathfolder = pathfolder self.filekid = filekid self.subfolderinput = subfolderinput self.subfolderoutput = subfolderoutput self.runforexcel = runforexcel self.kipnamesheet = kipnamesheet self.ps = PathSteel(dir_path=self.pathfolder, Is_Directory_Path_To_SubFolder=True, subfolder=self.subfolderinput, FileName=self.filekid) # return file kid self.pathkid = self.ps.refpath() # return fileparent self.ps.subfolder = self.subfolderoutput self.ps.FileName = self.fileparent self.pathparent = self.ps.refpath() self.namesheet = [ "AZB-10", "AZB-20", "AZB-30", "AZB-40", "AZB-50", "AZB-60", "AZB-70", "AZB-80" ] #set keysheet self.keysheet = {self.namesheet[0]:[41,3,18,None,41,3,18,None],\ self.namesheet[1]:[41,3,18,None,41,3,18,None],\ self.namesheet[2]:[6,4,19,None,6,4,19,None],\ self.namesheet[3]:[41,3,18,None,41,3,18,None],\ self.namesheet[4]:[41,3,18,None,41,3,18,None],\ self.namesheet[5]:[41,3,18,None,41,3,18,None],\ self.namesheet[6]:[41,3,18,None,41,3,18,None],\ self.namesheet[7]:[41,3,18,None,41,3,18,None]}
def synserverfileexc(self, pathtemp, indexcol=None): filenametemp = ExtractFileNameFromPath(path=pathtemp) dirname = abspath("") fullname = PathFromFileNameAndDirpath(dir_path=dirname, filename=filenametemp) ######################################## pathfulloutput = getpathfromtk(output1) filename = ExtractFileNameFromPath(pathfulloutput) dbk = nmgui(tktk=self.master).returndirpath( getfilenamewoexten(filename)) ######################################## #create diff forder for diff file dirpathdiff = nmgui(tktk=self.master).returndirpath("diff_history") inynameing1 = inynameing.replace(" ", " ") pathdiff = PathFromFileNameAndDirpath(dir_path = dirpathdiff, filename = dt_string_sr +\ "_" + inynameing1 +\ "_" + filename) ps = PathSteel(dir_path =dbk, FileName = dt_string_sr +\ "_" + inynameing1 +\ "_" + filename) dbk_fullpath = ps.refpath() #get path to orginal location with file name diff comparetwofile1 = comparetwofile( path_OLD=pathtemp, path_NEW=fullname, index_col=None, usernamein=inynameing1, pathtcsvtosavedata=getdirpathfromorigin(output1), difpathtobk=dbk_fullpath, pathtorgindiff=pathdiff, dt=dt_string) comparetwofile1.excel_diff()
def CreateFileExcel(pathin,pathout): #filename = "Config_Setting.csv" pathconf = PathSteel(dir_path =pathin, FileName = "Config_Setting.csv")\ .refpath() #fullpath = os.path.join(pathin,filename) # get path store data to handling Right_Genneral_All_path = PathFromFileNameAndDirpath(dir_path =pathin, filename ="Right_Genneral_All.csv" ) Left_Genneral_All_path = PathFromFileNameAndDirpath(dir_path =pathin, filename ="Left_Genneral_All.csv" ) # key value keyvalue = ["ValueGeneral", "Columnmove", "LocationCellForMoveColumn", "GenneralColumnNotChange", "GeneralConcernRaffter", "Genneral_Select", "LocationOfRowLeft", "LocationOfRowRight", "ExcelCellForMoveColumnRight", "LocationOfPurlin", "startrow", ] #location in conf locvalue = [12,16,17,19,20,21,23,24,25,26,30] credict_c = credict(KeyValues = keyvalue, LocConf = locvalue, Config_Setting_Path = pathconf) credict_list = credict_c.Dictfromkeyandvalueconf() # create arr from keyvalue valgen = credict_list.get("ValueGeneral", "") colmv = credict_list.get("Columnmove", "") locmvcol = credict_list.get("LocationCellForMoveColumn", "") gencolnotchg = credict_list.get("GenneralColumnNotChange", "") genconraf = credict_list.get("GeneralConcernRaffter", "") gensel = credict_list.get("Genneral_Select", "") locrowleft = credict_list.get("LocationOfRowLeft", "") locrowright = credict_list.get("LocationOfRowRight", "") excemvcolright = credict_list.get("ExcelCellForMoveColumnRight", "") locpur = credict_list.get("LocationOfPurlin", "") strow = credict_list.get("startrow", "") # data template if IsRunningInPyinstallerBundle(): #NameFile = ExtractFileNameFromPath(DataExcel) DataExcel = resource_path_is_from_pyinstall_and_dev(FileName = 'DataALL - Template.xlsx', Subfolder="Data", Is_Directory_Path_To_SubFolder= True, dir_path=sys._MEIPASS) else: # get file excel from template excel (full path) DataExcel = PathSteel(modulename =templatexc, FileName ='DataALL - Template.xlsx')\ .getpathmodule() """ DataExcel = os.path.join((os.path.dirname(templatexc.__file__)), 'DataALL - Template.xlsx') """ book = load_workbook(DataExcel) writer = ExcelWriter(DataExcel, engine='openpyxl') writer.book = book writer.sheets = dict((ws.title, ws) for ws in book.worksheets) for path in [Left_Genneral_All_path, Right_Genneral_All_path]: df1 = pd.read_csv(path, delimiter=',', index_col = 0) dfCount = df1.shape df1.to_csv(path) #write Left to Excel dfValueGeneral = pd.read_csv(path, delimiter=',', usecols = valgen, nrows= 1) dfValueGeneral.to_excel(writer,'General Member', index=False,header=True , startcol=0,startrow \ = strow[0]) worksheet = writer.sheets['General Member'] # create frame to excel excellframe = toexcel(worksheet = worksheet, path = path, path_conf =pathconf, lpath=Left_Genneral_All_path, rpath = Right_Genneral_All_path) if path == Left_Genneral_All_path: usecolsArr = locrowleft LocationMoveColumn = locmvcol #write path to excel excellframe.wrivaltoexc() else: usecolsArr = locrowright LocationMoveColumn = excemvcolright #write path to excel excellframe.wrivaltoexc() #Write genneral to excel DfChangegenneral = pd.read_csv(path, delimiter=',', usecols = gencolnotchg, nrows= 1 ) DfChangegenneral.to_excel(writer, 'General Member', index=False, header=True, startcol=0, startrow= int(usecolsArr[1]) ) #write Genneral Concern Raffter DfChangegenneral = pd.read_csv(path, delimiter=',', usecols = genconraf ) DfChangegenneral.to_excel(writer, 'General Member', index=False, header=True , startcol=0, startrow=int(usecolsArr[2]) ) #write genneral selected DfChangegenneral = pd.read_csv(path, delimiter=',', usecols = gensel, nrows= 1) DfChangegenneral.to_excel(writer, 'General Member', index=False, header=True , startcol=0, startrow= int(usecolsArr[0]) ) #write purlin roof DfChangegenneral = pd.read_csv(path, delimiter=',', usecols = locpur, nrows= 1) DfChangegenneral.to_excel(writer, 'General Member', index=False, header=True , startcol=0, startrow= int(usecolsArr[3])) worksheet = writer.sheets['General Member'] #Wirte move Column to excel excellframe.writemovecol(LocationMoveColumn, colmv) # create full path from dirpath path = PathSteel(dir_path =pathout, FileName ='new_big_file.xlsx')\ .refpath() #path = os.path.join(pathout,'new_big_file.xlsx') book.save(path)
def openfile1(self, output): # get path full self.pathinout = getpathfromtk(output) # save as file path from path original pathst = PathSteel(pathorigrn=self.pathinout) pathst.saveasfiletopathAndopen()
def dowloadfilexcelfromeven(self, fullname): # save as file path from path original pathst = PathSteel(pathorigrn=fullname) pathst.saveasfiletopathAndopen()