Example Code

Courtney_L · ‎05-04-2012

Overview
This example VI show a way to write a single row of data to an Excel spreadsheet.

Description
This example writes a single row of data to an Excel spreadsheet using the Report Generation Toolkit. A set of random data is generated and built into an array. This VI opens an Excel file, checks for the first empty row in that spreadsheet and writes the data to the first empty row.

Requirements

LabVIEW 2012 (or compatible)
LabVIEW 2012 Report Generation Toolkit for Microsoft Office (or compatible)
Microsoft Excel 2003 (or compatible)

Steps to Implement or Execute Code

Download the attached folder to your computer
Open the VI "Write Row of Data to Excel Spreadsheet 2012 NIVerified.vi"
Run the program
Choose the location of the Excel spreadsheet to be written in the "Excel File Control"

Additional Information or References
VI Snippet

VI Snippet.png

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

Dinesh.K · ‎07-07-2012

I had tested the file it dose not load the last data

Transt · ‎02-22-2013

Hi Dinesh,

I just download your VI but one sub VI Excel Get Last Row missing where could I get it.

Thank you

Zahkay · ‎01-28-2014

Hello

I wanted to ask

Is there solution concerning labview interfacing with excel. I wanted to make a database. Once i scanned my QR code and the decoded QR code should be store in the excel. I dont know how to link it. Also i have to update information concerning when the student is borrowing or taking equipment. The GUI also should be in labview

Anything for this please

Courtney_L · ‎01-28-2014

Hey Zahkay,

Yes - there are lots of ways to export data from LabVIEW to Excel. There are shipping examples and other examples on the community that show you how to use TDMS or Write to Measurement File functions.

mgbglasgow · ‎04-02-2014

doesnt work,, VI excel issue for last line Get Last Row.vi error ,,,

r4ba · ‎04-16-2014

Hi,

how to save different data type at the same time to the same excel sheet?

Jerryzhang · ‎09-14-2014

Hello: I want to ask how to setup new Excel with labview.I want to write new program about analysis test data.Can you give me some suggestions about this program?Thanks

JW82 · ‎12-15-2014

Holy shnikies, I have been messing around trying to get to this point and your vi saved me!!!! THANK YOU SO MUCH!!!!

DalyaJGP · ‎02-17-2015

Hola buen día, estoy haciendo un proyecto de control de temperatura y de ph en un tanque y pues mientras practicaba con LabVIEW me puse a pensar si es posible que, teniendo diferentes datos en dos o mas tablas de control en el VI, ¿es posible guardar estos datos en diferentes hojas de calculo dentro del mismo documento de EXCEL? y si es posible, ¿Cómo se haría?

Gracias.

Hi, is possible save datas in differents Excel spreadsheet inside the same excel document? and if it's possible, how can i do that?

ponkumar · ‎07-25-2017

hi,

If i run above program the error will occur. Please any one help me.

ponkumar · ‎08-01-2017

hi,

i am a new user for LabVIEW. I use LabVIEW 2012. I my company we manufacture the motor. my work is test the motor with reference of barcode and calculate power,power factor,RPM. The reading are i get it. But i don't know how to generate customized report. i have report generation toolkit for microsoft. please any one give example.

ponkumar · ‎02-02-2018

Hi,

I execute the while loop with eight iteration. In every iteration value to be store in single row but different column. please any one help me.

Example Code

Write Individual Rows of Data to Excel Spreadsheet

Code and Documents

Attachment