topic Re: read data from excel in LabVIEW

read data from excel

jupe — Thu, 12 May 2005 19:13:54 GMT

I WANT TO READ A COLUMN OF VALUES FROM EXCEL TO LABVIEW, CAN ANYONE TELL ME THE BEST WAY TO ACHIEVE THIS,
BEGINNER

Re: read data from excel

chilly_charly — Thu, 12 May 2005 19:23:04 GMT

The attached llb should give you the answer.

CC

Re: read data from excel

tbob — Thu, 12 May 2005 19:51:55 GMT

CC, can you send the Range Format vi (subvi to your main)? Merci beaucoup.

Re: read data from excel

chilly_charly — Thu, 12 May 2005 20:01:55 GMT

Hum, sorry, I missed something while creating the llb !

CC

Re: read data from excel

Joe_H — Thu, 12 May 2005 20:04:49 GMT

here are some vi's that will help you.

Re: read data from excel

tbob — Thu, 12 May 2005 23:25:02 GMT

Thanks CC, I've been looking for a way to do that.
jhoskins, thanx also for the tools. You're not half bad, even for a Vols fan ;). Geaux Tigers....

Re: read data from excel

jbrohan — Thu, 20 Oct 2005 21:32:53 GMT

I wrote an Excel Toolkit which hides nearly all the peculiarities of Excel and offers access to rows and columns of data from a Spreadsheet. Let me know if it works for you!

http://sourceforge.net/project/showfiles.php?group_id=146143&package_id=160861&release_id=355395

John

Re: read data from excel

Kazu — Mon, 14 Nov 2005 05:52:14 GMT

Hi.CC.

I have seen your program !(Excell Get Data Specified Field)

But, I can't understand this program because I am trainer for using LabView.

So please teach me the detail of each programing path.(for exanmple, workbooks in application mean・・・・）

If it is convinient for you,　 I am glad to be taught for Active X

I am looking forward to your response!

Re: read data from excel

TDSquare — Mon, 03 Jul 2006 13:39:01 GMT

I want to do something thing similar, but I am deploy it to a PDA, so Property Node and Invoke node are not supported in the PDA module. I'm using LV 8.

What I'm trying to do is: If I have maybe 4 column in Excel called A, B, C, and D. and several rows. I wanted to populate the appropriate String Indicator when the enter String corresponds to a column value or String. With Microsoft Access a query can be used, like Select A-data, B-Data, C-Data, D-Data from Table1 Where string1 = to what the user enters.

Basically, the user types a String, LabView checks if that value is in the Excel Worksheet, if it exist, the associated data populates the relevant field (String Indicator).

Please help.

Re: read data from excel

WNM — Thu, 29 Mar 2007 19:25:27 GMT

John wrote:

"I wrote an Excel Toolkit which hides nearly all the peculiarities of Excel and offers access to rows and columns of data from a Spreadsheet. Let me know if it works for you!
http://sourceforge.net/project/showfiles.php?group_id=146143&package_id=160861&release_id=355395"

I was looking for something that would let me read a worksheet's worth of data form a real (not CVS) Excel file so figured I'd look in on this toolkit. The first thing I found was that within the ZIP file is the file "FunctionalGlobalExcel toolkit.doc". This is not, as it might look to be, a Microsoft Word document. It is actually an OpenOffice document and you'll need some form of that application to view the file. Once you get the file open properly, you can save it in a number of other formats if they are more convenient. A copy of it as an RTF file is attached for your convenience.

Re: read data from excel

Joe_H — Thu, 29 Mar 2007 22:15:22 GMT

Hace any of you looked here for your excel answers. excel board