在机器人框架中，如何得到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}