Re: Transform Excel to PDF - C# Discussion Boards

26-Feb-09 0:30

Hello,

How we can transform a Excel file to PDF?

thank you verry mutch.

Shyam K Pananghat26-Feb-09 0:34

Shyam K Pananghat

26-Feb-09 0:34

May be you can do some tweaking by your own and use the pdfizer Smile | :)

http://sourceforge.net/projects/pdfizer[^]

Enjoy..

Shyam..

My Blog dotnetscoups.blogspot.com

abbd26-Feb-09 2:14

26-Feb-09 2:14

Thank you verry mutch, but i need to transform an excel file and not a htm file, help me please, thank you verry mutch.

modified on Thursday, February 26, 2009 8:32 AM

abbd26-Feb-09 2:32

26-Feb-09 2:32

You can write to a pdf file, even add images using PDFSharp:

<br />
XGraphics gfx2 = XGraphics.FromPdfPage(page2);<br />
gfx2.DrawRectangle(XPens.Black, XBrushes.LightGray, new XRect(40, 310, 500, 40));<br />
 gfx2.DrawImage(XImage.FromFile(@"C:\image1.jpg"), new XRect(30, 30, 100, 107));<br />
<br />

But to graft an Excel file in a pdf! I have not found how to do, help me please, thank you very much

Mirko198026-Feb-09 2:42

26-Feb-09 2:42

If you have Excel 2007 installed on the machine(s) where you want to do conversion, you can follow this link: Saving Workbooks to PDF and XPS Formats in Excel 2007[^]

abbd26-Feb-09 3:14

26-Feb-09 3:14

Thank you verry mutch for your help, i do like this :

<br />
 static void Main(string[] args)<br />
        {<br />
            ApplicationClass excelApplication = new ApplicationClass();<br />
            Workbook excelWorkBook = null;<br />
<br />
        <br />
<br />
            string paramSourceBookPath = @"C:\2.xlsx";<br />
            object paramMissing = Type.Missing;<br />
<br />
            string paramExportFilePath = @"C:\test.pdf";<br />
            XlFixedFormatType paramExportFormat = XlFixedFormatType.xlTypePDF;<br />
            XlFixedFormatQuality paramExportQuality =<br />
                XlFixedFormatQuality.xlQualityStandard;<br />
            bool paramOpenAfterPublish = false;<br />
            bool paramIncludeDocProps = true;<br />
            bool paramIgnorePrintAreas = true;<br />
            object paramFromPage = Type.Missing;<br />
            object paramToPage = Type.Missing;<br />
<br />
        <br />
<br />
        try<br />
        {<br />
            // Open the source workbook.<br />
            excelWorkBook = excelApplication.Workbooks.Open(paramSourceBookPath,<br />
                paramMissing, paramMissing, paramMissing, paramMissing,<br />
                paramMissing, paramMissing, paramMissing, paramMissing,<br />
                paramMissing, paramMissing, paramMissing, paramMissing,<br />
                paramMissing, paramMissing);<br />
<br />
            // Save it in the target format.<br />
            if (excelWorkBook != null)<br />
                excelWorkBook.ExportAsFixedFormat(paramExportFormat,<br />
                    paramExportFilePath, paramExportQuality,<br />
                    paramIncludeDocProps, paramIgnorePrintAreas, paramFromPage,<br />
                    paramToPage, paramOpenAfterPublish,<br />
                    paramMissing);<br />
        }<br />
        catch (Exception ex)<br />
        {<br />
            Console.WriteLine(ex.ToString());<br />
        }<br />
        finally<br />
        {<br />
            // Close the workbook object.<br />
            if (excelWorkBook != null)<br />
            {<br />
                excelWorkBook.Close(false, paramMissing, paramMissing);<br />
                excelWorkBook = null;<br />
            }<br />
<br />
            // Quit Excel and release the ApplicationClass object.<br />
            if (excelApplication != null)<br />
            {<br />
                excelApplication.Quit();<br />
                excelApplication = null;<br />
            }<br />
<br />
            GC.Collect();<br />
            GC.WaitForPendingFinalizers();<br />
            GC.Collect();<br />
            GC.WaitForPendingFinalizers();<br />
        }  <br />
<br />
<br />
        }<br />

But unfortunately, it doesn't work, help me please, thank you verry mutch.

Mirko198026-Feb-09 3:24

26-Feb-09 3:24

What error gives you?

abbd26-Feb-09 3:30

26-Feb-09 3:30

the error was:
System.ArgumentException: The value is not within the range expected.
à Microsoft.Office.Interop.Excel.WorkbookClass.ExportAsFixedFormat(XlFixedFormatType Type, Object Filename, Object Quality, Object IncludeDocProperties, Object IgnorePrintAreas, Object From, Object To, Object OpenAfterPublish, Object FixedFormatExtClassPtr)
à Excel_to_Pdf.Form1.Form1_Load(Object sender, EventArgs e) dans C:\Documents and Settings\Administrateur\Mes documents\Visual Studio 2005\Projects\Excel_to_Pdf\Excel_to_Pdf\Form1.cs:ligne 53.

Thank you verry mutch

Mirko198026-Feb-09 3:35

26-Feb-09 3:35

Probably you have not installed the Microsoft Save as PDF or XPS Add-in[^].
Installing it enables Office 2007 applications to save in PDF format.

abbd26-Feb-09 4:07

26-Feb-09 4:07

thank you verry mutch,it work for a xlsx file,but unfortunatelly not for xsl file, how i can resolve this problem? thank you verry mutch.

Mirko198026-Feb-09 4:40

26-Feb-09 4:40

I tried your code with a xls file and it appears to work. It was an xls made with Excel 2007, though...
As usual, what is the error?

abbd26-Feb-09 4:51

26-Feb-09 4:51

the error was :

System.Runtime.InteropServices.COMException (0x800A03EC): Exception de HRESULT : 0x800A03EC
à Microsoft.Office.Interop.Excel.WorkbookClass.ExportAsFixedFormat(XlFixedFormatType Type, Object Filename, Object Quality, Object IncludeDocProperties, Object IgnorePrintAreas, Object From, Object To, Object OpenAfterPublish, Object FixedFormatExtClassPtr)
à Excel_to_Pdf.Form1.Form1_Load(Object sender, EventArgs e) dans C:\Documents and Settings\Administrateur\Mes documents\Visual Studio 2005\Projects\Excel_to_Pdf\Excel_to_Pdf\Form1.cs:ligne 68

Thnak you verry mutch.

Mirko198026-Feb-09 4:56

26-Feb-09 4:56

No clue, sorry.
Try to search the error "System.Runtime.InteropServices.COMException (0x800A03EC): Exception from HRESULT : 0x800A03EC" in Google, hopefully someone already encountered (and solved) this error.

abbd26-Feb-09 5:05

26-Feb-09 5:05

I don't find the solution, i think that it must be transformed on XSLX, but how we can transform xsl to xslx with c#? thank you verry mutch.

Mirko198026-Feb-09 5:27

26-Feb-09 5:27

As I said, in my machine your code worked with an XSL, so maybe the problem is related to the document you are using.
Anyway, you can save an XLSX as XLS by using the SaveAs method on the workbook object and specifying XlFileFormat.xlWorkbookNormal as file format.

abbd26-Feb-09 5:55

26-Feb-09 5:55

i make this?

excelWorkBook.ExportAsFixedFormat(paramExportFormat,<br />
                       paramExportFilePath, paramExportQuality,<br />
                       paramIncludeDocProps, paramIgnorePrintAreas, paramFromPage,<br />
                       paramToPage, paramOpenAfterPublish,<br />
                       XlFileFormat.xlWorkbookNormal);

but i does not work, help me please, thank you verry mutch.

abbd26-Feb-09 6:29

26-Feb-09 6:29

i have often this error on message box :

Document not saved. The document may be open or an error occurred while recording.

in this code :

<br />
if (excelWorkBook != null)<br />
                    excelWorkBook.ExportAsFixedFormat(paramExportFormat,<br />
                    paramExportFilePath, paramExportQuality,<br />
                    paramIncludeDocProps, paramIgnorePrintAreas, paramFromPage,<br />
                    paramToPage, paramOpenAfterPublish,<br />
                    paramMissing);<br />

I am sur that the file was not open,

thank you verry mutch.

abbd26-Feb-09 23:02