Python Forum

Full Version: Excel and Python
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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
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
Also, Go here https://pypi.python.org/pypi and search for excel
The links are appreciated.
Pandas is dandas