• Post Reply Bookmark Topic Watch Topic
  • New Topic

excel to pdf in one page  RSS feed

 
Ravs Sharma
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I have an excel sheet with just one sheet containing text and images and fixed format.

I want to export the excel sheet into PDF. I started working on it using itext to created pdf however its creating multiple pages and the users want the 1 page pdf just like Microsoft excel's save as pdf (1 page) works.

Appreciate your help/suggestion.

Thanks,
Ravi
 
Paul Clapham
Sheriff
Posts: 22835
43
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Welcome to the Ranch, Ravi!

I didn't know that Excel had a save-as-PDF option. So I tried it with a large spreadsheet and sure enough, PDF is one of the many save-as options. But when it finally finished, it was 3,587 pages and not 1 page. And there wasn't any dialog box asking about options for the PDF about to be produced. So I'm a bit mystified about what you're doing to save a document as one page.

I'm also a bit mystified about what my large spreadsheet would look like as a single page. I'm pretty sure I wouldn't like it.
 
Ravs Sharma
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Paul Clapham wrote:Welcome to the Ranch, Ravi!

I didn't know that Excel had a save-as-PDF option. So I tried it with a large spreadsheet and sure enough, PDF is one of the many save-as options. But when it finally finished, it was 3,587 pages and not 1 page. And there wasn't any dialog box asking about options for the PDF about to be produced. So I'm a bit mystified about what you're doing to save a document as one page.

I'm also a bit mystified about what my large spreadsheet would look like as a single page. I'm pretty sure I wouldn't like it.


check the below  link

http://www.novapdf.com/kb/printing-an-entire-excel-workbook-to-a-single-pdf-file-135.html
 
Dave Tolls
Ranch Foreman
Posts: 3068
37
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
That link is about creating a single PDF file, not a single page PDF.

Are you saying your code produces multiple files?
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!