AVEVA Community
AVEVA Community
  • Site
  • User
  • Site
  • Search
  • User
PDMS/E3D Forum
  • AVEVA World
PDMS/E3D Forum
Macros & Tools Row read
  • Forums
  • Resources
  • Mentions
  • Sub-Groups
  • Tags
  • More
  • Cancel
  • New
  • Replies 15 replies
  • Subscribers 17 subscribers
  • Views 353 views
  • Users 0 members are here
Options
  • Share
  • More
  • Cancel
Related

Row read

Sgar Saha
Sgar Saha over 5 years ago
 
  • Sign in to reply
  • Cancel

Top Replies

  • Sgar Saha
    Sgar Saha over 3 years ago in reply to Aurelio Hinampas +1
    How to append data into existing excel, I have 3 columns. and is there any way to read the last cell value of a column of excel .
  • Sgar Saha
    Sgar Saha over 3 years ago in reply to Sgar Saha

    anyone have an answer for it?

    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • Viet Anh Le
    Viet Anh Le over 3 years ago in reply to Sgar Saha

    So you want to append data to existing file or you just want to read value in the last column?

    Just explain clearly what you want to do and upload the excel file here then we can have a look into that.

    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • Sgar Saha
    Sgar Saha over 3 years ago in reply to Viet Anh Le

    want to append data to an existing file

    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • Viet Anh Le
    Viet Anh Le over 3 years ago in reply to Sgar Saha

    Please upload the excel file

    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • Amandus Yngvesson
    Amandus Yngvesson 8 months ago

    Hi!

    I'm trying to extract data from the second sheet in my xlsx, but don't know how,

    anyone who has a suggestion? :)

    using namespace 'Aveva.Core.Presentation'
    !netDataSource = object NETDATASOURCE('second sheet name', 'C:\Temp\Source-Data.xlsx')

    !netGridControl = object NETGRIDCONTROL()
    !netGridControl.bindtodatasource(!netDataSource)


    -- Get data
    !data = !netGridControl.getRows()

    $p $!data[1][1]

    it might not be possible ? ....
    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
<