How do I extract data from excel to vrep

Typically: "How do I... ", "How can I... " questions
Post Reply
ZZhang
Posts: 4
Joined: 10 Jul 2019, 18:43

How do I extract data from excel to vrep

Post by ZZhang » 16 Jul 2019, 16:44

Here is the problem. In my scenario, to achieve a dynamic movement of robot, the position data is saved in an excel file. Is this possible to extract exact data from cell to cell in a table?

I tried to extract the position data from txt file, however, it is difficult to split string of the line to extract each coordinate data. Is there any solution for this problem.

Cheers

coppelia
Site Admin
Posts: 7272
Joined: 14 Dec 2012, 00:25

Re: How do I extract data from excel to vrep

Post by coppelia » 18 Jul 2019, 14:50

Hello,

the simplest is probably to export your data as csv-file (comma-separated-values), which Excel allows to do.
Then you can handle that file as a regular text file. To read a text file from Lua, have a look here for instance.

Cheers

Post Reply