Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Excel and Python
#1
New to Python but in short I work with Excel files on a daily basis and currently are using one Excel file to import data from other Excel files.  Wanting to know if it is possible to use Python to extract data from Excel and more importantly can you use python to do a range search in Excel and extract that information.  Not looking for coding help but if someone could point me in the right direction that would be most helpful.

Thanks
Reply
#2
Hello robsmith ,
Yes . Python can be used to read and perform a variety of functionality with excel files and csv files. This could be a decent page to start at . The page illustrates reading and writing data from and to excel workbooks using excel packages

https://automatetheboringstuff.com/chapter12/

Best
U
Reply
#3
Also, Go here https://pypi.python.org/pypi and search for excel
Reply
#4
The links are appreciated.
Reply
#5
Pandas
Reply
#6
Pandas is dandas
Reply


Forum Jump:

User Panel Messages

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