Skip Row in Excel Automation

Question

0.00/5 (No votes)

See more:

HI,

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?

Posted 24-Jan-12 18:50pm

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Idle_Force · Accepted Answer · 2012-01-24T19:08:00

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

VB

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.

Posted 24-Jan-12 19:08pm

Comments

Alan Tuscano 25-Jan-12 1:27am

Thank you Idle_Force,

How can i hide a column? I need that column for grouping but don't want it displayed in the excel output