excelvbscriptwincc

Get data from Excel with VBS

I have an Excel file like this :

Excel data

This file can have more than two group. In VBScript (for Siemens WinCC) I want to collect data by group (one visual array). With object and recordset I can browse all the file but how can I get only number value by name?

What I want is for exemple:

Get PLTTZF, 1.043, 0, 1.5, 1.043 where Name=FORME 1.5/1 PLAN42

I've tried with a query like this:

StrSQL = "SELECT [F4] FROM [01$] where [F2]='FORME 1.5/1 PLAN42'"

But it return no value because the name is only written on one cell.

Do you have a solution?

Solution

  • Resolved by using other driver.