在机器人框架中，我如何在excel中得到循环中每个值的总和?

Question

在机器人框架中，如何获得excel内循环中每个值的总和?
示例:
单元格4是25
单元格5是23
单元格6是21

在循环中获取值的示例代码(还没有求和):

${maxRows}  Get Row Count  ${FEEDBACK_TRANSACTION_SHEETNAME}
FOR    ${i1}    IN RANGE    11  ${maxRows}
${TOTAL_AMOUNT}  Read Cell Data By Coordinates  ${FEEDBACK_TRANSACTION_SHEETNAME}  4  ${i1}
Set Suite Variable  ${TOTAL_AMOUNT}
Exit For Loop If  ${i1} == ${maxRows} 
END

Answer 1

您几乎就完成了—只需将当前单元格与累加器变量相加即可。说${TOTAL_AMOUNT}可以达到这个目的:

${maxRows}=  Get Row Count  ${FEEDBACK_TRANSACTION_SHEETNAME}
${TOTAL_AMOUNT}=    Set Variable    ${0}
FOR    ${i1}    IN RANGE    11  ${maxRows}
${current value}=  Read Cell Data By Coordinates  ${FEEDBACK_TRANSACTION_SHEETNAME}  4  ${i1}
${current value}=  Convert To Integer    ${current value}
${TOTAL_AMOUNT}=   Evaluate    ${TOTAL_AMOUNT} + ${current value}
Exit For Loop If  ${i1} == ${maxRows} - 4
END
Set Suite Variable  ${TOTAL_AMOUNT}