Python Forum

I need help understanding if I should use python here. I want to submit data from an excel sheet to an html form, POST, save html tree of new webpage to new file, parse, and write contents within <span> to a new excel file, close webbrowser and excel file with html tree. and do this on a loop for n rows. Anyone?

You could use something like: https://pypi.python.org/pypi/pyexcel-handsontable/0.0.1

There are others, this is just the first one I looked at, see: https://pypi.python.org/pypi?%3Aaction=s...mit=search

@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