Convert Excel(.xls) file to .pdf File

Question

1.00/5 (1 vote)

See more:

hi,

i have a excel sheet(.xls) and i want to convert that excel sheet into .pdf i try to solve and goggling but i not get a any proper way to do this in mostly solution they are used a third-party tool so any other way to do this please tel me if any one have idea regarding this or any useful link for do this.

Thanks.

Posted 3-Jun-13 1:26am

bhavesh002

Add a Solution

Comments

Aydin Homay 3-Jun-13 7:32am

Hi please check this link:
Convert Excel(.xls) file to .pdf File Using iTextsharp[^]

Maciej Los 3-Jun-13 7:32am

Install virtual printer ;)
Google with: "pdf printer free"

bhavesh002 3-Jun-13 7:36am

i want this task using coding

Maciej Los 3-Jun-13 7:37am

You did not provide any information about your programming language...

bhavesh002 3-Jun-13 9:20am

i use .net programing language

Maciej Los 3-Jun-13 10:05am

Wow, i didn't know, that exists universal .net programming language...
VB.NET, C#, C++, which one?

bhavesh002 4-Jun-13 2:20am

asp.net version 4.0

Maciej Los 4-Jun-13 2:30am

@bhavesh002, ASP.NET is not a language at all! It's a technology, framework, etc.
Have a look here: http://en.wikipedia.org/wiki/ASP.NET[^]

bhavesh002 4-Jun-13 4:07am

c#.net

Maciej Los 4-Jun-13 4:09am

Finally!
Have you seen solution1?

bhavesh002 4-Jun-13 4:15am

i try below link and convert excel to pdf successfully

http://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.workbook.exportasfixedformat.aspx

but now my problem is that in my excel sheet 3 worksheet sheet1,sheet2 and sheet3 this code convert all sheet in a one pdf if i want to sheet1,sheet2 and sheet3 as a individual how i pass path of particular excel sheet with worksheet??

any idea about this??

if you have any idea or any useful artical link please share with me.

thanks.

Maciej Los 4-Jun-13 4:35am

There is no problem to convert each sheet into separate pdf file, because Worksheet interface provides the same method as Workbook interface. See this: http://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.worksheet.exportasfixedformat.aspx[^]

bhavesh002 4-Jun-13 5:07am

main link for this:
http://msdn.microsoft.com/en-us/library/bb407651%28v=office.12%29.aspx[^]

bhavesh002 4-Jun-13 4:46am

suppose i have a one excel file with name xyz.xls ans in that excel file 3(three) worksheet A,B and C and i want to create pdf of only B worksheet how i pass parameter "paramSourceBookPath"

excelWorkBook = excelApplication.Workbooks.Open(paramSourceBookPath,
paramMissing, paramMissing, paramMissing, paramMissing,
paramMissing, paramMissing, paramMissing, paramMissing,
paramMissing, paramMissing, paramMissing, paramMissing,
paramMissing, paramMissing);

currenty i pass @"C:\xyz.xls" but it crtae all tree A, B,c as a combine in one Pdf But i dont want A and C i need Only B worksheet as a pdf.

Maciej Los 4-Jun-13 5:33am

Please, follow the above link and read it carefully.
Filename (parameter)
Type: Object

The full path of the new PDF or XPS file. If you omit this parameter, Excel saves the file in the current folder.
But if you want to pass the name for new pdf file, use these properties:
Workbook.FullName[^]
Worksheet.Name[^]

bhavesh002 4-Jun-13 5:46am

ok i try

bhavesh002 4-Jun-13 7:14am

// Open the source workbook.
excelWorkBook = excelApplication.Workbooks.Open(paramSourceBookPath,
paramMissing, paramMissing, paramMissing, paramMissing,
paramMissing, paramMissing, paramMissing, paramMissing,
paramMissing, paramMissing, paramMissing, paramMissing,
paramMissing, paramMissing);

// get all sheets in workbook

Microsoft.Office.Interop.Excel.Sheets excelSheets = excelWorkBook.Worksheets;

// get some sheet
string currentSheet = "Data";
Microsoft.Office.Interop.Excel.Worksheet excelWorksheet =(Microsoft.Office.Interop.Excel.Worksheet)excelSheets.get_Item(currentSheet);

yes i done using above code

thanx.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sergey Alexandrovich Kryukov · Answer 1 · 2013-06-03T03:47:00

Solution 1

Please see my past answer: Question Convert word to PDF without offce or openoffice[^].

And, in case you cannot use Open XML file formats, also those three answers:
Convert Office-Documents to PDF without interop[^],
Need a rather unique WPF text editor control[^],
Read a word file without using Interop.word dll...Do not want to install word in IIS..[^].

—SA

Posted 3-Jun-13 3:47am

Sergey Alexandrovich Kryukov

Updated 3-Jun-13 3:49am

v2

Comments

Maciej Los 4-Jun-13 4:38am

Good suggestion. My 5!

Sergey Alexandrovich Kryukov 4-Jun-13 9:00am

Thank you, Maciej.
—SA

Maciej Los · Answer 2 · 2013-06-03T22:37:00

bhavesh002 wrote:

i try below link and convert excel to pdf successfully http://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.workbook.exportasfixedformat.aspx[^] but now my problem is that in my excel sheet 3 worksheet sheet1,sheet2 and sheet3 this code convert all sheet in a one pdf if i want to sheet1,sheet2 and sheet3 as a individual how i pass path of particular excel sheet with worksheet?? any idea about this?? if you have any idea or any useful artical link please share with me. thanks.

Maciej Los wrote:

There is no problem to convert each sheet into separate pdf file, because Worksheet interface provides the same method as Workbook interface. See this: http://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.worksheet.exportasfixedformat.aspx[^]