topic Re: Write to an Excel File in LabVIEW

Write to an Excel File

Leprechaun — Thu, 29 Jul 2010 17:25:59 GMT

I am trying to make an excel spreadsheet given data from a pressure calibration. I need it to be able to ask the user for their name, probe number and range. It also needs to be able to put the date in by itself. Also, it needs to be able to ask for a number for what the pressure is and then when it reaches that number to put the voltage into the excel file. It needs to be able to collect only 10 data points. Then it needs to make a line graph with this information. How do i do so? An example file would help tremendously!!

Re: Write to an Excel File

nyc_(is_out_of_here) — Thu, 29 Jul 2010 19:17:20 GMT

Help ---> Find Examples ---> Communicating With External Applications ---> Active X ---> Excel

Re: Write to an Excel File

smercurio_fc — Sun, 27 Apr 2025 03:35:15 GMT

You're asking for a lot of things there, so you need to break it down in pieces.

First off, does it absolutely have to be an Excel workbook? If so you will then need to either get the Report Generation Toolkit, or learn to use ActiveX to create Excel workbooks and write data to it. The Excel threadhas links to lots of examples on manipulating Excel. NOTE: DO NOT POST QUESTIONS IN THAT THREAD. If you do not absolutely need an Excel workbook then you can just use the Write to Spreadsheet File VI. This will create a delimited text file that you can read into Excel if you need to.

As for your other questions, it sound like you need to make up some dialog boxes. This is fairly easy, and examples ship with LabVIEW. There have also been numerous examples posted.

What's not clear is where this voltage is coming from. Is this something you're asking the user to enter, or are you reading this from some DAQ device.

Have you looked at some of the tutorials and examples? To learn more about LabVIEW it is recommended that you go through the tutorial(s) and look over the material in the NI Developer Zone's Learning Center which provides links to other materials and other tutorials. You can also take the online courses for free.

Re: Write to an Excel File

Leprechaun — Thu, 29 Jul 2010 19:44:40 GMT

Everything is already set up my job is just to take the information that is given and make labview put it into an excel spreadsheet. I have the microsoft add on thing. I am very new with this program and this is my first time using it not doing tutorials.

Re: Write to an Excel File

tbob — Thu, 29 Jul 2010 20:48:20 GMT

So have you attempted to write any code yet. You would get help more readliy if you try to write some code, post it here, then ask for help on any problems you run into.

You can start by writing code to ask for the information you require. Use a Prompt User function to prompt the user for information. We'll go from there.

Re: Write to an Excel File

Leprechaun — Fri, 30 Jul 2010 13:26:51 GMT

Here is what I have so far. I just need to send what i finish to my supervisor and he will add the rest of it

Re: Write to an Excel File

Chris_Garratt_NIUK — Fri, 30 Jul 2010 13:52:22 GMT

Hey Leprechaun,

Depending on what you need to do to the data afterwards it is quite easy to append data to a spreadsheet file by converting each data reading to a string and concatonating your information to the string before writing to a text file.

I would also recommend searching the examples for something you can use and if you have a function you need to implement, try right-clicking in the block diagram and entering what you want to do into the search.

To get users to enter information, using the 'prompt user for input' usually works quite well.

Regards

Chris

Re: Write to an Excel File

meanmon13 — Fri, 30 Jul 2010 14:04:23 GMT

I have attached a screenshot of a VI I wrote that'll write to a spreadsheet file. You can use it as a reference to build your own. It'll put the data into a spreadsheet but you'll have to manipulate the data manually in excel from there.

Re: Write to an Excel File

tbob — Fri, 30 Jul 2010 16:16:19 GMT

@Leprechaun wrote:

Here is what I have so far. I just need to send what i finish to my supervisor and he will add the rest of it

Why don't you impress your supervisor and do the entire thing yourself.

Re: Write to an Excel File

Leprechaun — Fri, 30 Jul 2010 19:01:38 GMT

well as i said before i am new to this program, I am only a co-op student so this is my first time actually using this in a real job position. So all I am doing is asking for help doing something that I don't completely understand being the college student that I am.

Re: Write to an Excel File

tbob — Fri, 30 Jul 2010 21:19:42 GMT

I was a college student once, a long long time ago on a campus far far away. So I know the many burdens you are facing. However, if you could show practical job experience on your resume instead of just good grades, you will have a better chance at landing a job. Try to do as much as you can. Learn more about Labview on your spare time. We will help you with problems.

Re: Write to an Excel File

Leprechaun — Wed, 25 Aug 2010 17:55:22 GMT

I have a lot more added but for some reason i still can't get it to work and i really don't know what to do i have attached the program could someone maybe help me with it or direct me in a better path. that would be greatly appreciated

Re: Write to an Excel File

RavensFan — Wed, 25 Aug 2010 18:07:46 GMT

What is it doing or not doing? It is kind of hard to help when you don't tell us how it isn't working for you.

One thing I see that is odd is that you have a feedback node on the boolean wire between the "Prompt for User Input" express VI and the Create New Report.

Re: Write to an Excel File

Joe_H — Wed, 25 Aug 2010 18:10:15 GMT

What is working or not working. Very odd that you have a feedback node coming from the Prompt user for input. Also if you need the Probe info and stuff like that in the file then you need to wire it up.

Re: Write to an Excel File

smercurio_fc — Wed, 25 Aug 2010 18:10:58 GMT

What, exactly, doesn't work? We are not mind readers, and we don't have your setup, so jsut showing us code and telling us "it doesn't work" is rather useless. Are you getting an error? If so, where? Are you not reading data? Is it not saving?

What is the intention of the code? Are you intending to write a new workbook each time you loop (which is what it's currently doing)? If not, then the New Report VI belongs outside the loop. What is the point of the Feedback Node? The dialog you display only has one button, so the OK output will always be True.

How big is your monitor? Why is the Stop button off in right-field?

Re: Write to an Excel File

Leprechaun — Wed, 25 Aug 2010 18:19:16 GMT

I end up getting an error report for 2 things.... one that says "error-3 occured at unidentified location" and an error -2147352567 at property node(arg2) then the excell insert chart and everything after that is mentioned. I also got rid of the node cause i don't really know what it was for.

Re: Write to an Excel File

Leprechaun — Wed, 25 Aug 2010 18:22:18 GMT

also how do i get the prompts into the excel file itself i am really lost on what i am doing

Re: Write to an Excel File

smercurio_fc — Wed, 25 Aug 2010 18:35:54 GMT

@Leprechaun wrote:

I end up getting an error report for 2 things.... one that says "error-3 occured at unidentified location" and an error -2147352567 at property node(arg2) then the excell insert chart and everything after that is mentioned. I also got rid of the node cause i don't really know what it was for.

The error -3 is being displayed by the General Error Handler and is being caused by your DAQ configuration/code. What are you trying to do with the DAQ, and what data are you trying to save? It appears as if you're just saving one value (the mean), at each iteration, and trying to save it into a new worksheet. That doesn't make much sense.

Re: Write to an Excel File

Leprechaun — Wed, 25 Aug 2010 19:39:50 GMT

the plan is to put in the voltage and then to have this read the pressure and put that into the excel file as well as the voltage number that we put in

Re: Write to an Excel File

smercurio_fc — Wed, 25 Aug 2010 21:30:43 GMT

@Leprechaun wrote:

the plan is to put in the voltage and then to have this read the pressure and put that into the excel file as well as the voltage number that we put in

That makes absolutely no sense.