+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: Data Science (https://python-forum.io/forum-44.html)
+--- Thread: Excel and Python (/thread-1968.html)
Excel and Python - robsmith - Feb-07-2017
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
RE: Excel and Python - UGuntupalli - Feb-07-2017
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
RE: Excel and Python - Larz60+ - Feb-07-2017
Also, Go here https://pypi.python.org/pypi and search for excel
RE: Excel and Python - robsmith - Feb-07-2017
The links are appreciated.
RE: Excel and Python - Yoriz - Feb-07-2017
Pandas
RE: Excel and Python - Larz60+ - Feb-07-2017
Pandas is dandas