07-15-2005 08:37 AM
07-15-2005 08:40 AM
07-15-2005 08:45 AM
07-15-2005 11:23 AM
There is no single right answer to your question, because we don't know what kind of data you want in your spreadsheet.
If you disable indexing as suggested above. you'll only get data out once all loops have finished, and you only get the last bit of data generated during the last iteration of each loop.
If you want to append all data to your file as it is generated in the innermost loop, you would need to place your file write operation right there inside all the loops.
If you like, please attach your code and we can figure out the best solution. 🙂
07-15-2005 12:16 PM
07-15-2005 02:48 PM
07-15-2005 04:48 PM - edited 07-15-2005 04:48 PM
(Please don't attach any 4MB bmp files! even MSpaint can save it as gif or png which would cut the size down to a few hundred kb or less. Not everybody has a highspeed internet connection!)
The innermost loop is a while loop and from what I can tell, it does not generate any data. Thus I am assuming the inner FOR loop.
Easiest would probably be to initialize an empty array on the left and feed it via shift registers across all the FOR loops. In the inner FOR loop, use built array to append the data as you go. At the end, write to file.
Just to clarify, do you want to (1) write your data to a plain spreadheet file of do you want to (2) write in in the proprietary Microsoft excel format? Case (2) is a bit more complex.
Message Edited by altenbach on 07-15-2005 02:52 PM
07-20-2005 10:59 AM
I further need help for writing data to the excel sheet. I am planning to run three different "casees" and then collect all of the data from 3 cases and store them finally in a excel sheet. But what is happening is that as soon as the case changes the program loses the data from old cases and the data only from last case is been written to the excel.
The possible solution is to drag the "file writing" code with the case loop. But the thing is, I am not able to write data to same excel sheet. I am using the VIs that are available in report generation slot.
07-20-2005 11:12 AM
07-21-2005 10:36 AM - edited 07-21-2005 10:36 AM
Message Edited by altenbach on 07-21-2005 08:37 AM