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

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

Thank you so much!
Wendy
Reply
#2
You can find python packages here: https://pypi.org/
for excel: https://pypi.org/search/?q=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.
Reply


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

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