Read xls and xlsx file in Sikuli IDE with python | Tutorial Part #5

[@spawspaw3708]

i've been following you on these sikulix and i love these! very well explained and much easier to comprehend!

[@2APatriot]

Your Sikulix videos are great. I've automated a lot of my job now and I can use the extra time for preventative maintenance and projects.

[@CoolITHelp]

Great to hear!

[@geetapuri8798]

How to run sikuli through CMD prompt?

[@brenosantos8198]

Nice video! Congratulations :)

[@ShivaniPandey-nj4xw]

Hi,
As you said in video, sikulix will automatically import Jython standalone jar file. I placed it in right place but its not happening. Can u pls help me out?

[@CreativeSamCS]

Error
[error] script [ 08 ] stopped with error in line 1
[error] ImportError ( No module named mmap )
[error] --- Traceback --- error source first
line: module ( function ) statement
26: book ( ) import mmap
15: __init__ ( ) from .book import Book, colname, open_workbook_xls
1: main ( ) import xlrd
[error] --- Traceback --- end --------------
i am getting this error

[@aadeshshah7223]

Hello, I followed the exact steps mentioned here but I am getting this error. Do you think you can provide the solution for this?
My Code:
import xlrd
book = xlrd.open_workbook("Nifty500.xlsx")
Error:
[error] script [ Python Code ] stopped with error in line 3
[error] java.lang.ClassNotFoundException ( org.apache.xerces.parsers.SAXParser )
[error] --- Traceback --- error source first
line: module ( function ) statement
91: expat ( __init__ ) self._reader = XMLReaderFactory.createXMLReader(_xerces_parser_name)
59: expat ( ParserCreate ) return XMLParser(encoding, namespace_separator)
1480: ElementTree ( __init__ ) parser = expat.ParserCreate(encoding, "}")
651: ElementTree ( parse ) parser = XMLParser(target=TreeBuilder())
1184: ElementTree ( parse ) tree.parse(source, parser)
333: xlsx ( process_rels ) tree = ET.parse(stream)
809: xlsx ( open_workbook_2007_xml ) x12book.process_rels(zflo)
130: __init__ ( open_workbook ) bk = xlsx.open_workbook_2007_xml(
3: main ( ) book = xlrd.open_workbook("Nifty500.xlsx")
[error] --- Traceback --- end --------------

[@OkabeTheking]

got any solution ?

[@OkabeTheking]

error] script [ testsikuli excel click ] stopped with error in line 2
[error] java.lang.ClassNotFoundException ( org.apache.xerces.parsers.SAXParser )
[error] --- Traceback --- error source first
line: module ( function ) statement
91: expat ( __init__ ) self._reader = XMLReaderFactory.createXMLReader(_xerces_parser_name)
59: expat ( ParserCreate ) return XMLParser(encoding, namespace_separator)
1480: ElementTree ( __init__ ) parser = expat.ParserCreate(encoding, "}")
1205: ElementTree ( iterparse ) parser = XMLParser(target=TreeBuilder())
55: xlsx ( ensure_elementtree_imported ) ET.iterparse(_dummy_stream)
55: xlsx ( ensure_elementtree_imported ) ET.iterparse(_dummy_stream)
792: xlsx ( open_workbook_2007_xml ) ensure_elementtree_imported(verbosity, logfile)
130: __init__ ( open_workbook ) bk = xlsx.open_workbook_2007_xml(
2: main ( ) book = xlrd.open_workbook("test.xlsx")
[error] --- Traceback --- end --------------

[@niklasfaurholt1755]

did u find a solution for this? i have same error :/

[@DoritYacobi]

To all that get the error:
Error
[error] script [ 08 ] stopped with error in line 1
[error] ImportError ( No module named mmap )
[error] --- Traceback --- error source first
line: module ( function ) statement
26: book ( ) import mmap
15: _init_ ( ) from .book import Book, colname, open_workbook_xls
1: main ( ) import xlrd
[error] --- Traceback --- end --------------
It is due to the fact that the xdlr folder are not in the right place
The instractions are to put the xldr folder in path:
C:\Users\amitk\AppData\Roaming\Sikulix\Lib
but the right path is:
C:\Users\amitk\AppData\Roaming\Sikulix\Lib\site-packages