Problem in exporting xlsx to pdf

Question

Hi.
I wrote a program that creates an excel file and at the end of that file, it creates a chart from that data.
Then I export that file to pdf via ExportAsFixedFormat method but it just exports that chart to pdf.
How can I export the whole page to pdf?
(I use Office 2007)

Thanks

Majid Kamali · Answer

Thanks for answering but I found my answer. I should activate a arbitrary cell before exporting to pdf. because chart must be unselected. before my code, I used this: (myWorkSeet.Cells[1,1] as Excel.Range).Activate();

Javeed M Shaikh · Answer

Hi Majid, Please check if you are doing the same steps like below: string paramSourceBookPath = @"C:\MyExcel.xlsx"; object paramMissing = Type.Missing; string paramExportFilePath = @"C:\MyTestPdf.pdf"; XlFixedFormatType paramExportFormat = XlFixedFormatType.xlTypePDF; XlFixedFormatQuality paramExportQuality = XlFixedFormatQuality.xlQualityStandard; bool paramOpenAfterPublish = false; bool paramIncludeDocProps = true; bool paramIgnorePrintAreas = true; object paramFromPage = Type.Missing; object paramToPage = Type.Missing; try { // Open the source workbook. excelWorkBook = excelApplication.Workbooks.Open(paramSourceBookPath, paramMissing, paramMissing, paramMissing, paramMissing, paramMissing, paramMissing, paramMissing, paramMissing, paramMissing, paramMissing, paramMissing, paramMissing, paramMissing, paramMissing); // Save it in the target format. if (excelWorkBook != null) excelWorkBook.ExportAsFixedFormat(paramExportFormat, paramExportFilePath, paramExportQuality, paramIncludeDocProps, paramIgnorePrintAreas, paramFromPage, paramToPage, paramOpenAfterPublish, paramMissing); } catch (Exception ex) { // Respond to the error. } finally { // Close the workbook object. if (excelWorkBook != null) { excelWorkBook.Close(false, paramMissing, paramMissing); excelWorkBook = null; } // Quit Excel and release the ApplicationClass object. if (excelApplication != null) { excelApplication.Quit(); excelApplication = null; } GC.Collect(); GC.WaitForPendingFinalizers(); GC.Collect(); GC.WaitForPendingFinalizers(); } Please do not forget to mark "Accepted Answer".

Majid Kamali · Answer

I saw articles on the right side about iTextSharp, but they are not useful for me. I want to create a pdf from an existing excel file. Also I do not have enough time to learn iTextSharp. Please help.

Suthish Nair · Answer

If its a .Net application then why not using iTextSharp.dll