RobotStudio event

String Excel File

Ash
Ash ✭
in RAPID Programming
Morning All, Just a quick question, 
I was wondering if anyone might know if it's possible to have an Excel file on the HD0A with all my string message declarations in? So for my UIMsgBox's the headers, MsgArrays etc I can call the file and copy contents to a running dialogue. I'm sure it is possible through serial channels and IODev's etc But just needed to bounce the idea off of someone :-)

Comments

  • lemster68
    lemster68 ✭✭✭
    It is likely that you could do that, but it would be more difficult than just using texttabinstall and related instructions.
    Lee Justice
  • Ash
    Ash ✭
    Yea i kinda gave up on the Excel file idea and just used a text file and the Read String function.
  • soup
    soup ✭✭✭
    edited April 2018
    How about saving your text file as a ".csv" and open it in Excel. Rapid doesn't care about the file extension, as long as the file ends up being predictable text. Then Rapid can read a line, use StrFind to find the position of the comma, then split it off and saved a piece in an array, find the next comma, split, save, etc., etc.

Categories

In this Discussion