Get Excel Data from Specified Field

Publish Date: Jul 26, 2007 | 14 Ratings | 4.57 out of 5 | Print | 4 Customer Reviews | Submit your review
This VI accesses an existing Microsoft Excel file, extracts data from the user specified range on the specified sheet, and returns the extracted data in two array forms - one in an array of dbl and one in an array of string. The user is required to enter the sheet name and the range from which he or she wishes to extract data before running this VI. The default value for the sheet name is Sheet1. The default start and end locations of the data range are (0,0) and (0,0), respectively. To extract the entire data from the Excel file included with this vi, set start location to (0,0) and end location to (19,4). Note that (0,0) implies to (row location=0, column location=0). The location values are converted to A1 format using the subVI named Row Col To Range Format.vi, which is used in the Excel Get Data.vi in the Report Generation toolkit.

Back to Top

Additional Information
Contributor Name : Motoomi Miyamoto Contributor Company : BEI Duncan Electronics
Customer Reviews
4 Reviews | Submit your review

  - Sep 23, 2010

This example works as expected, but if you try to run it more than once it displays an Unknown System Error, so you need to open the task manager an end the process EXCEL to make it work again. I suppose that the vi is not closing properly the excel application.

Just what i was looking for  - Oct 29, 2007

thanks for this, it saved me some time, and does just what i need with just a little modification.

Example Broken  - Aug 23, 2006

This example is broken and will not run at all on my system. The only thing worse than finding no information is thinking you've found some only be disappointed.

Works well...  - Aug 2, 2006

Needed to read product configuration info from an excel spreadsheet and this did the trick. Using LV8 and Excel 2003. Well done & thanks.

View more reviews

Bookmark & Share


Downloads


Ratings

Rate this document

Answered Your Question?
Yes No

Submit