Oct-12-2018, 02:02 PM
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:
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']))