Python Forum
data from excel - Printable Version

+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: data from excel (/thread-13386.html)



data from excel - mida1 - Oct-12-2018

Hi,
can you help with reading data from excel to python3? Excel is connected with other data source by DDE and data are changed online. I need actual data when run python script, but they are old - after last excel saving. Thank you
Example:
import pyexcel as pe 
records = pe.iget_records(file_name="test.xlsm") 
for record in records:
     print((record['Name'], record['Age']))