how to get values from an exel sheet to a global variable

[Ansu2012]

Hallo all,

I am a beginner in LabVIEW and I have  a problem in reading datas from an exel file . I would like to import a group of data with timestamps from exel file to a global variable. for ex. speed, acceleration and position of 4 different sensors to each of its global variable.

It will be very nice if anyone can give me some ideas.

Thanking you in advance

[Ansu2012]

Hallo all,

I am a beginner in LabVIEW and I have  a problem in reading datas from an exel file . I would like to import a group of data with timestamps from exel file to a global variable. for ex. speed, acceleration and position of 4 different sensors to each of its global variable.

It will be very nice if anyone can give me some ideas.

Thanking you in advance

[nyc_(is_out_of_here)]

There are examples that are included with LabVIEW on how to read/write from Excel.

[.aCe.]

Novel Idea: Perform a search!

Spoiler

Google!

[Mark_Yedinak]

You should consider some other means of sharing your data other than global variables. LabVIEW is a data flow language and if you are not careful you can up with race conditions when using variables. Searching the forums fors "variable" should provide lots of discussion about their pit falls and describe alternative methods for sharing data.

[Joe_H]

Look at the excel board for more examples of reading ir writing to and from excel

[Ansu2012]

Thank you all 🙂

I had made a search already and then thought of posting the question. I am really sorry if u all felt mine is a stupid problem.

If I am not using a global variable, then how can I update my input when the program is running?

I used 'read from spreadsheet' option to extract data. but its not working if i am giving a block of data for a single parameter(eg.accleration) with timestamps 😞

[Dennis_Knutson]

In order for Read From Spreadsheet to work, you would need to save the Excel file as text. Either comma or tab separated data. To read native Excel files, you must use ActiveX. The mentioned Excel Board is here. There are numerous examples there. Do NOT post questions to it.

Since you have not posted any code, it is impossible to say how you could eliminate globals.