Creating 1D array from the values of excel file

[tnitin809]

Hi i am new to labview and i needed help to create a VI. I have a excel sheet which contains n values in the rows.i want to use the data to create 1d array and perform a number of operations such as standard deviation and variance for the first 20 numbers ,mean and mode values of next 20 numbers and if  mean value is greater than 5 light up an LED indicator .

Thanks for the help in advance

[edjones93]

Hello,

To get started, you can read excel data as given in the below link:

http://digital.ni.com/public.nsf/allkb/99F61B6AB9CD6AFA8625734600814D6B

However if it must remain in .xlsx format you would need the Report Generation Toolkit. What version of LabVIEW do you have and is this Base, Full or Professional?

Also, what hardware will you ultimately be using to perform the LED output?

Best regards,

Ed

[Bob_Schor]

---

@edjones93 wrote:

However if it must remain in .xlsx format you would need the Report Generation Toolkit. What version of LabVIEW do you have and is this Base, Full or Professional?

---

The reason for those questions is that the RGT is now included in Professional with LabVIEW 2015 and 2016, but not Base (and I'm unsure about Full).

Bob Schor

[tnitin809]

I am  an academic student and using the academic version , and i am working on the project. I wont be using any hardware and I just need guidance to work on the VI.

[edjones93]

Hello,

When you say academic student, are you a post graduate or under graduate? What university? This can clarify for me your LabVIEW versions.

As for getting started, if you're a post graduate I'd suggest to ask your supervisor to make the online training available to you, Core 1 and Core 2.

If you're an undergraduate, I would say google is your friend. We can't make your code for you but we can answer specific questions. This however should give you a good start:

https://www.ni.com/getting-started/labview-basics/

Once youre familiar with the environment, return to my previous answer and it should make more sense that you can then implement.

Best regards,

Ed

[natasftw]

Professional only Bob.  I believe the academic version is equivalent to Full? 

[edjones93]

Hello,

That depends, do we mean Academic Site License? Which would be professional:

http://www.ni.com/white-paper/8115/en/

If we mean LabVIEW Student then this is indeed equivalent to Full:

http://digital.ni.com/public.nsf/allkb/769B44838BAE129D862572E300677D02

That being said, the Report Generation Toolkit is a toolkit and therefore extends abilities LabVIEW already had rather than add additional functionality.

Although for a student project, re-creating the Report Generation Toolkit with ActiveX may be overkill, could a CSV file not be used?

Best regards,

Ed

[Bob_Schor]

If you have LabVIEW installed, open a VI, go to the Block Diagram and right-click to open the Function Palettes.  If you have an Excel Specific folder inside the Report Generation folder, then you (almost surely) have the Report Generation Toolkit.  If you don't see this folder, then you (almost surely) do not have the RGT.

Bob Schor