How to Modify Write Table To XL

[MeCoOp]

Is there a way to modify the Write Table To XL.vi so that it reads from a user defined excel sheet then takes that data and writes it to specific cells in another specified excel sheet?  In other words have one spreadsheet of compiled data that the program reads from and sends certain data points to specific cells in a report template.

Thanks.

[Kaustubh_vc]

Hi!

You first read excel file and store it in the array.

Then take contents from array and use sub vi "Set cell value" to write data at specific location in excel.

Here, You have to first open Excel template and then save the file.

See the attachment.

If not understood,

Reply.

Kaustubh

VC (Pune)

INDIA

[MeCoOp]

Ok, I think I see where you are going with the solution.  I'm using LabView 6.1 is there a way you could save the block diagram as a picture so I can view it.  Thanks for you help.

[Will.D]

Message Edited by Novatron on 08-31-2005 01:34 PM

[MeCoOp]

I'm not sure if I was clear I what I want to accomplish, I'm still unsure on how to apply your suggestion.  I've attached what I've programmed so far, it basically performs specified mathematical functions on the collected data and shows the result to the user.  I've also attached the sample excel format I would like to use.  I want to take the calculated data points and reference them to certain cells in the excel template.  For example, take the averaged data point and send it to cell J46 on the excel template.  The user should be able to specify the location of the excel template.  My understanding of invoke/property nodes isn't all that good. 

Message Edited by MeCoOp on 08-31-2005 04:47 PM

Message Edited by MeCoOp on 08-31-2005 04:47 PM

Message Edited by MeCoOp on 08-31-2005 04:47 PM