DTP


 
Lively discussions on the graphic arts and publishing — in print or on the web


Go Back   Desktop Publishing Forum > General Discussions > Print Production & Automation

Reply
 
Thread Tools Display Modes
Old 04-08-2007, 11:31 AM   #1
Clayton
Member
 
Join Date: Mar 2005
Location: Grand Junction, CO
Posts: 109
Default Making a PDF from a Multi-Sheet Excel File

Basically, I can't do it.

I select all sheets, then using Acrobat 6 all I get is the active sheet even though I specify printing the entire workbook or if I select multiple sheets.

If I select all sheets and use Jaws, I have to create each worksheet as a separate process and giving each worksheet a filename.

Am I overlooking something?

Excel 2000
Win XP
Clayton is offline   Reply With Quote
Old 04-08-2007, 11:47 PM   #2
Mike
Staff
 
Mike's Avatar
 
Join Date: Oct 2004
Location: Llanwrtyd Wells
Posts: 1,450
Default

If you can't print them all with a single print command then you probably can't make a single pdf directly.

Kathleen mentioned a pdf utility, pdfClerk, here a few days ago and something like that might help to to post-processs the resulting pdf files. pdfClerk is, I think, Mac only but there's undoubtedly something similar for PCs -- cue for a PC guru to jump in with the answer...

   
__________________
Mike

www.welshframing.com
Mike is offline   Reply With Quote
Old 04-09-2007, 05:31 AM   #3
ktinkel
Founding Sysop
 
ktinkel's Avatar
 
Join Date: Oct 2004
Location: In Connecticut, on the Housatonic River near its mouth at Long Island Sound.
Posts: 11,189
Default

Quote:
Originally Posted by Clayton View Post
I select all sheets, then using Acrobat 6 all I get is the active sheet even though I specify printing the entire workbook or if I select multiple sheets.
I do not know whether Acrobat can be made to do what you want, but it will allow you to assemble one PDF from many. It is not as elegant as what you seek, but it doesn’t take long, and should get the job done.

   
__________________
[SIZE=2][COLOR=LemonChiffon]::[/COLOR][/SIZE]
[SIGPIC][/SIGPIC]
ktinkel is offline   Reply With Quote
Old 04-09-2007, 11:19 AM   #4
Steve Rindsberg
Staff
 
Join Date: Nov 2004
Posts: 6,712
Default

I don't think you're overlooking anything ...

I'm pretty sure when Excel prints, it treats each sheet as a new print job rather than combining them all into one print job. It's not normally evident when printing because there's nothing to clue in the human where one print job ends and another begins.

But when something pops up and wants to put each print job in a new file, as is the case with Acrobat, you .. um ... notice.

You can open the first PDF doc in Acrobat then insert the subsequent ones to combine everything into one PDF.

   
__________________
Steve Rindsberg
====================
www.pptfaq.com
www.pptools.com
and stuff
Steve Rindsberg is offline   Reply With Quote
Old 04-10-2007, 12:23 AM   #5
LoisWakeman
Staff
 
LoisWakeman's Avatar
 
Join Date: Jan 2005
Location: Uplyme, Devon, England
Posts: 1,402
Default

In a word, No. Excel prints either a selection, or the current worksheet, so that's all Distiller can work on.

Rather than putting pages together manually after PDF creation, print each sheet to file, then use this little script to combine the PostScript files: just replace the italicised bits with your page size (this is A4; US letter is 612 792), file path and name:

%!
% PostScript program for distilling and combining multiple PostScript files.
<< /PageSize [595 842] >> setpagedevice

/prun { /mysave save def % Performs a save before running the PS file
dup = flush % Shows name of PS file being run
RunFile % Calls built in Distiller procedure
clear cleardictstack % Cleans up after PS file
mysave restore % Restores save level
} def


(full_path_to_files/file1.ps) prun

(full_path_to_files/file2.ps) prun

(full_path_to_files/file3.ps) prun

Just copy the above, edit it to suit, and save as a plain text file; then drop it onto Distiller and sit back watching the red propellor twiddling around!

I find it invaluable, for instance, one job I do has about 40 component Word files, and this distils the lot into a 400 page manual in a few minutes. And it avoids the errors you can get if using font subsetting when adding pages to an existing PDF.
LoisWakeman is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MS Excel--->HTML Linda Baldwin Web Design 12 07-12-2006 12:56 AM
Illustrator CS2 Multi-Page? Andrew B. Images 3 02-16-2006 04:03 AM
Master Style Sheet George Web Site Building & Maintenance 9 12-07-2005 05:41 PM
[PR] PageStream: Multi-platform DTP s/w ktinkel Print Design 0 05-01-2005 08:23 AM


All times are GMT -8. The time now is 11:35 AM.


Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Contents copyright 2004–2014 Desktop Publishing Forum and its members.