how to create test report in the next row?

[Sumithra_Nagappan]

Hai

    I am working on a Labview 10.0 application that runs tests the horn board. Every time a test runs the results are written to an excel spreadsheet starting at row  in an Excel worksheet. For example, test 1 results go on Row 14, test 2 Row 19, etc. ..

 

I am successfully writing my test data to Row 14. But when I run the second test, the data over-writes the firt row of cells . So, I need to insert a new row on Row 15 instead of over-writing the Row. I have searched the examples and forums and although I found where a user asked the same question, they did not get a valid answer..

[ABCPrograms]

There are several ways to do this, but all depends on how you are handling this.  Can you post your VI in here so we can have a look at it.  That way we can give you the best advice in your specific case.

[Sumithra_Nagappan]

posting the vi is highly impossible..sorry

[Sumithra_Nagappan]

suggest some ideas..in my app nearly 8 test is to done and and the test value obtained during each test is written using report generation tool kit..i want to create report for n number of samples sequentially in the same report..

[ABCPrograms]

ok, let's try something.

I suppose that you're writing a 1D array to Excel.  But how do you determine where to write that row to?  I suppose that you're giving the address.

What you could do is put the rownumber you're writing to in a shift register.

Next time you want to write your 1d array to excel, get the previous row from the shift register, add 1 and use that address to write to.

Does this make sense to you?

If you're writing a 2D array, then you should write the last row index into the shift register of coarse 😉

[ABCPrograms · Accepted solution]

Here is an example I programmed really fast to let you see how it can be done.

[Sumithra_Nagappan]

Thanks for ABC programs..i hope i will fix the problem...

[Sumithra_Nagappan]

May i know how the shift register defaultly statrs in the 9th row?

[Sumithra_Nagappan]

oh sorry i got that...

[ABCPrograms]

it's just a number.  In my example I want the report to start in row 10.  And since I'm adding 1 to the last row I initialised the shift register with 9. 

If you want it to start in the 1st row, you can just change it into 0.

It was just an example