Placing data into specfic cells eg A11-A24 in Excel

[Audi]

I need to write data to specific cells in a excel macro sheet . Thks

[Photon_Dan]

(Windows only)

LabVIEW ships with some examples that do what you need. Check out the VIs in the following library.

.../LabVIEW/examples/comm/ExcelExamples.llb

The Report Generation Toolkit also has nice VIs for doing that.

If you'd like something very professional done for you, contact an Alliance Member. You'll come out with a great example of LabVIEW programming. We do this stuff every day.

Daniel L. Press
PrimeTest Corp.
www.primetest.com

[Michael_Munroe]

I often store measurements in an Excel template that contains all the data analysis required by the customer. The best way to target specific cells is by using "Range Names" in the template for all of the locations. By referencing all cells by name, the links will not be broken if the template is later modified by inserting new rows or columns.

In Excel, use Insert->Name->Define to create the names. In LabVIEW, replace the row and column indexes used in the example code with the range name as a string (worksheet->Range("StartFreq"). These same names can be used in an Excel macro to process the data and produce sophisticated graphs and reports.

Michael
ABCDEF
www.abcdefirm.com

[Elora_Paul]

Hi - I'm trying to do a common thing I see others have tried, but I don't see answers...

for **Named Ranges** in Excel, how do you write an array of LabVIEW data to a named range (with *plural* cells!!)?

I get the same behavior that I've read others get, that is, Excel writes the 1st value of the array into *all* members of the named range. Not the desired behavior.

It would seem to be a very powerful tool to be able to simply refer to an entire range of cells as a named range, the way you can within Excel, but I can't figure out how to make LabVIEW talk right to Excel to make it happen...