Python Forum

I have a question regarding a possible automation of a job for work. I have to take data detailing the names and dates of sessions of preschoolers from an Excel spreadsheet and input it into therabill.com to create calendar sessions.

Is there any way I can write an algorithm to export the data from the Excel spreadsheet row by row into the input boxes on the website? I have some prior experience in Python which is why I put this question on here, but I am open to any suggestions that could work.

(Jun-14-2018, 10:08 PM)bdarragh00 Wrote: [ -> ]Is there any way I can [...] export the data from the Excel spreadsheet row by row into the input boxes on the website?

Yes, certainly.

Anton vBR (Stackoverflow) Wrote:Does therabill.com have an API? Then you should have a look at the requests library. To read excel files you could use pandas or xlrd depending on how well-structured the files are

I didn't look for one, but the advice to look for an API is solid. If an API doesn't exist, you can consider mechanize or selenium (the latter if Javascript is in the way). If they don't have an API, you'll have to reverse-engineer the informal API that exists as part of the website.

I'd suggest not touching pandas unless needed, but I'm not an expert on that kind of stuff.

Beyonds this, you'd have to give things a try and then we'd help you move forward with each particular blocker.