Example Code

Generate Excel Columns (A-Z, AA-ZZ, BA-BZ) Using LabVIEW

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 generates an array of data to address both columns and rows numerically.

 
Description

A common requirement when working with Excel Spreadsheets via the Automation RefNum is to address the columns, as these are labelled A-Z-AA-AZ-BA-BZ... It's useful to have a SubVI to automatically generate an array of this data so you can address both columns and rows numerically.


Requirements

  • LabVIEW 2012 (or compatible)


Steps to Implement or Execute Code

  1. Edit the Numeric control for loop's N terminal to generate a larger array of values for larger column amounts.
  2. Run the VI.

Additional Information or References
VI Snippet

003.png

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

Applications Engineer

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