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