如何验证excel中是否存在列

Question

我在excel文件中存储了数据，我还传递了属性excelPath和工作表名称。如何使用PAF验证excel中是否存在列？

Answer 1

使用自定义标签：

###getExcelColNumber，Att1=列名称，Att2=keyNamegetExcelColNumber=com.tr.execution.activities.getExcelColNumber

<activities>
<activity id="Validate_whether_a_Column_Exists_in_an_Excel">
<getExcelColNumber columnName="Version_num" keyName="colNo" ></getExcelColNumber>
<validation valGroupIds="ValidateColumn" ></validation>
</activity>
<valGroup groupId="ValidateColumn" >
<validate variable="colNo" condition="equals" value="-1" passMsg="Pass" failMsg="Fail" snapshot="false"></validate>
</valGroup>
</activities>