increment a value to be used in a string

[Dowden1]

Hello,

I am using a program to look at a cell in a spreadsheet, I have got this bit working fine, however on each loop I need it to change the cell I have picked e.g original cell = C3 next Cell = C4 snd so in for an undefined number of rows. The coloumn will always be the same so for this example it will always be C

Is there any way of doing this?

[Norbert_B]

Quick and dirty solution:

 

Norbert

Message Edited by Norbert B on 08-22-2008 07:46 AM

[MikeS81]

Hi Dowden1,

it sounds like you read your data from excel. In this case i recommend to read ones all values from this column and check the single elements in LabVIEW. It would be much faster.

Hope it helps.

Mike

Message Edited by MikeS81 on 08-22-2008 02:52 PM

[Dowden1]

Hi Mike,

I am using an activeX control for excel, I tried to make it read all of the rows in the coloumn but for some reason I kept getting an error message when I tried it

any ideas?

Thanks

[MikeS81 · Accepted solution]

Hi Dowden1,

which function do you use? Normally it should be no problem to read a range. The first row is number 1. The attached picture shows how you can read a range. In your case you should connect "C1" to Cell1 and "C?" to Cell2.

Mike

Message Edited by MikeS81 on 08-22-2008 03:12 PM

[Dowden1]

Thank you this has now solved my problem!