I think this is a simple problem but am not getting idea of that..!!
Here am with a problem appending data to excel from top to bottom.
I have a data (string) which should be updated in excel from top to bottom format.
Suppose, for example i have total 5 values to be updated, first value will be updated in regular method and the second data which appends to that sheet must be exactly at the bottom of the first data.
But here the problem is when i enter the second data it is placed above the first data in the sheet,,,!!
Updating format : 5 4 3 2 1........
My format should be : 1 2 3 4 5.......
Solved! Go to Solution.
Here it is...!!
That is actually better solution, For updating read previous value and write new values
But its not the matter of 5 values here...data consists nearly 24000 values which should be updated one after the other.
I tried with all excel specific VIs but i couldnt get my solution..
Can anyone send me a example VI for that as u said reading and updating data.
don't use InsertIntoArray when you want BuildArray…
data consists nearly 24000 values which should be updated one after the other.
You surely don't want to update an Excel spreadsheet several thousand times…
Problem raised here is first value is.moving down and so on.......!!
Replace InsertIntoArray with BuildArray, as said before.
Only write new values to Excel instead of the whole array…
Don't insert "entire rows" when you want to append data at the bottom…