generating bulk pdf using excel

Question

0.00/5 (No votes)

See more:

Hi guys,
Can anyone help me to generate a macro using c#. I want that macro to be enabled after selecting 2 columns and generate pdf files with a particular format as follows:

FILE 1

XYZ School,USA
Name ValueOfColumn1&Row1

Age ValueOfColumn2&Row1

FILE 2

XYZ School,USA
Name ValueOfColumn1&Row2

Age ValueOfColumn2&Row2

Please help me out!
Thanks,
Akkywadhwa

Posted 5-Jan-13 1:58am

Akkywadhwa

Add a Solution

Comments

Zoltán Zörgő 6-Jan-13 6:10am

Any progress?

Akkywadhwa 15-Jan-13 4:49am

Nopes!

1 solution

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)

**Zoltán Zörgő** · Answer 1 · 2013-01-05T03:32:00

Macro using c#? C# is not a macro language - you either do your job using Excel VBA or C#... From Excel 2007 and above you can export to PDF without any external component, but you need to make your "file" as a sheet of the workbook to look as you desire. Than you can change the worksheet's content and generate the pdf's one by one. Here is a sample of how to use VBA to export to PDF: http://excelvbaandmacros.blogspot.hu/2012/01/excel-create-pdf-from-excel-worksheet.html[^], related official support: http://msdn.microsoft.com/en-us/library/office/ee834871(v=office.11).aspx[^].