Hi All,
i create an XY plot in order to plot data from excel odbc. As the PI lock the excel and not allowed to update data (read only), I am thinking for a tips to delete the tag in xy plot and delete the dataset then update my excel then create dataset and add tag in plot XY.
by the way, i have tried manually to delete the tag from xy plot then delete the dataset, the excel got unlock, so looking to do it in vba automatically.
Regards
Madjid
How about using AF Table Link to read Excel contents instead of excel odbc?
Is there a way to publish tables from excel straight to PI system explorer instead of having to make them in PI?
https://livelibrary.osisoft.com/LiveLibrary/content/en/server-v9/GUID-619C062E-D4B3-4B66-A16F-672CF816584A
I checked my machine and AF Table Link does not lock the Excel Sheet.
So you can use AF Link Table to get the Excel's data. Also you can edit the Excel contents by opening Excel.
Using "Table provided time series data" option, Table Lookup attribute can returns time series data.
https://livelibrary.osisoft.com/LiveLibrary/content/en/server-v9/GUID-C876C146-1906-4C05-83BE-904E285CE915
Does it work for you?