# excel data

**URL:** <https://tech-community.robotics.abb.com/t/excel-data/930>\
**Category:** RobotStudio\
**Created:** [November 21, 2006, 2:00am UTC](https://tech-community.robotics.abb.com/t/excel-data/930 "2006-11-21T02:00:06Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Yu\_I](https://avatars.discourse-cdn.com/v4/letter/y/ce73a5/32.png) [@Yu\_I](https://tech-community.robotics.abb.com/u/Yu_I)\
**Post date:** [November 21, 2006, 2:00am UTC](https://tech-community.robotics.abb.com/t/excel-data/930/1 "2006-11-21T02:00:06Z")

</div>

Hello

Can we use excel file data or other data in RS?

We want to create targets from such data file.

Yu

---

<div class="post-metadata">

**Author:** ![Henrik\_Berlin](https://dub1.discourse-cdn.com/flex005/user_avatar/tech-community.robotics.abb.com/henrik_berlin/32/1011_2.png) [@Henrik\_Berlin](https://tech-community.robotics.abb.com/u/Henrik_Berlin)\
**Post date:** [November 21, 2006, 12:56pm UTC](https://tech-community.robotics.abb.com/t/excel-data/930/2 "2006-11-21T12:56:16Z")

</div>

Dear Yu,

Excel data cannot be used directly in RS. But, as a workaround, I would recommend you to create RAPID code from the data by some “Excel engineering”, paste that code into a RAPID module, load the module in the VC, and sync to station.

Remember, though, that the robtargets must be referenced by a Move-instruction to be synchronized to the station.

Regards,

Henrik

---

<div class="post-metadata">

**Author:** ![Anders\_S](https://avatars.discourse-cdn.com/v4/letter/a/ce7236/32.png) [@Anders\_S](https://tech-community.robotics.abb.com/u/Anders_S)\
**Post date:** [November 22, 2006, 11:21am UTC](https://tech-community.robotics.abb.com/t/excel-data/930/3 "2006-11-22T11:21:12Z")

</div>

Hi Yu,

Next release of RobotStudio (RS 5.08) will contain VSTA (Visual Studio Tools for Application). With VSTA will you be able to write your own macros. So then will it be possible to write a macro that for example import data from Excel, and creates targets from it. The program language in VSTA will be Visual Basic and C#.

---

<div class="post-metadata">

**Author:** ![Yu\_I](https://avatars.discourse-cdn.com/v4/letter/y/ce73a5/32.png) [@Yu\_I](https://tech-community.robotics.abb.com/u/Yu_I)\
**Post date:** [November 28, 2006, 9:35am UTC](https://tech-community.robotics.abb.com/t/excel-data/930/4 "2006-11-28T09:35:17Z")

</div>

Hello Henrik and Anders

Thank you for your replies.

I’ll do it if I can.

Yu
