08-09-2014 02:09 AM
Hi everyone...!!
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.
08-09-2014 02:31 AM
Can you show your VI. Normally new data gets appended to bottom.
08-09-2014 03:06 AM
Sure..!!
Here it is...!!
08-09-2014 03:29 AM
First collect the five values and then dump into excel.
08-09-2014 03:33 AM
That is actually better solution, For updating read previous value and write new values
08-09-2014 04:45 AM
Okay......!!
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.
08-09-2014 06:34 AM
08-09-2014 07:41 AM
08-09-2014 07:43 AM - edited 08-09-2014 07:46 AM
Hi Msony,
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…
08-09-2014 08:18 AM