PDA

View Full Version : Excel to Vizard


Marwan.said
08-13-2012, 07:59 AM
Hello Everyone,

I have a question on how to read data from excel to vizard. Now, I have X,Y and Theta data in excel and I want to read them in Vizard. Then, I want to take these data and use them for moving an object in Vizard. Can anyone help me on this?

I have already looked at this article but it does not show me how to read specific rows and columns in the excel sheet. http://kb.worldviz.com/articles/1660

Thanks,

Marwan

nabrahamson
08-14-2012, 09:32 AM
In the link you provided, there is another link to the xlwt api documentation. If you download the pdf they provide (here http://www.simplistix.co.uk/presentations/python-excel.pdf ), you can find an example of how to do this on page 7.

rogerlew
01-22-2013, 11:28 AM
Maybe you could read the Excel file into a Python data structure (dictionary of lists or dictionary of Numpy arrays) and then reference the Python data structure to move your object in Vizard. Would take out the hassle of having to reference specific rows and columns and might make your code more flexible if you want to change things in the future.

Roger