Code written in python to format reccuring deposit excel file to printable spreadsheets, using modules "openpyxl" and "xls2xlsx"
- Make a new folder of any name.
- Inside that folder paste the two files 'formatrd.py' and 'logo.png'.
- now paste the xls files to be formated in the same folder. the folder will look like
```
formatrd.py
logo.png
filetobeformated1.xls
filetobeformated2.xls
filetobeformated3.xls
.
.
.
```
- the spreadsheet files which are to be formated must be of extension
.xls
. By default downloaded files from post office have the.xls
- the file should not be tampered in any way. If you input a half edited file it will be fully disturbed and will not remain of any use.
- Open the folder in any terminal
- run command
python formatrd.py
in windows - or run command
python3 formatrd.py
in mac or linux