read data from excel

[jupe]

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

[chilly_charly]

The attached llb should give you the answer.

CC

[tbob]

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

[chilly_charly]

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

CC

[Joe_H]

here are some vi's that will help you.

[tbob]

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....

[jbrohan]

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

[Kazu]

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!

[TDSquare]

Hi

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.

[WNM]

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.