Click here to Skip to main content
15,892,005 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Hi friends,
I am in one particular scenario in which I want to convert the Excel Sheets once the document is approved in workflow.

Below are my detailed Scenario?


1. They currently have Office 2003 + WSS 2.0 in place. Would like to upgrade to Office 2007 and MOSS 2007

2. Current Workflow: originator typically creates a purchase requisition spreadsheet using one of the available templates; selects about 5-7 people (lookup from global address book) that need to approve the document. Using in-built doc routing capabilities of Excel 2003, the doc is automatically routed to the people in the list for their approvals one by one. The document moves in a serial fashion - meaning, until person #1 approves, it doesn't move on to the next person. If approver approves, doc goes to the next person in list; if approver rejects, doc stops with them and they send an email/phone call to originator explaining the reason.

<b>3.Once the doc is approved, it is saved as PDF....Please help me out in this point.

8. Vision: Vision is to replicate this entire functionality using Office 2007 and MOSS 2007.


Can any body help me in converting the Excel Sheets documents into PDF [for storage so that no users can edit this],after it has been approved from its approvers.
Posted
Updated 28-Dec-09 23:22pm
v7

You will need one of the third-party PDF writer libraries. Try Google and choose the one that best suits your needs.
 
Share this answer
 
I think you might look into iTextSharp. Its the most popular and free, and you can write anything to PDF.

Use InterOp to read Excel sheets or use :
Working with MS Excel(xls / xlsx) Using MDAC and Oledb[^]

and write it to the PDF file using iTextSharp.
:cool:
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900