Python Forum
Automating Excel sheets with Python
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Automating Excel sheets with Python

Does anyone have recommendations in terms of resources for someone trying to learn how to automate Excel spreadsheets using Python?

Thank you so much!
You can find python packages here:
for excel:
These range from poor to excellent, so you will need to experiment to find best one
A few things you can do to help is:
  • Order by 'Date last updated' Check last update date. If more that a year old, that 'could' be an indication that the script has either been abandoned, in limbo, or is so good that updates haven't been necessary.
  • Order by 'Trending' the list will now be arranged by download activity
  • Order by 'Relevance' List is now in order of relevance to topic.

Possibly Related Threads…
Thread Author Replies Views Last Post
  Help with Creating a Script for Automating Reports SunWers 1 498 Dec-29-2020, 10:21 PM
Last Post: jjc385
  Automating to run python script 100 times by changing parameters pmt 1 1,005 Dec-29-2020, 10:31 AM
Last Post: andydoc
  identical cells in 2 different excel sheets python pandas esso 0 453 Jul-19-2020, 07:50 PM
Last Post: esso
  Automating Windows GUI applications metro17 4 3,673 Feb-10-2020, 09:46 AM
Last Post: metro17
  Comparing data from two Excel sheets Stuart_Houghton 0 719 Jan-19-2020, 02:49 PM
Last Post: Stuart_Houghton
  Concat multiple Excel sheets with exclusion alessandrotk 1 1,009 Jan-10-2020, 04:43 AM
Last Post: sandeep_ganga
  Getting Cells from the Sheets "automate the boring stuff" Shafla 8 1,511 Sep-24-2019, 04:53 AM
Last Post: snippsat
  Linking python to Google Sheets Charliefish1311 1 1,057 Jul-09-2019, 12:31 AM
Last Post: micseydel
  Iterate over excel-sheets using xlrd tobbs 6 8,391 Feb-28-2019, 08:33 PM
Last Post: tobbs
  Automating unittest ichabod801 3 1,323 Oct-28-2018, 09:32 PM
Last Post: Gribouillis

Forum Jump:

User Panel Messages

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