Write To Spread Sheet with nested for loop

[cheyne]

Hi ,

I have a 3 nested loop running and how could I save all the data to excel file at the end of the day?

Please advice.

Thanks




Message Edited by Support on 06-12-2008 08:30 AM

[altenbach]

It does not really matter how many loops you have stacked, but how you accumulate the data.

Do you simply have a 2D array or something more complicated? How much data?

For long term data accumulation, I would append the new data to a file at regular intervals. It is not save to keep one day's worth of data in memory.

[cheyne]

Hi,

Please find the attached file. How could I save all the data in 1 file at the end of the day. By any means like append or what.

Thanks

[altenbach]

You are not showing how you want the data arranged. There are near infinite ways to arrange the data with your given code.

[cheyne]

Hi,

Any arrangement will do. Please provide me an example that you would arrange your data at your own way.

thanks

[GerdW]

Hi cheyne,

I doubt "any arrangement will do"! It's very crucial to put data in correct order... And one should know (or: define) data structures before actual programming!

Anyway: Here's a quick&dirty example putting all data in "random" order...



Message Edited by GerdW on 06-12-2008 10:08 AM

[altenbach]

Here's a completely different solution. It really depends on what you want.

Message Edited by altenbach on 06-12-2008 01:23 AM

[cheyne]

Hi,

How if I want to have the data in new row whenever the innest loop finish.

How i could do that? Please advice.

[altenbach]

---

cheyne wrote:
How if I want to have the data in new row whenever the innest loop finish.

---

That's what my example does. It will repeat the values for the slower outer loops, but will create a new row for each iteration of the inner loop. Try it!

[cheyne]

Thank bro. 🙂