Example Code
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.
- LabVIEW Report Generation Toolkit
- LabVIEW
Software
Code and Documents
Attachment
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
- Download the attached VI.
- Enter the correct paths of the Excel file
- Run Delete Rows or Columns from Excel 2013 NIVerified.vi
- 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. **
Example code from the Example Code Exchange in the NI Community is licensed with the MIT license.
