hexagon logo

Excel to Pc-Dmis

is there a script of something for getting data from an excel sheet and in to Pc-Dmis as an variable?
Parents
  • I DO NOT KNOW HOW TO POST THE THREAD BUT I FOUND THIS.
    Ok i finally got it to send the information to a .txt file so how do you get back in as variables?

    Thanks






    Code:
    FPTR =FILE/OPEN,C:\TEST.TXT,READ
    V1 =FILE/READLINE,FPTR,{FILEVAR}
    FILE/CLOSE,FPTR

    When you do that you reference FILEVAR when ever you need what was in the text file.
    __________________[/QUOTE
    craiger_ny
    View Public Profile
    Send a private message to craiger_ny
    Find all posts by craiger_ny
    Add craiger_ny to Your Buddy List

    #8 11-01-2007, 02:39 PM
    mccawes
    Junior Member Join Date: Oct 2007
    Posts: 18


    I really apperciate all of your help. When i try to insert something into the code it either deletes it or i can't put any thing there. I tried to copy and paste what you entered and also i finally found the help for reading from a file in the help menu, but i couldn't even put that in there.


    mccawes
    View Public Profile
    Send a private message to mccawes
    Find all posts by mccawes
    Add mccawes to Your Buddy List

    #9 11-01-2007, 02:42 PM
    craiger_ny
    PC-DMIS Guru Join Date: Apr 2006
    Location: Elmira, NY ~ 853 miles from God's country
    Posts: 2,744


    Insert > File IO
    __________________
    _Believe nothing, no matter where you read it, or who said it, unless it agrees with your own reason and your own common sense. ~ Buddha_


    craiger_ny
    View Public Profile
    Send a private message to craiger_ny
    Find all posts by craiger_ny
    Add craiger_ny to Your Buddy List

    #10 11-01-2007, 02:48 PM
    mccawes
    Junior Member Join Date: Oct 2007
    Posts: 18


    thanks


    mccawes
    View Public Profile
    Send a private message to mccawes
    Find all posts by mccawes
    Add mccawes to Your Buddy List


    Page 1 of 2
Reply
  • I DO NOT KNOW HOW TO POST THE THREAD BUT I FOUND THIS.
    Ok i finally got it to send the information to a .txt file so how do you get back in as variables?

    Thanks






    Code:
    FPTR =FILE/OPEN,C:\TEST.TXT,READ
    V1 =FILE/READLINE,FPTR,{FILEVAR}
    FILE/CLOSE,FPTR

    When you do that you reference FILEVAR when ever you need what was in the text file.
    __________________[/QUOTE
    craiger_ny
    View Public Profile
    Send a private message to craiger_ny
    Find all posts by craiger_ny
    Add craiger_ny to Your Buddy List

    #8 11-01-2007, 02:39 PM
    mccawes
    Junior Member Join Date: Oct 2007
    Posts: 18


    I really apperciate all of your help. When i try to insert something into the code it either deletes it or i can't put any thing there. I tried to copy and paste what you entered and also i finally found the help for reading from a file in the help menu, but i couldn't even put that in there.


    mccawes
    View Public Profile
    Send a private message to mccawes
    Find all posts by mccawes
    Add mccawes to Your Buddy List

    #9 11-01-2007, 02:42 PM
    craiger_ny
    PC-DMIS Guru Join Date: Apr 2006
    Location: Elmira, NY ~ 853 miles from God's country
    Posts: 2,744


    Insert > File IO
    __________________
    _Believe nothing, no matter where you read it, or who said it, unless it agrees with your own reason and your own common sense. ~ Buddha_


    craiger_ny
    View Public Profile
    Send a private message to craiger_ny
    Find all posts by craiger_ny
    Add craiger_ny to Your Buddy List

    #10 11-01-2007, 02:48 PM
    mccawes
    Junior Member Join Date: Oct 2007
    Posts: 18


    thanks


    mccawes
    View Public Profile
    Send a private message to mccawes
    Find all posts by mccawes
    Add mccawes to Your Buddy List


    Page 1 of 2
Children
No Data