export tdv file or channel to excel

[Leillo]

Hi Guys,

I hope someone can give me a hand with this. I have some plots in an .TDV file that I would like to export to Excel and I have no idea about how to do it. What I want is to have in Excel the image of the plot. Is this possible?

Thanks,

Leo

[Pesmith8]

Leo

Looks like you can export a report object to a jpeg file.  From there you should be able to paste that into Excel.  It should also be possible to autotransfer this jpeg into a Excel workbook from DIAdem. 

The commands below  will do  a export to jpeg from a DIAdem report.

Report.Settings.ImageExport.JPG.BitsPerPixel = 0

Report.Settings.ImageExport.JPG.Quality = 75

Report.Settings.ImageExport.JPG.Progressive = 0

Report.Settings.ImageExport.JPG.UseRatio = True

Report.Settings.ImageExport.JPG.Height = 768

CallReport.ActiveSheet.ExportToImage("C:\jpegout.JPG",eImageExportTypeJPG)

Paul

[Pesmith8]

Leo

My previous post was rather brief,  Although it is possible to transfer the report to a jpg.   This output was for the whole report not just a report object, like what I thinking you are wanting. 

Also in reading your request, I am assuming that the end goal is to have a report in Excel.  Looks like this is possible, but also would require more time than I have to get you started.  (You would need background in Excel VBA as well as DIAdem vbs)  I will let the Ni experts take it from here.

Paul

[shruti.v]

Hi Leo,

Before I can dig deeper in to your issue could you please tell me what software environment did you create the tdv file in? Is it from Diadem or LabVIEW?

[Leillo]

Hi,

I am using Daidem 2012.

Thanks for your help.

Regards,

Leo

[Brad_Turpin]

Hi Leillo,

As far as I know, your only option in DIAdem 2012 is to create a picture file of the entire REPORT sheet and send that to Excel.

Brad Turpin

DIAdem Product Support Engineer

National Instruments

[Leillo]

Thanks Brad

[XavierBelgium]

Hi everyone,

I would like to know if it is possible to create a global image (format .PNG or JPEG) of a report with several sheets?

Is there a simple mean to export an entire Diadem report in an Excel sheet?

Thanks in advance for your help.

Regards,

Xavier

[Brad_Turpin]

Hi Xavier,

You need to create an image file for each REPORT sheet.  You can do so interactively with the "Save Selected Object or Layout as a Graphic" icon at the top of your REPORT panel, or you can programmatically export each sheet with the following commands:

Report.Settings.ImageExport.PNG.BitsPerPixel = 0
Report.Settings.ImageExport.PNG.UseRatio = True
Report.Settings.ImageExport.PNG.Height = 768
FOR Each Sheet In Report.Sheets
 Call Sheet.ExportToImage(ImageFilePathStem & " - " & Sheet.Name & ".PNG", eImageExportTypePNG)
NEXT ' Sheet

Brad Turpin

DIAdem Product Support Engineer

National Instruments

[XavierBelgium]

Hi Brad,

Thanks for your reply. My request is a little more specific.

I have a TDR with several sheets. Can I do only one png file for the entire report and not one png per sheet?

The goal is after to insert the png file inside an Excel sheet so I'd prefer one png for all report and not one png for each sheet.

Thanks for your help.

Regards,

Xavier