Is it possible to import MS Excel Tables to Opto Numeric Tables?


#1

If direct importation is not possible, are there any other ways to import tables?


#2

Hi innotech01,

There are a couple of different ways you could take your table data from Excel and put it into a numeric table. The method you choose will depend on a couple of things:

  1. Is this a one-shot deal, where you're initializing some values perhaps as your strategy gets running? If so, check out this post about initializing tables: http://www.opto22.com/community/showthread.php?t=450&p=1628&viewfull=1#post1628
  2. Are you using PAC Display, and have you considered using recipes? Here's a webinar that shows how/when to use those: http://www.opto22.com/lp/optowebinars.aspx#recipes
  3. If you save that spreadsheet as a text file, like a CSV (comma delimited), you could then have your strategy read and parse that file and load the values into a Numeric Table variable in your strategy. It's pretty easy to move a file from a PC to a PAC using FTP. Of course, if you're using SoftPAC no need to move the file at all! You'd just use a Communication Handle to open the file, then start parsing...

    Here’s an example that parses a different kind of file, but it’ll give you an idea of what it’s like to open/read from a file:
    http://www.opto22.com/community/showthread.php?t=482&page=1

Do any of those methods sound like something that could work for your situation?

Thanks,
OptoMary


#3

That’s awesome. Thanks optomary!