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
Question Is there a python program for automating this invoicing workflow? PG_Archipelago 3 1,026 Feb-02-2023, 11:01 PM
Last Post: Larz60+
Lightbulb Help using Google Sheets matheuspimenta 0 687 Dec-15-2022, 05:36 PM
Last Post: matheuspimenta
  How to loop through all excel files and sheets in folder jadelola 1 4,331 Dec-01-2022, 06:12 PM
Last Post: deanhystad
  Compare two Excel sheets with Python and list diffenrences dmkfon 1 14,489 Oct-09-2021, 03:30 PM
Last Post: Larz60+
  Help with Creating a Script for Automating Reports SunWers 1 1,882 Dec-29-2020, 10:21 PM
Last Post: jjc385
  Automating to run python script 100 times by changing parameters pmt 1 2,562 Dec-29-2020, 10:31 AM
Last Post: andydoc
  identical cells in 2 different excel sheets python pandas esso 0 1,598 Jul-19-2020, 07:50 PM
Last Post: esso
  Automating Windows GUI applications metro17 4 12,174 Feb-10-2020, 09:46 AM
Last Post: metro17
  Comparing data from two Excel sheets Stuart_Houghton 0 1,650 Jan-19-2020, 02:49 PM
Last Post: Stuart_Houghton
  Concat multiple Excel sheets with exclusion alessandrotk 1 2,812 Jan-10-2020, 04:43 AM
Last Post: sandeep_ganga

Forum Jump:

User Panel Messages

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