ns=2;s=DEPRAG Smart/Local/FileAndDirectoryAccess/Excel/ReadValueFromExcel
The command reads a value from a cell of the specified Excel worksheet in a specified path.
In addition to the parameters already explained, the following variables must be created / transferred for the implementation in TwinCAT 3:
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".