graph to spread sheet

[Muralidharan]

how to save a front panel graph to a spread sheet file programatically?

[GerdW]

Hi Muralidharan,

what exactly do you want?

Writing the values to a text file or copying a picture of the graph into an Excel worksheet?

Saving to spreadsheet is easy using the WriteToSpreadsheetFile function... Read the help, look at the examples coming with LabVIEW!

[Muralidharan]

hello sir

I know to write the values to spread sheet file. But i want to save the front panel graph image in spread sheet.

Thanks and Regards,

Murali.

[Andy.G]

Hey Muralidharan,

I would suggest that you use ActiveX to generate your graph in excel. But this is a two step process, first you will need to save the graph to file. This can be achieved using an invoke node of the graph and setting a file location. Once the file location has been stored you can use the activex functions to insert it into your excel document. I have sent a link that should help you to generate the activex function for your specific problem. If you get stuck at any point please feel free to ask and I will help as best I can.

How to create an invoke node of a graph:

http://forums.ni.com/t5/LabVIEW/How-can-I-easily-make-a-screen-shot-of-a-polar-graph/m-p/1198851#M51...

How to create the activex function:

http://forums.ni.com/t5/LabVIEW/How-can-I-add-excel-pictures-using-activex/m-p/1002526