Dec-20-2017, 07:02 AM
@Larz60+, I'm not sure this is what OP asks, just the opposite.
@tarliver - yes, python is well equipped to solve this kind of problems.
you need one of many available packages to read/write from/to excel (it may also depend on the excle file format - e.g. xls vs xlsx). To mention some
python excell
xlwings
and many many more
Also, my experience show that many times user claim to have excel files, while they actually have csv files associated to be open with excel. If this is the case, build-in module csv may come handy.
requests to deal with POST requests
BeautifulSoup to parse the html
or Scrapy to do both
@tarliver - yes, python is well equipped to solve this kind of problems.
you need one of many available packages to read/write from/to excel (it may also depend on the excle file format - e.g. xls vs xlsx). To mention some
python excell
xlwings
and many many more
Also, my experience show that many times user claim to have excel files, while they actually have csv files associated to be open with excel. If this is the case, build-in module csv may come handy.
requests to deal with POST requests
BeautifulSoup to parse the html
or Scrapy to do both