LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

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

Solved!
Go to solution
Highlighted

 

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
(1,103 Views)
Highlighted

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

0 Kudos
Message 2 of 12
(1,088 Views)
Highlighted

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
(1,077 Views)
Highlighted

First collect the five values and then dump into excel.

0 Kudos
Message 4 of 12
(1,065 Views)
Highlighted

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
(1,061 Views)
Highlighted

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
(1,046 Views)
Highlighted

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 LV2011SP1 + LV2017 (+LV2019 sometimes) on Win10+cRIO
0 Kudos
Message 7 of 12
(1,026 Views)
Highlighted
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
(1,013 Views)
Highlighted

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 LV2011SP1 + LV2017 (+LV2019 sometimes) on Win10+cRIO
0 Kudos
Message 9 of 12
(1,010 Views)
Highlighted
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
(995 Views)