C# Discussion Boards - CodeProject

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

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

Re: Add XML to dll project

26-Feb-09 23:02

thank you verry mutch, so can i apply this code for a word file??

Add XML to dll project

Ronenb26-Feb-09 0:22

Ronenb

26-Feb-09 0:22

Hi I have console application that contain sub project define as dll,
I would like to add XML to the dll so the when I deliver the dll it already contain the xml without sending dll and xml separately
How can I add it?
Should I just select add item and then select the XML file?

Thanks
Ronen

Shyam K Pananghat26-Feb-09 0:32

AssemblyInfo Version Number

26-Feb-09 0:32

Add it as a linked resource to the dll which you are sending.
In Visual studio you can easily add a linked resource by going to project properties / Resources button. Click on the top first dropsown button to change ti to files and then you can easily add. Smile | :)

Shyam..

My Blog dotnetscoups.blogspot.com

David Muir26-Feb-09 0:19

David Muir

26-Feb-09 0:19

Hi All,

I am currently trying to figure out how the [assembly: AssemblyVersion("1.0.0.*")] works. In particular the * part of it. I understand about the Major Number, Minor Number and Build Number. What I don't understand is the Revision Number.

As it is * it automatically increments... however; what determines the revision number. I.e. where does it come from?

If anyone knows, I'd appreciate your thoughts,

Thanks

Smile | :)

Shyam K Pananghat26-Feb-09 0:27

26-Feb-09 0:27

It is nothing but the number of Build action. I suppose.

Shyam..

My Blog dotnetscoups.blogspot.com

David Muir26-Feb-09 0:34

David Muir

26-Feb-09 0:34

This is also what i expected... however; I dont understand how it is generated.

For example, the application i am currently working on requires it to be displayed.

I ran the appplication and the number that was displayed was 1.2.0.19976, I made a couple of changes and ran it again, then the new version number was 1.2.0.20068. I don't understand why it increments so much.

Smile | :)

Shyam K Pananghat26-Feb-09 0:39

26-Feb-09 0:39

Check how many time you hit F5, Build , Rebuild or Batch Build between the first and second run.

Shyam..

My Blog dotnetscoups.blogspot.com