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 6 months ago
CloneXls 9bd50fb869 Changelog update bug resolved 6 months ago
tests 4acc8bad45 Ignores functionality enhanced 7 months ago
.gitignore 8564272b10 Initial commit 7 months ago
LICENSE 8564272b10 Initial commit 7 months ago
README.md 4acc8bad45 Ignores functionality enhanced 7 months ago
requirements.txt f4db77f6a4 Requirements file 7 months ago
setup.py 38c2a66e31 CloneXLS bump to 0.0.7 6 months ago

README.md

baangt-CloneXLS

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.

CloneXls

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.

ChangeLog

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".