ni.com is currently undergoing scheduled maintenance.
Some services may be unavailable at this time. Please contact us for help or try again later.
Example Code
Products and Environment
This section reflects the products and operating system used to create the example.To download NI software, including the products shown below, visit ni.com/downloads.
- LabWindows/CVI
Software
Code and Documents
Attachment
Description
Overview
This example demonstrates how to create a new worksheet in Microsoft Excel with C programming in LabWindows/CVI.
Description
Using the ExcelRpt_ApplicationNew, ExcelRpt_WorkbookNew and ExcelRpt_WorksheetNew functions in the Excel Reports Library, Microsoft Excel can be programmatically opened and a new Worksheet can be created. This example contains a user interface to allow the user to choose when Microsoft Excel is opened and when a new worksheet is created.
The Excel Reports Library is available as a part of LabWindows/CVI. The function panels can be found under C:\Program Files\National Instruments\<CVI DIR>\toolslib\activex\excel.
Relative Links: Generating Microsoft Excel Reports with LabWindows™/CVI™
Requirements
- LabWindows/CVI 2012 (or compatible)
Steps to Implement or Execute Code
- Unzip the attached folder to your computer
- Create 3 command buttons on the User Interface (Launch Excel, New Sheet, Quit)
- Create callbacks for each of these buttons
- Use ExcelRpt_ApplicationNew and ExcelRpt_WorkbookNew to open up Microsoft Excel with a new Workbook for the Launch Excel callback
- Use ExcelRpt_WorksheetNew to create a new sheet for the New Sheet callback
- Quit the user interface and discard the panel in the Quit callback
Additional Information or References
Front Panel
**This document has been updated to meet the current required format for the NI Code Exchange.**
Example code from the Example Code Exchange in the NI Community is licensed with the MIT license.
