Example Code

Simple MS Excel automation library

Code and Documents

Attachment

Download All

Overview

This library provides basic functionality for reading and writing data from LabVIEW applications to/from Microsoft Excel.

Description

The attached zip file contains the LabVIEW library files, an example program and a Excel file generated from the example code.

The library uses ActiveX automation. The library is a compilation of code and examples found on the NI website  and other Internet sources. I added also some new functionality and organized the subVIs in easy to use library.

Initially the code was in LabVIEW 7.1 and transferred later to LabVIEW 2011/2013 almost without changes, so there is for sure place for improvement. There is no additional help file, but I tried to comment and add descriptions to the subVIs.

The example program shows how to generate Excel file from a table in few steps.

Requirements

LabVIEW 2010+

Microsoft Excel (I used all versions from 97 to 2010 without any problems)

Additional Images

Overview of the included VIs

xl_automation_lib.png

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

Comments
Pankajusic
Member
Member
on

Kindly provide LV2011 version for the same.Thanks

chembo
Active Participant
Active Participant
on

I saved the files in LabVIEW 2010. You should be able to load them in higher LabVIEW version.

Pankajusic
Member
Member
on

Thanks a lot...:)

Contributors