Delete Rows or Columns in Excel Using Report Generation Toolkit from LabVIEW

[Joel-I]

Overview

This code loads in a user specified excel spreadsheet, and will then delete a range of rows or a range of columns

Description

This example code shows how to delete rows or columns in Excel. The remaining cells will be shifted up or to the left. The user will be prompted to choose to delete rows or columns, then what range of cells to delete.

Requirements

• LabVIEW 2013 (or compatible)
• Ni-Report Generation Toolkit
• Microsoft Excel (or similar)

Steps to Implement or Execute Code

1. Download the attached VI.
2. Enter the correct paths of the Excel file
3. Run Delete Rows or Columns from Excel 2013 NIVerified.vi
4. Choose to delete rows or columns, then what range of cells to delete. 

Additional Information or References

VI Block Diagram

 

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

[KenNorcross]

Could you post a Labview 2012 version of this?

Thanks!

[oliver1023]

hi, got any ways to disable the save excel popup? i want it to always save the excel