?
Solved

Single worksheets from multiple spreadsheets converted to 1 pdf file

Posted on 2011-09-08
2
Medium Priority
?
222 Views
Last Modified: 2012-05-12
I have 3 Excel files.  I want to select one worksheet (tab) from each file and save it as a single pdf.  Is this possible?
0
Comment
Question by:3wits
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 6

Accepted Solution

by:
theKashyap earned 2000 total points
ID: 36505287
Programatically? Manually?
Manually, you can always just install some pdf creator (CutePdf, Bullzip, Nitro,...), then open all 3 excels and print required sheets one by one. Bullzip and Nitro both support "appending to existing file" option.
0
 
LVL 3

Expert Comment

by:evedder
ID: 36505311
well you can drag the sheets between workbooks, so you can drag the tabs you need into 1 single workbook, then in print configuration you can select "print all workbook" and then you print it as a pdf,

if you are looking for a programatic solution you can use java (POI and Itext) or even php
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question