Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Python....excel....html form
#1
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?
Reply
#2
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
Reply
#3
@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
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Post HTML Form Data to API Endpoints Dexty 0 1,382 Nov-11-2021, 10:51 PM
Last Post: Dexty
  HTML multi select HTML listbox with Flask/Python rfeyer 0 4,536 Mar-14-2021, 12:23 PM
Last Post: rfeyer
  Using Python request without selenium on html form with javascript onclick submit but eraosa 0 3,135 Jan-09-2021, 06:08 PM
Last Post: eraosa
  Using python within an html form t4keheart 5 5,235 Aug-17-2020, 12:28 PM
Last Post: t4keheart
  how does a html form work exactly? mp3909 2 2,059 Apr-01-2020, 04:02 PM
Last Post: mp3909
  Python3 + BeautifulSoup4 + lxml (HTML -> CSV) - How to loop to next HTML/new CSV Row BrandonKastning 0 2,329 Mar-22-2020, 06:10 AM
Last Post: BrandonKastning
  Posting value from excel to Form (Python+Selenium) revanth 0 1,764 Feb-05-2020, 10:44 AM
Last Post: revanth
  requests post/get to HTML form mrdominikku 1 2,300 Nov-03-2019, 07:12 PM
Last Post: Larz60+
  getting options from a html form pgoosen 5 3,194 Jul-03-2019, 06:07 PM
Last Post: nilamo
  How to send data from remotely hosted HTML form to Pi sajid 2 2,533 Jun-27-2019, 10:28 PM
Last Post: sajid

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020