Bottom Page

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
Quote
#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
Quote
#3
Also, Go here https://pypi.python.org/pypi and search for excel
Quote
#4
The links are appreciated.
Quote
#5
Pandas
Quote
#6
Pandas is dandas
Quote

Top Page

Forum Jump:


Users browsing this thread: 1 Guest(s)