Example Code
产品和环境
本部分要求填写创建该范例所需的产品和操作系统。如要下载NI软件（包括以下所示产品），请访问ni.com/downloads。
- LabVIEW
软件
代码和文档
添加附件
Overview
This example demonstrates how to search in Excel through LabVIEW using ActiveX.
Description
Many applications in the Windows environment give access to some of their most basic functions to a centralized framework called ActiveX. This allows for cross program interaction in a simple fashion. Available functions include "Start" and "Stop" in such programs as Windows Media Player and document formatting in Microsoft Word and Excel. This example allows you to search a Microsoft Excel spreadsheet for a specified string from within LabVIEW. LabVIEW opens Excel and uses the Find function within Excel and then retrieves the results.
Requirements
LabVIEW 2012 (or compatible)
Windows Excel
Steps to Implement or Execute Code
1. Downlaod the zipped folder "Search in Excel_LV2012_NI Verified"
2. Open the project and launch the VI "Search Excel_LV2012_NI Verified"
3. Choose the path of the Excel file
4. Enter the Sheet you want to search within
5. Enter the String to Find
6. Run the VI
Additional Information or References
Front Panel
Block Diagram
Notes
Please note the ActiveX interface is specific to Microsoft Excel, as a result there is limited documentation on using the interface. All the documentation can be found from Microsoft on the MSDN.
**This document has been updated to meet the current required format for the NI Code Exchange.**
NI社区“代码范例交流区”(Example Code Exchange)中的代码范例已获得MIT许可。
Searching and finding all position of a given string in an excel sheet. developed using labview 2012
