From 11:00 PM CST Friday, Apr 11th - 1:30 PM CST Saturday, Apr 12th, ni.com will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.

Home Community Example Programs Example Code Document

Example Code

cancel
Turn on suggestions
Showing results for 
Search instead for 
Did you mean: 
ASK A QUESTION

Copy a Worksheet in Excel Using ActiveX controls with LabVIEW

by:
‎04-01-2011 02:45 PM
Last Edited by: Member Example_Scrubber_Nian ‎08-12-2017 09:39 AM

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.

    Software

  • LabVIEW

Code and Documents

Attachment

Download All

Overview

This VI demonstrates how to copy a worksheet in Excel using ActiveX controls.

 
Description

This VI can open Excel, copy the sheet specified by Master Sheet Name, rename the copied sheet according to New Sheet Name, and move that newly named sheet to the end (right most position) of all the sheets.


Requirements

  • LabVIEW 2012 (or compatible)


Steps to Implement or Execute Code

  1. Browse the folder where you will save your new excel file.
  2. Run the VI.
  3. Open the excel file, you will find a new worksheet has been copied.

Additional Information or References
VI Snippet

003.png

**This document has been updated to meet the current required format for the NI Code Exchange.**

Sarah Yost
Senior Product Marketing Manager

Example code from the Example Code Exchange in the NI Community is licensed with the MIT license.

Comments
Gallagher_49684
Member
Member
on
‎04-26-2011 08:56 AM
‎04-26-2011 08:56 AM

Extremely helpful, thanks!

0 Kudos
emottin
Member
Member
on
‎07-05-2014 07:42 AM
‎07-05-2014 07:42 AM

This is exactly what I need... It's copy also the graphs , thanks!

0 Kudos
MartinNilsson
Member
Member
on
‎05-31-2019 12:57 PM
‎05-31-2019 12:57 PM

That's great, thank you, Sarah!

All I have to do now, is to figure out which references to close and which references to update when I use your example together with the LV MS Office tool kit.

0 Kudos