LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

reading from Excel in a specific location

Hi,
Is there an example I could look at that reads from specified Excel locations?
Thanks, Ivanka
0 Kudos
Message 1 of 4
(2,473 Views)
If you mean a "Named" cell or cells in Excel, I should have a few snipets of code laying around that would at least get you started.

Let me know if this is what you mean and what version of LabVIEW you have.

Ed


Ed Dickens - Certified LabVIEW Architect - DISTek Integration, Inc. - NI Certified Alliance Partner
Using the Abort button to stop your VI is like using a tree to stop your car. It works, but there may be consequences.
0 Kudos
Message 2 of 4
(2,473 Views)
Here is an example that reads one block of text from anywhere on the specified sheet. This text could be converted to numbers or you can change the string array to a numeric array.

Be sure to close all references after use, otherwise Excel will hang later on.

Michael Munroe
www.abcdef.biz
Michael Munroe, CLD, CTD, MCP
Automate 1M+ VI Search, Sort and Edit operations with Property Inspector 5.0, now with a new Interactive Window Manager!
Now supports full project automation using one-click custom macros or CLI.
Message 3 of 4
(2,473 Views)
Thanks Ed,
I mean readinga and writing to exact Excel cells (ie. row and column known.)
Have a Happy Halloween!
Ivanka
0 Kudos
Message 4 of 4
(2,473 Views)