skip rows in excel

[jackofalltradesmasterofnone]

Hello.I am currently writing a program that reads from an excel file to perform a calculation. I just want to know if it is possible to read odd or even rows only (for example row 2, 4, 6,....) and how do i implement it?

[MikeS81]

Hi jackofall...,

i think it is faster if you read the whole range you need and filter odd or even in your vi.

Mike

[jackofalltradesmasterofnone]

can you show me an example on how to execute that?

[MikeS81]

Hi jackofall...,

which part do you need, to read the data with ActiveX into LV or to get only the odd or even values from the received data?

Mike

[jackofalltradesmasterofnone]

I have done the part where the program reads the spreadsheet using ActiveX. It stores the spreadsheet as a 2d array(there are only 2 columns). Now i want to read just the odd or even rows and i hope i can get some assistance on that.

[MikeS81]

Hi jackofall...,

here is an example for you.

Mike