MS Office Report Express VI and Array Problem

[Ange.26]

Hello! 

I'm working in a proyect. Where they form an Array in 2D with data in X and Y (see picture). I need that for each iteration, the data being stored in a MS Office Report in Custom excel. But this doesn't occur, only keep latest data of latest iteration. 

Sorry for my English. 

Thanks....

[Wild_man]

A couple of suggestions,

1. This is a very old thread, you may have better luck posting in a new thread

2. Attaching your code will allow members to see your whole application and view configuration settings rather than just seeing a static screenshot.

3. You might try to run and examine the example code (Help>Find Examples>Search Tab>excel>"Excel Report - Generate from Template.vi

[Ange.26]

the problem is ¿Why insert previous data? and for finally all data saved...I made a program type for model the specific problem... 

look this VI...

Thank you for you answer 🙂

[WillyWad]

After each iteration, you want the array that you generate to be saved to an Excel file. Am I understanding this correctly?

To do this properly, you will want to rearrange how your for loops are set up. The way you have it set up right now, you generate a 3x4 array. Then this is overwritten by another 3x4 array before it is saved to Excel. Try running your code with Highlight Execution on and you will see what I am referring to.

Hope this helps!

-Will

[Ange.26]

exactly, I'm trying save all data of each iteration in a custom excel but olny saved latest iteration

I understand that the data saved but i need that all data in diferent position of the excel.

[WillyWad]

The best way to do this would be to get rid of your outside for loop, the loop that iterates twice. This loop iterating twice is what causes you to overwrite your first 3x4 array before it is written. If you use only the inner for loop, the 3x4 array is written to the file as soon as it is created. I think this is what you are going for. 

-Will