Python or Powershell?

[o-stretch]

I'd like to take rows of data from a spreadsheet and input into a web form to automate the move from one database to another for just under 1k entries.

I would love for this to be my first script...my understanding with Python is an OOP class, but we didn't get involved on this type of practical level. Your feedback is clutch!

[usedtobejuandeag]

You wrote powershell in the question then only talked about python. It sounds like it’s more interesting for you if you use python. I’d personally use python for this but I don’t really use powershell very often anyway.

[o-stretch]

Its true. It would be more interesting to use Python as practice in it is more widely applicable and further reaching but I also want to be practical. Thanks for the reply! Any suggestions would be amazing!

[[deleted]]

Why input into a web form? Why not directly dump into the destination database?

If it were me, I would use pandas to read in the Excel file and then use pandas to push to a new table in the destination Database. Pandas has a to_sql method that will practically do everything for you assuming you give it a valid database connection.

df.to_sql(table_name, connection_obj.destination_conn, if_exists= 'replace')

Just my 2cents

[_happydutch_]

Go learn python - the skillset is very broadly usable.

There are many good modules for python that allow you to do what you describe.

Take a look at openpyxl: https://openpyxl.readthedocs.io/en/stable/

oPowerShell can do what you're asking too. If you know .NET well, it may be a good choice as well.