ReadValueFromExcel

TwinCAT TIA
Lokal Datei- und Ordner-Zugriff Excel

ns=2;s=DEPRAG Smart/Local/FileAndDirectoryAccess/Excel/ReadValueFromExcel

Der Befehl liest einen Inhalt aus einer Zelle des angegebenen Exceltabellenblatts in einem angegebenen Pfad aus.

Parameters:

    FileFullPath
    Path of the file. The file can be either a local file or a file stored on a network drive.

Returns:

Examples:

In addition to the parameters already explained, the following variables must be created / transferred for the implementation in TwinCAT 3:

Beckhoff parameter:

    bExcelReadValueFromExcel
    A boolean variable that can be used to trigger the execution of the ReadValueFromExcel command.
    OutputDataReadValueFromExcel
    An instance of "ST_StringOutputData" in which the return value of the ReadValueFromExcel method is written.
    hrExcelReadValueFromExcel
    This can be used to monitor the execution of the command. Error codes have the type "HRESULT".
    fbExcel
    An instance of the "FB_Excel" function block supplied with the DEPRAG Smart library.
    sFileFullPath
    A STRING variable containing the full path of the Excel file.
    sWorksheetName
    A STRING variable containing the name of the Excel worksheet.
    nRowNumber
    A DINT variable containing the row index.
    nColumnNumber
    A DINT variable containing the column index.
    ConnectionHandle
    "ConnectionHandle" received when establishing a connection between DEPRAG Smart Server and your OPC UA client.


VAR
     bExcelReadValueFromExcel    : BOOL;
     OutputDataReadValueFromExcel   : ST_StringOutputData;
     hrExcelReadValueFromExcel    : HRESULT; 

     fbExcel : FB_Excel;
END_VAR

hrExcelReadValueFromExcel := fbExcel.ReadValueFromExcel(
          bExecute    := bExcelReadValueFromExcel,   
          ConnectionHandle := depragSmartConnection.ConnectionHandle, 
          sFileFullPath  := 'C:\Test\TestFile.xlsx',
          sWorksheetName  := 'Testsheet',
          nRowNumber   := 1,
          nColumnNumber  := 1,
          OutputData   => OutputDataReadValueFromExcel);
IF hrExcelReadValueFromExcel <> S_FALSE THEN 
     bExcelReadValueFromExcel := FALSE;
END_IF
                                                    

For examples and explanations regarding the calls of nodes via Siemens TIA Portal please refer to the sub-menu "Siemens TIA Portal" in section "Getting Started".