Background

In OpenPlant Modeler CE, for an Excel query all the steps are the same except for the query statement. In Excel, you have to define the query in a way that Excel understands it and can access data from the sheets. "Data" as defined in the example below is the sheet name.

Steps to Accomplish

1. In the SQL Select Statement field enter the following sample query: Select [Data$].VALUE,[Data$].DESCRIPT from [Data$] Where [Data$].VAR='ITYP'
   
   OR, for a more detailed query the statement below searches for the value from a specific (SERVICE) column in the database:

   Select [Data$].VALUE,[Data$].DESCRIPT from [Data$] Where [Data$].VAR='ITYP' and [Data$].SERVICE = '<SERVICE>'
   
   

   
   To setup your data in the excel sheet you have to make put data into a table.

2. Paste the data columns into a new excel sheet and then select all the data along with the Header and select Format as Table option from the "Home" Task Bar.
   
   
   
3. Rename the sheet to Data.
   
   
   The Excel database can now be queried using the query described above.
   

See Also

Still a Problem?

If above problem still persists, then please create a Service Request and contact the Bentley Product Advantage group.  Please include a list of all relevant details to get in depth analysis for a solution or workaround