topic Re: Using excel file as a calculator? in BreakPoint

Using excel file as a calculator?

ysulim1 — Fri, 18 Jan 2013 21:01:01 GMT

I have an excel file which calculates salinity from conductivity. I want to input my conductivity measurement (2-10V, 15,000-100,000 uS/cm) into a cell on an excel file I got online then read the the cell which returns the salinity value and display it. No clue where to start.

Re: Using excel file as a calculator?

RavensFan — Sat, 19 Jan 2013 04:13:40 GMT

How complicated is the calculation? Why not code the formula in LabVIEW rather than relying on an Excel spreadsheet?

If you must use Excel, look at the Excel Board message thread which provides links to useful threads discussing how to use ActiveX to open an Excel file and interact with it.

Re: Using excel file as a calculator?

altenbach — Sat, 19 Jan 2013 08:28:49 GMT

@ysulim1 wrote:

I have an excel file which calculates salinity from conductivity. I want to input my conductivity measurement (2-10V, 15,000-100,000 uS/cm) into a cell on an excel file I got online then read the the cell which returns the salinity value and display it. No clue where to start.

It is not clear what you want, and since you posted in the breakpoint forum, you apparently are not looking for a LabVIEW solution. Or are you?

What are you using to conduct the measurements?

Re: Using excel file as a calculator?

JÞB — Sun, 20 Jan 2013 16:23:42 GMT

One other thing to consider:

Excel is not a calculator, Its math functions are optomized for accounting and does not handle denormalized floating point numbers in the "Correct" way (Per the IEEE 745 standard). So it is probable that any calculator will give you slightly different results than Excel.

It is almost a given that writing the calculation in LabVIEW is going to be simpler and faster than using LabVIEW to interact with the worksheet.