How to copy data from an excel file to an system window

[nk0435]

Hi

I just want to copy the data from an excel file to an active system window, for example I have details of some persons contains their names,designations,age and some other details in an excel sheet, now my requirement is to copy all these data into a system window like IRCTC browser etc.please provide any suggestions...?

Thanks in advance.

[AG@Amfax]

Hey nk,

Have you tried using the read from spreadsheet vi? Looks like the snippet below. If you want something a bit more tailored to your needs you can use the read text file vi's and do some string manipulation. I would try with the function I have posted below first, and see how you get on. If you are struggling to find it or the read from text file functions they are located in the programming pallet under file I/O.

[nk0435]

Hi,

thanx for your reply, but my requirement is copy the entire data from Excel or notepad to a system window like any tab browse by internetexplorer. I mean i just want to copy the data in to a internet external window like IRCTC window but not in to labview frontpannel. Please suggest me for doing like that.

Thanks in advance.

[AG@Amfax]

Hi nk,

You could read the data into labview and convert into XML and store in a database, you could then access the database through your webpage... This forum is used to for labview support, if your not using LabVIEW then I think you've come to the wrong place.

[nk0435]

Hi,

Iam using LabVIEW 8.5 for developing my application and iam getting data from my excel to labview frontpannel and iam storing that data into a global variable, now i want to copy that data in to some other window which was opened through LabVIEW systemexe function. As per your suggestion now iam trying with Databases. I ll come back when iam facing any troubles in that.

Tahnks for your suggestion.

[AG@Amfax]

Hey Nk,

Sorry I was a bit confused as to what you were trying to do with your last post, so basically you are trying to port your data from labview into another application which is also run in labview? Why not try then transferring the data to the other application via TCP/IP try this link.

[Akiel]

have you any code you have tried if so could you post it plse? I assume your data is in excel native not csv so I dont think read spreadsheet.vi will work. If you search the examples on the website there are some good examples of using the excel activex. Not sure on passing the data back out to explorer but i would assume similar methods could be employed.

Hopeit gets you started