CONNECT Edition 10.11.++
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.
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.
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