Delete Columns in Excel Spreadsheet Using LabVIEW and Excel ActiveX Server

[Eric_B.]

Overview

This example prompts for a file and for the letter of the column to delete.

Description
Using the Excel ActiveX Server, you can open a reference to an Excel spreadsheet and delete a given column. It saves the file to the same location/filename with " - modifed" added to the file name using regular expressions.

Requirements

• LabVIEW 2012 (or compatible)

Steps to Implement or Execute Code

• Run the program
• Select the excel file to revise.

Additional Information or References
VI Snippet

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

[SeanJ]

I'm just wondering, how does one create an application refnum.  In this case it is Excel.Application, where did it come from?

[SeanJ]

Ok, sorry it's simple.  Insert an automation control on the front panel or auomation refnum on the block diagram.  Right click and select activex class.

[windows]

Hello!

i have few doubts,

1. i am not able to find excel.application:

i right clicked on input of automation block and click on browse. I am not sure how to select excel.application.

2. with the example you provided, i am not able to select properties for property node. Here are the images i came accross.

[soupy]

I had the  same issue where Excel.Application was not showing up in the type library even though Excel came pre-installed on my laptop. I resolved it by going to my Office365 page and selecting the "Install Office" link. I'm not sure if it made a difference, but I also chose to install office with the same bitness (32 vs. 64) to match my LabVIEW install.