[Solved] Storing ~3000 numbers prior to excel graph creation

[Kyan]

Hi

I never had to do this, my ISP in the last trimester force me to downgrade my internet speed due to high deman on my area (new homes coming to the grid), and my line max speed changes on hour to hour basis, so I'm going to register in every 15min my wan speed for a month or two.

The problem is, can I store it right a way to a excel file or it should be done in other way?
Just asking this to avoid crashes in the middle of the data gathering 

Edited May 11, 2015 by Kyan

[SadBunny]

I don't understand... What do you want to store exactly?

[water]

The Excel UDF that comes with AutoIt should do what you want.

[Kyan]

@water, 3k lines are okay for it? I know for sql 3k lines aren't anything, but for excel I'm sceptical xD

I was going to use this code to add the lines to the bottom of the xls file https://www.autoitscript.com/forum/topic/126570-insert-row-into-excel/

EDIT: @SadBunny, add lines to a excel file for 1-2months which is 2880-5760lines

Edited May 11, 2015 by Kyan

[water]

That's with the old Excel UDF. This version inserted the data cell by cell.
The rewritten Excel UDF takes the array and writes it in one go to Excel. That's about 20 to 100 times faster.

[Kyan]

Neat

So Excel udf is the way to go, thanks water

[water]

Correct
Good luck. If you have any questions, don't hesitate to post.