使用VB脚本读取excel并遍历行 [英] Read excel and loop through the rows using VB script

问题描述

大家好，



i有一个excel类似

id状态利润

1通过1

2失败2

3通行证6

4失败4

5通行证5



现在我应该使用VB脚本读取这个并迭代行以获取所有Pass值并在状态列中添加失败值（两者之和）

how我可以用VB脚本实现这个吗

提前谢谢



我尝试了什么：



i编写了访问excel的代码如何迭代它

Hi all,

i have an excel something like
id Status Profit
1 Pass 1
2 Fail 2
3 Pass 6
4 Fail 4
5 Pass 5

now i should read this using VB script and iterate through rows to get all the Pass value added and the Fail value added (sum of both) in status column
how can i achieve this using VB script
Thanks in advance

What I have tried:

i have written the code to access the excel how to iterate through it

推荐答案

如果你在Excel中这样做，你不需要编写脚本。你可以用公式来做。

If you're doing this in Excel, you don't need to write a script. You can do it with formulas.

这篇关于使用VB脚本读取excel并遍历行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！