I am trying to get data from excel into processbook can i do that?
Here's a KB Article on how to plot data from an Excel spreadsheet into PI ProcessBook. Is this the sort of thing you're looking for?
Hope that helps!
Depending on what you are looking to accomplish you can use the GetObject Function. Below is the brief description from the helpfile provided with PI Processbook. There is also a detailed example that demonstrates how to bring the excel file in and access the information within. I used this particular method to bring an excel sheet with a seriest of PITags to create a Value objects and a custom table.
Returns a reference to an object provided by an ActiveX component.
GetObject([pathname] [, class])
I can provide more detail if this is something you might want to do. Hope this helps.
Retrieving data ...