10-01-2009 10:45 PM
hi all, i am having an application where i am reading data from an excel sheet. in my case i am taking the date as an input from the user in range i.e starting date and end date in dd-mm-yy format( or to to from)and then i have to read the data of all dates which come between given range by the user....
how can i do it????
can anyone help......
thanks in advance.........
10-01-2009 10:51 PM
Have you tried the in range and coerce.vi
10-01-2009 11:07 PM
10-01-2009 11:10 PM
10-01-2009 11:14 PM
Try this.
You will have to modify this program if month is different in "To" and "From" Controls.It will not work for that.
10-03-2009 05:39 AM
thanks for the vi....
but what i intend to do is i want to get date range from user and then i want to read the data corresponding to that date range from excel sheet by comparing it with the date colomn in excel...
by problem is how should i seperate datre,month,year from the combined format and how to again comapre it with the date in excel column.......
can any1 tell me how to do that............
05-21-2015 03:03 PM
Did you get the solution for your question ?
I have the same requirement,
1. Here, the user will provide the range like maximum and minimum values, then the VI should capture the data within the given range. ( from CSV file as attached )
2. Then VI should calcluate the average value for captured data and export it to excel.
This is my requirement can anyone help me on this.
Many thanks in advance
rc_cks
05-22-2015 08:26 AM
I would suggest that you start a new Thread, rather than hijacking this one. Your problem is different, your data set is different, and your needs are different.
When you do pose your problem, please clarify if you are looking for a solution that uses Excel (which implies working with Excel files, .xls and .xlsx, as well, possibly, as .csv) or with text files that follow the .csv format. Do post the code that you are developing, and explain where you are having problems.
Note that this is not a place to hire LabVIEW coders to do your work for you, but a place to come for sharing knowledge/experience and getting help with solving your own problems.
Bob Schor