def __init__(self, retr_path = None,
retr_sheetname =None,
fuction = None,
pathconf = None,
path_exell_tem = None
):
self.__dictconf = dict_str_fromlist(path=pathconf)
self.__path_exell_tem = path_exell_tem
self.__retr_sheetname = retr_sheetname
self.__fuction = str(fuction).lower()
if retr_sheetname != "Active Sheet":
sheet_by_namesheet(path=retr_path,
namesheet=retr_sheetname).activate()
self.__ws_retr = activesheet()
def __init__(
self,
retr_path=None,
retr_sheetname=None,
des_path=None,
des_sheetname=None,
fuction=None,
pathconf=None,
):
self.dictconf = returndictrowforcsv(path=pathconf)
self.__retr_sheetname = retr_sheetname
self.__des_path = des_path
self.__des_sheetname = des_sheetname
self.__fuction = fuction
if retr_sheetname == "Active Sheet":
retr_path = activeworkbook_fullname()
retr_sheetname = activesheet_name()
self.__pexcelretr = repathlinkexcel(usingfullname=True,
fullname=retr_path,
namesheet=retr_sheetname)
if des_sheetname == "Active Sheet":
self.__ws_des = activesheet()
else:
self.__ws_des = sheet_by_namesheet(path=des_path,
namesheet=des_sheetname)
def __init__(self, retr_path = None,
retr_sheetname =None,
fuction = None,
pathconf = None,
):
self.dictconf = dict_str_fromlist(path=pathconf)
self.__retr_sheetname = retr_sheetname
self.__fuction = str(fuction).lower()
if retr_sheetname == "Active Sheet":
self.__ws_retr = activesheet()
else:
self.__ws_retr = sheet_by_namesheet(path=retr_path,
namesheet=retr_sheetname)
def __init__(self,
ws=None,
rangea="C7:C1000",
pathfull=None,
namesheet="PTVT1",
engine="openpyxl"):
self.rangea = rangea
self.engine = engine
self.ws = sheet_by_namesheet(path=pathfull, namesheet=namesheet)
self.lastrow = self.ws.range(
'A' + str(self.ws.cells.last_cell.row)).end('up').row
self.rangea = returnrangelastcolumn(stringrang=rangea,
lrow=self.lastrow)
def __init__(
self,
retr_path=None,
retr_sheetname=None,
fuction=None,
pathconf=None,
):
self.__dictconf = dict_str_from_lcsv(path=pathconf)
self.__retr_sheetname = retr_sheetname
self.__fuction = fuction
if retr_sheetname == "Active Sheet":
self.__ws_retr = activesheet()
else:
self.__ws_retr = sheet_by_namesheet(path=retr_path,
namesheet=retr_sheetname)
def __init__(
self,
retr_path=None,
retr_sheetname=None,
fuction="",
pathconf=None,
):
self.__retr_sheetname = retr_sheetname
self.__fuction = fuction.lower()
# Create a dict have parameter from csv
self.__dictconf = dict_str_from_lcsv(path=pathconf)
# Option from user input (Active Sheet or not)
self.__ws_retr = activesheet() if retr_sheetname == "Active Sheet"\
else sheet_by_namesheet(path=retr_path,
namesheet=retr_sheetname
)
# Check file excel execute is conf_ex.xlsx or not
if self.__ws_retr.name == "hrdata_modified":
messagebox.showerror(
"Error Name Excel",
"Can not using file excel: conf_ex.xlsx to execute. \
Check again {}".format("hrdata_modified"))
def __init__(self, pathconf, pathexconf):
self.__pathconf = pathconf
self.__ws_excel = sheet_by_namesheet(path=pathexconf,
namesheet="hrdata_modified",
visible=True)