How can I recover a scope acquisition in a spreadsheet ?

[carolyne]

Hi,

I'm using a Tektronix 1002 and Labview 8.

I do an acquisition with the scope and I want to recover it in an excel file.

Bones talked about a VI doing that "get..." (I did't remember the exact name) but I miss open excel and make visible.vi, open new workbook.vi and open new worksheet.vi.

Is anyone can provide me more details about this and how to do exactly ?

Thanks for your help

[Stuart_R]

Am I right in thinking that you want to write data to a spreadsheet file?

The VIs that you mention are part of the Report Generation toolkit for Microsoft Office and if you haven't purchased and installed this toolkit, you won't have access to any of the functions. This isn't a problem however if you just want the ability to write to a spreadsheet file and read from the file again.

Take a look at the Write to Spreadsheet File.vi and Write to LabVIEW Measurement files etc. My best advice would be to use the example finder and serach for keywords such as Spreadsheet, File I/O etc.

Let me know if I can help you further.

Stuart

[carolyne]

Dear Stuart,

I know the Write to a measurement file fonction and I've already used it, but what i would like to do now is recover directly the oscilloscope curve in an excel file.

You say I can't use the "GetHardCopy.vi" if I haven't purchased this toolkit from Microsoft office ?

My acquisition is very complex (with a trigger...) so I don't want to modify it in a VI or to get a too heavy excel file because of the data number.

Have you an idea about how I can do ?

Thanks

[Stuart_R]

Carolyne,

Never heard of Get Hardcopy.vi, I was referring to the VIs that you mentioned which definitely are part of the report gen toolkit. Is this part of an instrument driver or something?

From what you have said, you want to plot your acquired data inside an Excel Chart? If you want to programmtically do this then the toolkit is the best bet, as a lot of the ActiveX programming has been done for you. You could still implement this yourself by using ActiveX but its not a simple affair and thats why the toolkit is a good buy.

Not sure what you mean by: "My acquisition is very complex (with a trigger...) so I don't want to modify it in a VI or to get a too heavy excel file because of the data number."??

[carolyne]

Stuart,

The gethardcopy.vi is apparently a VI which does what I want, Bonnes talked about this in one of his answers for another member request.

Concerning programming with active X I know nothing about its use and can you tell me more about the gen report toolkit ?

Thanks

[carolyne]

Stuart,

Actually I have the report generation toolkit in my function palette but I don't see any functions to save a chart which comes from a scope...

Can you clarify what you wanted to say about this ?

Thanks

[Stuart_R]

Yeah, you get a report generation subpalette inside LabVIEW but when you install the Report Gen toolkit, more functions become available from this palette. Slightly confusing I know.

This link details more about the specific toolkit:

http://www.ni.com/toolkits/report_gen.htm

Have you tried contacting Bones or can you point me to this other discussion?

[carolyne]

Dear Stuart,

In fact his name is boone and I've found the discussion, here the link: http://forums.ni.com/ni/board/message?board.id=170&message.id=78691&query.id=55496#M78691

[Stuart_R]

I can't open that VI either as I'm missing the subVIs. Have you tried posting to that forum specifically?

Do you want the creating of the excel charts to be automatic or can you manually generate the chart inside Excel using data that LabVIEW has written into a worksheet?

[carolyne]

Yeah exactly, I want the chart to be done automatically.

I haven't tried to chat with boone because the member alredy tried and boone didn't answer but i'm going to try now.