How do you import Excel file to LabWindow GUI

[thieny1]

Does anyone know how to import Excel file to LabWindow CVI GUI. Thanks

[RobertoBozzolo · Accepted solution]

It's not clear to me wether you want to embed an Excel workshee into a CVI panel or to import data from the worksheet. CVI comes with a ActiveX instrument that you can use to interface to Excel read / write data from its files. Alternatively, CVI panels can host Excel documents and interact with them. All these activities are made via a special ActiveX instrument (Excel2000.fp).

Interaction with Excel has been often treated in the forums so you can perform some query to retrieve useful informations. There are also several examples that you can download and study to understand how to use these instruments: some of them are listed into this page.

[thieny1]

Hi Robert

Thank you for the info, I would like to know if there a way you can copy excel worksheet from another excel file to the ActiveX embedded Excel Spreadsheet (See attached).

Also, I try to write/read to this new embedded Excel Spreadsheet using your smaple code but it return a error:

      ERROR: Microsoft Excel Automation - Member not found!

Thanks again for your support.