03-28-2016 12:31 AM
Hi,
I am having one xl with three sheet, i want to create pdf from that excel.
I tried and i am getting pdf with single sheet only.
I want pdf with all three sheet.
How to od that?
Please suggest the possible ways.
03-28-2016 04:29 AM
Strange way: save all pages on different PDF and Concatenate PDF files with Exaprom iTextSharp
Difficult way:
03-28-2016 08:27 AM
What you need to be able to do is to select "Print Entire Workbook" in the Print options. However, the Report Generator's Print Report function doesn't seem to include this possibility. Maybe there is a way to set this with ActiveX (a technology that Microsoft seems to be abandoning) ...
Bob Schor
03-28-2016 10:22 AM - edited 03-28-2016 10:23 AM
@Bob_Schor wrote:What you need to be able to do is to select "Print Entire Workbook" in the Print options. However, the Report Generator's Print Report function doesn't seem to include this possibility. Maybe there is a way to set this with ActiveX (a technology that Microsoft seems to be abandoning) ...
Bob Schor
I abandoned ActiveX years ago, after spending weeks with National Instruments trying to get one of their own ActiveX examples to work reliably across several target machines.
There are just too may subtle differences in Windows, Office, and ActiveX that can cause a program that runs fine on one PC to crash on another.
03-28-2016 10:31 PM
RTSLVU (how do you pronounce that, anyway?),
I completely agree with you. Before NI introduced the Report Object version of the RGT, I struggled with the version that shipped with LabVIEW 7, which was slooooooowwwww. In desperation, I "learned" enough ActiveX to do simple things (much faster), but was so glad when NI introduced Report Objects and functions that "do most of what you need" without needing ActiveX.
There was a suggestion to print three PDFs using LabVIEW and the RGT, then combine them with some other code. There's a "switch" (setting?) in the Print setup that allows you to print All Sheets, but the RGT Print routine doesn't seem to have a "hook" to turn that on. I don't know if (or how to) there is an ActiveX "way", but I agree it will be messy and uncertain.
I wonder -- can one write an Excel Macro to do this? I think there is a way to define and run a Macro using the RGT. The question for the Original Poster is --- do you think it is worth the Effort? If you do manage to figure it out, be sure to document it, as (a) you'll forget three months after you do it how you did it, and (b) someone just looking at your (undocumented) code is going to have a difficult time figuring out what, and why, you are doing what you are doing.
Bob Schor
"A Fool's Errand and His Money Are Soon Parted" [I just made that up -- I have no idea what it means ...]