Page 1 of 1

Getting data from excel

Posted: 27 Feb 2016, 06:43
by berepe
hi guys
I am trying to figure out a way to get a cell value from an excel file.


it would be similar to " read text file" function that I can chose the sheet name and cell coordinates.
like C:/sample.xls
Sheet 1
B3

Thanks in advance

Re: Getting data from excel

Posted: 14 Mar 2016, 18:29
by eureka
I'm learning about usage of Actionaz by browsing through this forum.

But reading your question I would try running executable python script through a Command action.
The python script will parse your .xls file to extract and return cell values.

More found in this blog .. http://www.sitepoint.com/using-python-p ... heet-data/