Clone a base XLS before it is used. Update any changes and write change log into cloned version
bernhardbuhl 38c2a66e31 CloneXLS bump to 0.0.7 | 3 years ago | |
---|---|---|
CloneXls | 3 years ago | |
tests | 3 years ago | |
.gitignore | 3 years ago | |
LICENSE | 3 years ago | |
README.md | 3 years ago | |
requirements.txt | 3 years ago | |
setup.py | 3 years ago |
This package was mainly made to use in baangt.
It's functionality is to Clone a excel file(xls/xlsx)
and a new sheet is made inside cloned file which is used to
store the change logs.
This package contains two main classes. First is CloneXls
& second is ChangeLog
.
update_or_make_clone
is the main method of this class. On the first run it will create a clone file and if the file
already exist it will call ChangeLog
class.
This class is used to check the changes between source and cloned file and update those changes inside cloned file.
Their are few helpful functionalities like ignore_headers & ignore_sheets these both parameters takes a list.
Headers and sheets present in this lists will be ignored for change log and will not be updated from source.
xlsxChangeLog
is the main method of this class which will trigger all the other methods like checking for changes,
updating change log sheet, updating whole clone file from source(except ignored data). AIt will write all the
changes in Change Logs
worksheet. This data will contain
Date & time, "Sheet Name", "Header Name", "Row Number", "Old Value", "New Value"
.