Grv Chy

On 7/2/2020 at 4:56 PM, crossrulz said:

CSV is a text file.  So why are you stuck with Excel?  It will not do what you want.  What's wrong with making another viewer?  Push back on this requirement to figure out what the real goal is.

Hello crossrulz,

The actual target is to see each data in .csv Format but i am not able to find real time update in .csv , when LabVIEW send a data in each Minute, it should be also updated in csv while it is opened. I Need to monitor each data send from LabVIEW while csv is receiving it. I am not able Keep open csv file and monitor while it is receiving data from LV.

4 hours ago, Gribo said:

Type object is in the System namespace. Click .NET connectivity -> Invoke node -> Select class -> System -> Type -> Missing

Great man it is working… Now i just Need to find out how can i write random number continously in each row and column in each 500 ms.

22 hours ago, Gribo said:

Here you go. 

This is not a production code. You will have to close references when you are done with a specific object.

2 things to note:

1. Excel, like VB is 1 based. 1st index is 1.

2. Don't leave an empty property node input. Wire a 'missing' type to any gray (optional) input that you don't use.

Thank you Gribo. I have attached my VI. But i got 2 Problem: 1. I was not able to insert property node "Type" > "missing". 2. I get error from my Invoke node "Add". Do you ha ve any idea??

csv_update.vi

1 hour ago, crossrulz said:

Bryan's suggestion is by far the simplest method.  The other route would be to have the two applications communicate over TCP/IP.

hello Crossrulz, can you please elaborate it a simple example please.. 

1 hour ago, Bryan said:

Are you meaning a *.txt file generated from a LabVIEW program saved onto a remote PC?  You should be able to set up a shared folder with appropriate permissions on your remote PC and have LabVIEW save the file to the share.  I won't get into the details since there's gobs of info on the internet on how to set up shares. 

Once it's set up, you can just have your LabVIEW program point to the path of the shared folder.  For example: If your remote PC name is "REMOTEHOST", you name the shared directory as "LabVIEWDATA", and your text file name is going to be "TestData.txt", the file path for your text file would be (on a Windows machine): "\\REMOTEHOST\LabVIEWDATA\TestData.txt".  You can optionally replace the "REMOTEHOST" with the IP address of the remote machine, but if it's a DHCP assigned address, it could change on you in the future. 

Thank you Bryan for your suggetion. Do you know any example of sharing data with external PC connected via LAN cable. I am not able to figure out how to share data and save my .csv file directly in a external PC(containing no LabVIEW). I would be very thankful.

Hello Everyone,

I need to save or send my LabVIEW file from my PC (which contain LabVIEW) to a external PC without LabVIEW program. Is there anyone who has done that. what are the way to send or save LabVIEW .txt file to the external PC. Both PC are connected via USB Cable or LAN Cable.

On 7/2/2020 at 6:01 PM, Gribo said:

You should use the Excel .NET API. You will see your data as it is added to the spreadsheet. 

Also, you can do this with OpenOffice/LibreOffice if you don't want to pay for Excel.

Hello Gribo, do you somthing like code or exmple, where i can see my data in real time. It will be very helpful for me.

On 7/2/2020 at 6:38 PM, jacobson said:

I agree that you should probably push back a bit on the requirements.

If you want to get real weird with it, I've worked with a group that did all of their hardware interaction in LabVIEW, built that code into a DLL and then called it from an excel macro that was continuously running.

Hello Jacobson, Can you please help me to get this DLL  and use it LabVIEw, may be you have that code.

Thank you for the explanation... but for me i must write the data in excel(.csv) and same time able watch the data update like i do in labview....

Thank you for the suggestion, Can you please elaborate it . If possible LV program, where you used this UE. 

Hello Bryan,

However, If you already have Excel open to view the CSV file, I don't believe that Excel will automatically update your spreadsheet contents every time the file changes if that is what you're trying to do. I haven't tried that myself.

--->>>>> yes i am trying to keep ma excel sheet open while data  are updating in real time, which i receive per second from LabVIEW.

Yes, Mefistotelis . I want to see each data , which ar send to excel in real time in the excel sheet.

Hello ,

I am trying to Export data from LabVIEW to an Excel file(.csv) in real time. I Need to see the data in a real time , which are written in the Excel without Closing the Excel. my Problem is i can see the real time data writting in LabVIEW . But in Excel i can see the data only after stoping my LV program. Is there any way to watch real time data writting in each column the Excel. I have attached my LV program.

Write_CSV_date_time.vi