Python Forum
Edit Open and Active Excel sheet in Python
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Edit Open and Active Excel sheet in Python
#1
Hello community

This is Joe and i have decided to embark on learning how to code in Python after writing simple Macros in excel VB.

I am currently using anaconda/spyder.

My question is this:-
1)Can I open an excel spreadsheet via python
2) While the excel spreadsheet is open and active; change the data in the excel cells through python code such as print the numbers 1 through to 10 on different excel rows this is done as the excel spreadsheet is open?

I hope this makes sense.

Thank you for your input.
Reply


Messages In This Thread
Edit Open and Active Excel sheet in Python - by JoeDainton123 - Jul-28-2020, 09:42 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Python and pandas: Aggregate lines form Excel sheet Glyxbringer 12 1,697 Oct-31-2023, 10:21 AM
Last Post: Pedroski55
  Active Directory integration dady 2 466 Oct-13-2023, 04:02 AM
Last Post: deanhystad
  read active document name - other than from the window title ineuw 0 495 Sep-11-2023, 09:06 AM
Last Post: ineuw
  how to read txt file, and write into excel with multiply sheet jacklee26 14 9,525 Jan-21-2023, 06:57 AM
Last Post: jacklee26
  Reading Excel file and use a wildcard in file name and sheet name randolphoralph 6 6,864 Jan-13-2022, 10:20 PM
Last Post: randolphoralph
  Read and write active Excel file euras 4 3,383 Jun-29-2021, 11:16 PM
Last Post: Pedroski55
  Open an excel file Newbie1114 1 2,299 Jun-16-2021, 09:11 PM
Last Post: Gribouillis
  Python script for excel sheet Nabil 4 3,225 Jun-01-2021, 05:09 AM
Last Post: Pedroski55
  Add a new column when I extract each sheet in an Excel workbook as a new csv file shantanu97 0 2,192 Mar-24-2021, 04:56 AM
Last Post: shantanu97
  Append excel sheet using openpyxl TammyP 1 2,315 Feb-02-2021, 06:32 PM
Last Post: nilamo

Forum Jump:

User Panel Messages

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