Generate PDF file with "Excel Report"

[sjean]

Hello,

I'm using the instrument "excelreport.fp" to generate excel files and then print these excels file with a pdf printer. This instrument uses  "Microsoft Excel 9.0 Object Library" which doesn't offer possibility to directly save excel file under .pdf format.

This functionnality is available in newer Excel ActiveX controller like  "Microsoft Excel 14.0 Object Library". 

My question is: is there a new revision of "excelreport.fp" instrument which includes this functionnality?

Because, the high level of this instrument is very usefull for my application and I would like to avoid to completly develop the same kind of API using "Microsoft Excel 14.0 Object Library".

Thanks a lot for your help.

[Johannes_T]

Hello, sjean!

Although the current version of Excel Report FP doesn't include this functionality, here are some ideas:

• The Excel Report FP is simply a wrapper around the Microsoft Excel Object Library, but only includes access to basic functionality.
• However, you can extend this API to suite your needs.
• If the newer version of the Microsoft Excel Object Library includes this functionality, than you can implement access to it inside the instrument.
• This is just a supposion: in an older version of Microsoft Excel Object Library, you implement a method which prints the excel report using the PDF printer.

Here are some links:

• https://forums.ni.com/t5/LabWindows-CVI/Excel-read-in-CVI/td-p/2281072
• http://forums.ni.com/t5/forums/searchpage/tab/message?location=forum-board%3A180&q=word+report
• http://forums.ni.com/t5/forums/searchpage/tab/message?location=forum-board%3A180&q=excel+report

Best regards!

- Johannes

[arronlee]

How about using some 3rd party [url=http://www.pqscan.com/convert-pdf/][color=black]PDF converter[/color][/url]?