Row read

anyone have an answer for it?

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.

want to append data to an existing file

Please upload the excel file

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 ? ....