need help in coding LABVIEW

[Avinash.gogineni]

Hai,


 I am Avinash. I need to do one project using Labview. It is an Electronic project




1)   we need to read the ASCII data from Excel file using LABVIEW


2)    The Data contains 9 rows,  we need to draw graph between first column(time) and  8th (pressure) ,9th(pressure) columns. starting of that file       contains some unwanted data upto 23 rows So, we need to draw graph from 23th row onwards.


-> From this we will get two waveforms one is between 1st column and 8th column,  the other waveform is between 1st column and 9th column. we need to draw separate graphs for each and including both waveforms.


3) Now we have to count the number of pulses present in the waveform ; maximum and minimum values of the pulses present in the waveform.


4)The data is practical one. So, using filters we have to make that as normal waveform. we need both formats before modification and after modification ( which we modified using filters)


5)Completing the above task, At the end, If we keep the cursor on the filtered wave pulse, It should represent the maximum and minimum values of that particular pulse..




I am attaching one file with this mail, That will be an example


please reply soon to make sure of having idea about this........




Thanks ans Regards,
Avinash Gogineni.

[Mark_Yedinak]

This sounds like a homework problem. Do you have a specific LabVIEW questsion or are you looking for someone to provide you with the solution? If the latter I doubt anyone will give you a complete solution. If you have specific questions post what you have done so far and let us know what you need help with.

[Yamaeda]

To read a .xlsx you'll need to use an ActiveX object. You can use Invoke Node to read the file and get the values.

/Y

[Avinash.gogineni]

Hey Mark I worked on that... but i am unable to find the solution.. here is my attaches file please see dat

[Yamaeda]

Read from spreadsheet file only reads text/ascii files, .xlsx is basically zipped xml (as i've understood it) thus you need to use an ActiveX control to use Excels functions.

/Y

[RavensFan]

Read the links in this search.  http://forums.ni.com/ni/search?submitted=true&type=message&sort_by=score&q=Write+to+Spreadsheet+File...

I know it would be hard to find since this question has been only asked perhaps two times before.

For anyone following along, let's try to boost up the kudoes count on this idea Rename Read and Write Spreadsheet file.

Message Edited by Ravens Fan on 03-05-2010 04:58 PM

[Avinash.gogineni]

Heyy Actually I am trying to read my file using spread sheet, It's doing right job but The axis are interchanging. Time is showing in Y axis

[RavensFan]

---

Avinash.gogineni wrote:
Heyy Actually I am trying to read my file using spread sheet, It's doing right job but The axis are interchanging. Time is showing in Y axis

---

No.  I am sure Read from Spreadsheet file is not working with an .xlsx file.

[Joe_H]

The read and write spreadsheet file vi will not work on excel files. To work with excel files you need to use ActiveX.

For more information and some sample VI's and tool kits, you can go to the excel board

[Avinash.gogineni]

How to use ActiveX??