Solved

Single worksheets from multiple spreadsheets converted to 1 pdf file

Posted on 2011-09-08
2
215 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
2 Comments
 
LVL 6

Accepted Solution

by:
theKashyap earned 500 total points
Comment Utility
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
Comment Utility
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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Suggested Solutions

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

772 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now