So, first of all, no one on this forum is going to do this for you. We can help, a lot, but you must show effort and ask specific questions when you hit a problem you can not solve yourself.
Second, this is way too broad questions and we can give only general directions how to start and what you can explore
eventually you may need additional packages like Selenium and PhantomJS
if you "download' the files from some network location build-in modules for file manipulation should do.
check packages that allow you to read/write excel files. Is it really xls/xlsx/xlsm files or csv?
http://www.python-excel.org/
https://www.xlwings.org/
build-in csv module (if not really xls* files)
also pandas and numpy are very powerful and have great functionality for data crunching.
Second, this is way too broad questions and we can give only general directions how to start and what you can explore
(Apr-26-2017, 05:34 AM)Ramakrishna Wrote: Q1. How can i get the two exact same files today's and yesterday's excel file.check Requests if you download the files from Internet
eventually you may need additional packages like Selenium and PhantomJS
if you "download' the files from some network location build-in modules for file manipulation should do.
(Apr-26-2017, 05:34 AM)Ramakrishna Wrote: Q2. How to compare the two excels.
Q3. How can i highlight in red and exclamatory mark.
check packages that allow you to read/write excel files. Is it really xls/xlsx/xlsm files or csv?
http://www.python-excel.org/
https://www.xlwings.org/
build-in csv module (if not really xls* files)
also pandas and numpy are very powerful and have great functionality for data crunching.