LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Writing and updating data to EXCEL........!!

Solved!
Go to solution

 

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.......

'' A professional is someone who can do his best work when he doesn't feel like it''...........
0 Kudos
Message 1 of 12
(3,521 Views)

Can you show your VI. Normally new data gets appended to bottom.

0 Kudos
Message 2 of 12
(3,506 Views)

Sure..!!

 

Here it is...!!

'' A professional is someone who can do his best work when he doesn't feel like it''...........
0 Kudos
Message 3 of 12
(3,495 Views)

First collect the five values and then dump into excel.

0 Kudos
Message 4 of 12
(3,483 Views)

That is actually better solution, For updating read previous value and write new values

--------------------------------------------------------------------------------------------------------
Kudos are always welcome if you got solution to some extent.

I need my difficulties because they are necessary to enjoy my success.
--Ranjeet
0 Kudos
Message 5 of 12
(3,479 Views)

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.

'' A professional is someone who can do his best work when he doesn't feel like it''...........
0 Kudos
Message 6 of 12
(3,464 Views)

Hi MSony,

 

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…

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
0 Kudos
Message 7 of 12
(3,444 Views)
Thanks for ur response..!!

Can you please upload any VI as per my application or can you correct my VI which i hav uploaded...!
My application is to update values one after the other in excel...
Problem raised here is first value is.moving down and so on.......!!
'' A professional is someone who can do his best work when he doesn't feel like it''...........
0 Kudos
Message 8 of 12
(3,431 Views)

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…

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
0 Kudos
Message 9 of 12
(3,428 Views)
I have replaced build array but i got the same problem.....

Anyways i will try further and let u know.....thank you for ur solution...!!
'' A professional is someone who can do his best work when he doesn't feel like it''...........
0 Kudos
Message 10 of 12
(3,413 Views)