在Excel Automation中跳过行 [英] Skip Row in Excel Automation

问题描述

HI，

我的数据集中有75条记录，并分为3个.

在Excel中插入前25条记录后，如何在excel中跳过一行?

I have 75 records in my dataset and is group into 3.

after Inserting the first 25 records in Excel, how can I skip a row in excel?

推荐答案

如果它与查找循环迭代一样简单，则: >

If it as simple as looking for the loop iteration then:

For i As Integer = 0 To <range>
  If i = 25 Then Continue For 'do not process this row
  'otherwise keep processing
Next</range>

否则，请使用随每次迭代增加的变量.

Otherwise use a variable that you increment with each iteration.

这篇关于在Excel Automation中跳过行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！