f



get data every 2 columns at a time in excel

i would like to read the following excel file
and plot every 2 columns at one time given an interval. for example at
7 am i ll plot corresponding I and V and at 8 am so on.. but even
though i programmed my VI to read by increasing index 0,2,4 so on it
stops when it iterates half way i.e i=12..this only plots half the
data..im reading from delimited text file..how can i read from a true
xls file and plot all the data as desired?


table.xls:
http://forums.ni.com/attachments/ni/170/318689/1/table.xls


table mode.vi:
http://forums.ni.com/attachments/ni/170/318689/2/table mode.vi
0
x9561 (148440)
4/24/2008 1:40:08 PM
comp.lang.labview 35213 articles. 1 followers. vasusachin24 (1) is leader. Post Follow

1 Replies
397 Views

Similar Articles

[PageSpeed] 32

<a href="http://forums.ni.com/ni/board/message?board.id=170&amp;view=by_date_ascending&amp;message.id=318690#M318690" target="_blank">Duplicate Post</a>
0
x9561 (148440)
4/24/2008 1:40:11 PM
Reply:

Similar Artilces:

get data every 2 columns at a time in excel #2
i would like to read the following excel file and plot every 2 columns at one time given an interval. for example at 7 am i ll plot corresponding I and V and at 8 am so on.. but even though i programmed my VI to read by increasing index 0,2,4 so on it stops when it iterates half way i.e i=12..this only plots half the data..im reading from delimited text file..how can i read from a true xls file and plot all the data as desired? table1.xls: http://forums.ni.com/attachments/ni/170/318690/1/table1.xls table mode1.vi: http://forums.ni.com/attachments/ni/170/318690/2/table mode1.vi You have a&nbsp;few problems in your code that need to be resolved first. 1.&nbsp; You posted and Excel .xls file.&nbsp; A true spreadsheet file.&nbsp; The read from spreadsheet file VI doesn't work with Excel files, it only works with text files. 2.&nbsp; Your run the loop 25 times.&nbsp; It asks for the file 25 times because the file control is inside the loop.&nbsp; Also, any loop should only run 13 times, because you have 13 pairs of columns. 3.&nbsp; You only have&nbsp;10 rows of data.&nbsp; The first couple are headers you want to ignore. 4.&nbsp; After the last iteration, you will only have the results from the last pair of columns because the array indicator and XY graph are inside the loop.&nbsp;(Though I see you have a 2000 msec wait, so you will see the results of each column pair with a 2 second pause between them.) Overall you have to...

Can't get labview to write continiously to spreadsheet, writes one column each time program is run, then appends data the next time it is run.
I am attempting to write load cell, linear transducer and time stamp to EXCEL. Due to the limited room in EXCEL I have a sample rate of 10/second. This is accomplished by setting the DAQ assistant to one sample (HW timed) in the acquisition mode of the task timer. A wait timer set at a loop rate of&nbsp;1000 millaseconds is included in the "while" loop to slow the sampling rate down. This works well. Now the data is taken outside of the loop and entered into a "build array" block and then into a "write to spreadsheet" block. This generates only one row of&...

How to read every data in the first column corresponding to the every data in the second column in the TABLE CONTROL?
Hello everyone &nbsp; like this table &nbsp; 0.0001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -4.6 0.0002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -4.3 0.0004&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -4.0 0.0006 0.0008 0.001 &nbsp; I want to get&nbsp; pairs (0.0001, -4.6) (0.0001, -4.3)&nbsp; (0.0001,&nbsp; -4.0) (0.0002,&nbsp; -4.6) (0.0002,&nbsp; -4.3) (0.0002,&nbsp; -4.0) (0.0004,&nbsp; -4.6) (0.0004,&nbsp; -4.3) (0.0004,&nbsp; -4.0)........ to control the number of loop &nbsp; so how cam get this whole pairs? &nbsp; Thank you for any help! Jing &nbsp; &nbsp; &nbsp;??????06-20-2008 09:07 AM????? different F many measurement.vi: http://forums.ni.com/attachments/ni/170/333583/1/different F many measurement.vi I'm not sure I understand. Your code already shows you autoindexing the outer for-loop so it runs for each row. And the inner loop is set to run a constant 100 times for each row, and you're indexing out each column from the specific row that is currently being executed. So what's the problem? Hi,It's not pretty but how about this?<img src="http://forums.ni.com/attachments/ni/170/333596/2/col1%20with%20every%20value%20of%20col2.PNG"> First turn your input table into a 2D array.You can then auto index every row of the outpu...

How to get the range of data from excel files with labview?
hi, i understand by using ADODB._Recordset i can get the number of columns and rows from an excel file, but its there any to get these using excel._worksheet or excel._sheet? so i can automaticly set the rang for it to read instead of setting them myself everytime i open an different excel file.Tom Wang Hi Tom, do you mean like this? With this example you can read the used range of the active sheet. <img src="http://forums.ni.com/attachments/ni/170/333106/1/Unbenannt1.PNG"> Hope it helps. MikeMessage Edited by MikeS81 on 06-19-2008 11:45 AM Unbenannt1.PNG: http://forums.ni.com/attachments/ni/170/333106/1/Unbenannt1.PNG Wow Thank you again lol... it will take me age to come something like that...where can i find all the information of all the class and models? the microsoft help does not come with much on the activeX for excel.file only ADO... You should install the VBS help for MS office. This will give direct source from LabVIEW (if I'm not mistaken) to the help. Otherwise you can browse this info from the Excel VBS editor.Ton Another thing that you can do is to create a macro in Excel and then duplicate it using properties and methods in LV. For more information and some sample VI's and tool kits, you can go to the <a href="http://forums.ni.com/ni/board/message?board.id=BreakPoint&amp;message.id=2391&amp;jump=true" target="_blank">excel board </a> thank guys i will try that... ...

Getting data from excel spreadsheet column into access table
Hi everyone... I am pulling my hair out trying to do this, and was wondering if someone could give me some assistance... I have an Excel spreadsheet containing several worksheets. I'd like to be able to take all of the data from the second column (B) of each worksheet and append that raw data to an access table. The columns in the spreadsheet do not have headers for use as field names (it's my assumption that my table should have a field named "F2")... This action needs to take place on an event - I need to be able to grab updated data out of the spreadsheet at any time (a...

Re: How to input data from Excel in a Labview table? #2
I found the error that you were having trouble with as i had the same problem.&nbsp; the author just misclicked Val(Signalling) and if you right click on the property node where it says that and just select Value it will work. ...

where to get 1GB DDR266 CAS2 2-2-2 1T timing?
Hi: Does anybody know if there are any manufacturer that makes 1GB DDR266 cas2 2-2-2 timing. I am putting together a dual xeon system that has room for four memory modules and i want to put 4GB of memory. I know you can have 512MB modules that are cas2 with 2-2-2 T1 timing, but i need more memory than just 2GB. I would really appreciate any help. thank you if you could email me i really appreciate it: pepelpue@mailcity.com what operating system will you be using? Do you need buffered/Registered or unbuffered/non-registered? ECC? how much money are you willing to spend? I have seen a lot of 1GB PC2100 DIMM's... but I have not seen ANY CL2-2-2-2. There is CL2.5-2-2-2 everywhere. NuTs "ali yousefi" <pepelpue00@earthlink.net> wrote in message news:_ZXUa.122136$Io.10434965@newsread2.prod.itd.earthlink.net... > Hi: > > Does anybody know if there are any manufacturer that makes 1GB DDR266 > cas2 2-2-2 timing. I am putting together a dual xeon system that has room > for four memory modules and i want to put 4GB of memory. I know you can > have 512MB modules that are cas2 with 2-2-2 T1 timing, but i need more > memory than just 2GB. I would really appreciate any help. > thank you > if you could email me i really appreciate it: > > pepelpue@mailcity.com > > > > > I have the iwill dp533 MB. it ...

Re: Reading Mixed data type on same column from EXCEL #2
Seems to me that mixed=yes; should do it, and you have that in your code. Can you post a specific example and show what you are getting vs. what you expect? On Tue, 21 Jun 2005 10:22:49 -0400, Yu Zhang <zhangyu05@GMAIL.COM> wrote: >Dear All, > >I have some EXCEL datafiles to import in SAS. I use the Proc Import. > >PROC IMPORT OUT= WORK.gene > DATAFILE= "c:\ENTRY FORM_HERS_092303.XLS" > DBMS=EXCEL2000 REPLACE; RANGE="HLA-A$A14:F290"; GETNAMES=YES;Mixed=yes; >RUN; > >My probelm is with the CASEID variable. it has two data types when people >enter it into EXCEL. For example: '13456' and '02345'. later one will be >treated as char type by SAS. Sometimes this coulmn is all character type, >sometimes they are mixed. Does anyone know how to read this mixed column >in character type regardless of its original type. > >Thanks! ...

Re: how to get every m observation from one data set #2
Not very elegant but does he job, I will leave it to you to refactor . Data Need ( Drop = A Cnt ) ; Set One Nobs = Nobs ; Array Var ( 3 ) Var1-Var3 ; Retain Var1 Var2 Var3 ; Cnt + 1 ; Var( Cnt ) = A ; If ( Cnt = 3 ) Or ( _N_ = Nobs ) Then Do ; Output ; Cnt = 0 ; Var1 = 0 ; Var2 = 0 ; Var3 = 0 ; End ; Run ; Proc print Data = Need ; Run ; Toby Dunn Quickly, bring me a beaker of wine, so that I may wet my mind and say something clever. Aristophanes Wise people, even though all laws were abolished, would still lead the same life. Aristophanes You should not decide until you have heard what both have to say. Aristophanes From: Ming Chen <chenming@GMAIL.COM> Reply-To: Ming Chen <chenming@GMAIL.COM> To: SAS-L@LISTSERV.UGA.EDU Subject: how to get every m observation from one data set Date: Wed, 8 Nov 2006 16:08:02 -0500 hi Here is the sample data: data one; input a; datalines; 1 2 3 4 5 6 7 8 9 10 ; Here is the data I want for every 3 obs: 1 4 7 2 5 8 3 6 9 10 0 0 I set the data to 0 if no such position. I tried to transpose first then use array. But the code is very complicated and can not deal with the irregular data. Thanks in advance. Ming _________________________________________________________________ Find a local pizza place, music store, museum and more�then map the best route! http://local.live.com?FORM=MGA001 ...

Karmic Krapware: requires 2 boots - every time
"...the bootup means that it boots up twice. I see the boot message then a ubuntu logo, some flash of text which I can't find logged (where is it?) and then it reboots again, THEN it loads. what?? Adds about twice the time for every boot up." #508 at http://ubuntuforums.org/showthread.php?t=1305924&highlight=Karmic+freeze&page=51 "Linux only needs rebooting when updating the kernel" "Ubuntu is perfect for laptops, desktops and servers" ...

Creatively importing data from Excel 2003 using Labview 8.2?
The VI I am currently writing will be used on a test station that performs automated valve tests. &nbsp; With that said, what I am trying to do is allow&nbsp;the user to configure&nbsp;their specific&nbsp;test sequence via an excel spreadsheet.&nbsp;Since multiple components will be tested, I was envisioning using&nbsp;a&nbsp;separate sheet for each&nbsp;type of valve (the various valve models require different test conditions). Ideally I would like to configure the VI in a way such that when it imports the data from excel it also reads the sheet names (which will be the names of the specific valves)&nbsp;and generates a&nbsp;selectable pull down menu within labview that, when selected, will run the appropriate test sequence (as defined by the data from the sheet). &nbsp; Just to clarify here is an example. For simplicity lets say the user wants to test two different valves, Valve-1 and Valve-2. So they generate an excel spreadsheet with two sheets, one called "Valve-1" and the other "Valve-2". Within each sheet the user inputs their test conditions (pressures, test cart component states (facility valves, flowmeters, etc.), and the corresponding times they might want these parameters to change). What I would like is for the program to prompt the user, when it is first run, to import the test config spreadsheet&nbsp;- once this happens I would like the program to generate a pull down menu with two choices&...

Re: Help reading mixed column excel-data/filtering #2
As always with the view from left field, you don't do this in SAS. You do this in Excel, .NET, VSTO, or any number of others ways and you push it to SAS. Sorry for not providing some form of code but I have touched on this subject numerous times in the past. The wrong tool is being used for the read and that is going to lead to a much more convoluted solution. A simple table: fine. But not for what is described here. Alan Alan Churchill Savian "Bridging SAS and Microsoft Technologies" www.savian.net -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.U...

Need to use labview for sorting out data in different excel/doc files #2
I have got data from data acquisition(Labview) in a report form Excel/Doc file format. For each test one report is being generated. So now i want to sort out all the data in all reports. For example : - In first excel , if the final result data as 4. - In second excel, if the result is 7 - In third&nbsp; excel, if the result is 9 - Like wise i need to analyse N number of reports with corresponding data. - we actually have the benchmarking value, where we need to see which of the report data are within the spec. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; So to <a href="http://forums.ni.com/ni/board/message?board.id=170&amp;message.id=317856#M317856" target="_blank">continue here</a> ...

Re: Work on a block of data with the same value in one variable/column at one time #2
Try this: proc sort data=original; by Key SequenceNumber; run; data result(drop=SequenceNumber rename=(NewSequenceNumber = SequenceNumber)); set original; by Key; retain NewSequenceNumber 0; if first.Key or abs(lag(date2)-date1)>=30 then NewSequenceNumber = SequenceNumber; run; The idea is to create a new sequence number, then swap names with the original sequence number in the output. The new sequence number will be set to the original at the beginning of each Key group and whenever the date proximity condition does *not* hold. Otherwise the...

converting 1 column data into 2 columns
This should be an easy puzzle to solve. I have data in the following format: 1 1 2 2 2 3 4 4 6 7 7 What I want is to convert the data so that the first column shows the data, and the second number shows the number of occurrences (I'm going to feed it to gnuplot). So the converted file should look like this: 1 2 2 3 3 1 4 2 6 1 7 2 Any help would be appreciated. TIA, tropicflite tropicflite wrote: > This should be an easy puzzle to solve. I have data in the following > format: > > 1 > 1 > 2 > 2 > 2 > 3 > 4 > 4 > 6 > 7 > 7 > > What...

Is it possible to get 2-ch signals from TDS2012 oscilloscope at the same time with LabVIEW &quot;7.0&quot;?
Hi, everyone. &nbsp; I've been trying to get the signals from 2-ch of Tektronix TDS2012 oscilloscope at the same time using IVI connection with LabVIEW "7.0" I've already searched this developer zone for the answer. &nbsp; I've tried the famous example: "IviScope - Acq Dual Wfm Edge Triggered.vi" and it gave me the error message like: &nbsp; Error -1074110451 occurred at IviScope Initialize With Options.vi Possible reason(s):Driver Status:&nbsp; (Hex 0xBFFA600D) Primary Error: (Hex 0xBFFA600D) The Config Server module is not present on the system. &nbsp; I think I've installed all~ the required softwares for IVI. For example,&nbsp;ICP 2.2, IVI engine 2.0.46, and tktds1k2k ivi (instrument driver for tds2012, in fact this one is for LabVIEW "7.1"... :-P) &nbsp; TDS2012 and my computer is connected through HPIB(GPIB) and it is shown on the MAX (a GPIB instrument as well as&nbsp;an IVI hardware asset) &nbsp; I've tried GPIB connection but it gives me asynchronous signals... &nbsp; Is it possible to get 2 signals at the same time with LabVIEW 7.0(not 7.1 or higher)&nbsp;by any means? What in the earth is the "Config Server" in this case? &nbsp; I don't need to sticking to IVI and any method to&nbsp;achieve my goal will be welcome. &nbsp; Could anyone give me the hint for this problem, plz? I think your problem is that the instrument specific driver is version 7....

Re: time data into a SAS time format #2
Hi, Here is one approach: data sample; x = '12:30:23:443'; output; x = '12:30:23:443'; output; x = '12:30:23:550'; output; x = '12:30:24:137'; output; x = '12:30:23:713'; output; x = '12:30:47:663'; output; run; data result; set sample; substr(x,9,1) = '.'; tm = input(x,time12.3); format tm time12.3; put _all_; run; Hope this is helpful. Mark Terjeson Senior Programmer Analyst, IM&R Russell Investments Russell Investments Global Leaders in Multi-Manager Investing -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of souga soga Sent: Friday, November 16, 2007 7:23 AM To: SAS-L@LISTSERV.UGA.EDU Subject: time data into a SAS time format Hi, How do i read in this time data into a SAS time format: 12:30:23:443 12:30:23:443 12:30:23:550 12:30:24:137 12:30:23:713 12:30:47:663 All help is much appreciated as usual. Thanks, Sa ...

I have normalized my data between 0-2 as one of my input features has values between 0-2. so what activation function should i use to get output in range 0-2? Any suggestions?
I have input feature that can have 0,1 or 2 values. That is why i normalize= d all other data in range 0-2. Now should it is necessary to apply activati= on function on output neuron? if it is, then what activation function i sho= uld apply or how to apply to get output between range 0-2? On Wed, 4 Jun 2014 04:29:46 -0700 (PDT), Aamir Nawaz <engr.aamir09@gmail.com> wrote: >I have input feature that can have 0,1 or 2 values. That is why i normalized all other data in range 0-2. Now should it is necessary to apply activation function on output neuron? if it is, then what activa...

Best way to combine 2 columns of data into 1 column
I have a dataset that has the following columns: ID Q8 Q9 I'm trying to come up with something so that I end up with a dataset with a single column for all values of Q8 & Q9. I though proc transpose might do it but I haven't had much luck that way. What's the easiest way to combine the contents of 2 columns to make 1 column that has all values from both? Mark -- Mark Biek The Stevenson Company 8700 Westport Rd. Ste. 200 Louisville, KY 40242-3100 (502) 429-9060 ext 251 ...

Re: Moving Data from one column to another column #2
On Tue, 5 Dec 2006 18:57:09 -0500, Jake Bee <johbee@GMAIL.COM> wrote: >George, > >So far, I think this is what you're asking: > >data a; >input id1 id2; >datalines; >1 1 >2 3 >1 1 >1 1 >2 4 >2 5 >2 6 >; >run; > >data b; > set a; > if id1=2 then id1=id2; >run; > >proc print data=a; >run; > >proc print data=b; >run; > > > >Jake If I understand George correctly, it's data b; set a; if id1=2 then do; id1=id2; id2 = .; end; run; > > >On 12/5/06, George Higgins <gehigg01@gwise.louisville.edu> wrote: >> >> Hello all, >> >> I'm new to SAS syntax and I have, what I think, is a relatively basic >> question. For that, I apologize. Nonetheless, I request some assistance >> in developing syntax to move some data from one column to another column. >> Using the following data as a basic example (my dataset is very very >> large): >> >> id1 id2 >> 1 1 >> 2 3 >> 1 1 >> 1 1 >> 2 4 >> 2 5 >> 2 6 >> >> If id1 is 2 then I want to move the data from id2 into that vector. I >> know that this will require an if/then statement to remove the 2's in id1, >> but I don't know how to get the data from id2 into id1. This should leave >> those slots in id2 ...

read data from 2 excel sheets and write both into 1 excel sheet
Greetings.&nbsp; Let me explain this a bit.&nbsp; I am wondering what would be the best way to go about this. I have 2 small Excel spreadsheets.&nbsp; I want to be able to read the first 5 cells&nbsp;in the first&nbsp;row from each spreadsheet. I then want to write the data from those 2 sheets into a third different spreadsheet starting in different columns. I do not have the Excel Report set.&nbsp; I was hoping to do this with active X, but I'm not sure if this can be done. &nbsp; Thank you, bob Hi RLemo, yes it is possible. See this thread for more informations. There is also an example. http://forums.ni.com/ni/board/message?board.id=170&message.id=329136&query.id=110669#M329136Hope it helps.Mike You should peruse the <a href="http://forums.ni.com/ni/board/message?board.id=BreakPoint&amp;message.id=2391&amp;jump=true" target="_blank">Excel thread</a> for lots of examples. ...

Every comutation of math has been wrong since the beginning of time every thing #2
Every comutation of math has been wrong since the beginning of time every thing is suppost to work out that way in any infinte cobinations of computations and simulations the theory of everthing and and solving the math around all math and physics leads you to the same answer even if check and works in simulation or in a lab. You have either two things a ghoast in you machine or something beyond time that you cannot detect that efects your out come how you see the world and everything work works the way you will alwasy find it but if you never stop looking you will find a whole other world that you have just started to understand even A.I or a quantium computer would take billions of years to find it but this is a start..........start from scatch with this site and what you will find will bludder not just the mind and eye but dumb found any alien being in this universe just the spawning of life and it's effect on the universe has created so many none connected information that it would take the total life time of all beings from any universe to understand!!! there are more universe then there are infinite outcomes of infinite http://www.beyond-science.com http://groups.yahoo.com/group/quantum_ai/ ...

Every comutation of math has been wrong since the beginning of time every thing #2
Every comutation of math has been wrong since the beginning of time every thing is suppost to work out that way in any infinte cobinations of computations and simulations the theory of everthing and and solving the math around all math and physics leads you to the same answer even if check and works in simulation or in a lab. You have either two things a ghoast in you machine or something beyond time that you cannot detect that efects your out come how you see the world and everything work works the way you will alwasy find it but if you never stop looking you will find a whole other world tha...

Data from 2 columns
Hi all, I have what I hope is a simple question.... I have a table with several columns, the 2 I am concerned with at the moment are Category and Keywords. I need to search both of these columns for a word or short phrase that I get from a form. For example, the search can be 'Antiques' or 'Antique Dealers' I tried to use this SELECT name, address, city, phone FROM valley WHERE keywords OR category LIKE '%$search%' ORDER BY name LIMIT %d,%d" in several different ways but no joy. When I use that snippet of code, I will get any matches from '...

Web resources about - get data every 2 columns at a time in excel - comp.lang.labview

Politics, Political News - The Capitol Column
Covering the politics of science, technology, business, entertainment, Capitol Hill, and health.

Column vector - Wikipedia, the free encyclopedia
... unclear because it lacks inline citations . Please improve this article by introducing more precise citations. In linear algebra , a column ...

Column 8
&quot;The report of undies turning outside-in in the wash,&quot; writes Mila Yates, of Valentine (Column 8, Thursday), &quot;begs the question, ...

Jeff Passan Column About Goose Gossage Blows Hot, Cold
On Friday, Yahoo Sports baseball writer Jeff Passan led off his column with the following paragraph: Goose Gossage , a giant bag of gas that ...

ESPN public editor Jim Brady’s Grantland column comes under fire from former staffers
... 30, but its impact is still being felt in sports media. That's most recently the case with ESPN public editor Jim Brady's long-promised column ...

Tuesday Morning Open Thread: The (D) Column
… maybe that stands for (D)ueling (D)eities? Also, a bloc of supporters that only the Dems would, uhhh, solicit (and good for Hillary, doing ...

Why Men shouldn't write advice columns
Passed along by you guessed it Papa B. Hey, I'm just the messenger!

Nitin Desai: Budget choices - Business Standard Column New Document Widgets Magazine Widgets Magazine ...
The finance minister faces a difficult problem in choosing between two sets of advisers. Both factions accept that the Budget must aim at stimulating ...

Column: Night of losers is another winner for UFC
LAS VEGAS (AP) — Her face marked and still red, Holly Holm stared blankly ahead as Conor McGregor walked in, looking a lot worse for the wear ...

‘Crouching Tiger’ Sequel: An American Filmmaker’s Quest To Make The First Eastern Western – Guest Column ...
Sixteen years after Crouching Tiger, Hidden Dragon became a worldwide phenomenon, the sequel has been released today in China ahead of its U.S. ...

Resources last updated: 3/19/2016 10:55:12 AM