{"id":823,"date":"2016-07-11T08:35:34","date_gmt":"2016-07-11T08:35:34","guid":{"rendered":"http:\/\/mindfusion.eu\/blog\/?p=823"},"modified":"2021-01-20T17:44:30","modified_gmt":"2021-01-20T17:44:30","slug":"mindfusion-spreadsheet-convert-xlsx-to-pdf-2","status":"publish","type":"post","link":"https:\/\/mindfusion.dev\/blog\/mindfusion-spreadsheet-convert-xlsx-to-pdf-2\/","title":{"rendered":"MindFusion WinForms Spreadsheet Control: Convert XLSX to PDF"},"content":{"rendered":"

This blog demonstrates how easily you can convert XLSX<\/a> files to PDF using the Windows Forms<\/a> Spreadsheet control.<\/p>\n

Setup<\/strong><\/p>\n

Create a new WinForms application<\/a> and add the necessary assemblies to the project. Add a WorkbookView<\/a> control to the main application window. Note, that this is not necessary for the conversion – it is done only to display the original XLSX file.<\/p>\n

Perform the conversion<\/strong><\/p>\n

Add a button to the main form, set its text to ‘Convert…’ and handle its Click event. In the event handler display an OpenFileDialog to query the user for the input XLSX file, then display a SaveFileDialog to request the target PDF file. Once the two files are specified, proceed with the conversion by creating an ExcelImporter<\/a> and PdfExporter<\/a> objects and using their Import<\/a> and Export<\/a> methods in succession:<\/p>\n

\/\/ Import the data\nvar importer = new ExcelImporter();\nimporter.Import(xlsxPath, workbook1);\n\n\/\/ Export the worksheet as PDF\nvar exporter = new PdfExporter();\nexporter.EnableGridLines = true;\nexporter.Export(workbook1.Worksheets[0], pdfPath);\n\n\/\/ Open the PDF\nSystem.Diagnostics.Process.Start(pdfPath);<\/pre>\n
The xlsxPath<\/em> and pdfPath<\/em> variables identify the respective XLSX and PDF file names. The workbook1<\/em> variable represents the Workbook displayed on the form. Once the conversion is complete, the PDF file is opened in the default PDF viewer by calling Process.Start.<\/p>\n
The following image illustrates the result:<\/p>\n
<\/a><\/p>\n
The source code of the project together with all necessary libraries can be downloaded from here:<\/p>\n
Convert .XLSX to .PDF Files Using the WinForms Spreadsheet Control: Download Sample<\/a><\/p>\n
You are welcome to ask any questions about the WorkbookView<\/a> control at MindFusion discussion board<\/a> or per e-mail at support@mindfusion.dev<\/a>.<\/p>\n
Click here here<\/a> to visit the official page of the MindFusion WinForms Spreadsheet control.<\/p>\n
We hope you find this tutorial useful and thank you for your interest in MindFusion developer tools.<\/p>\n","protected":false},"excerpt":{"rendered":"
This blog demonstrates how easily you can convert XLSX files to PDF using the Windows Forms Spreadsheet control. Setup Create a new WinForms application and add the necessary assemblies to the project. Add a WorkbookView control to the main application … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false},"version":2}},"categories":[74,163],"tags":[221,165,30,164,166,192,172],"class_list":["post-823","post","type-post","status-publish","format-standard","hentry","category-sample-code","category-spreadsheet","tag-convert","tag-excel","tag-pdf","tag-spreadsheet-2","tag-workbook","tag-worksheet","tag-xlsx"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p3RlKs-dh","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/mindfusion.dev\/blog\/wp-json\/wp\/v2\/posts\/823","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mindfusion.dev\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mindfusion.dev\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mindfusion.dev\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/mindfusion.dev\/blog\/wp-json\/wp\/v2\/comments?post=823"}],"version-history":[{"count":6,"href":"https:\/\/mindfusion.dev\/blog\/wp-json\/wp\/v2\/posts\/823\/revisions"}],"predecessor-version":[{"id":2597,"href":"https:\/\/mindfusion.dev\/blog\/wp-json\/wp\/v2\/posts\/823\/revisions\/2597"}],"wp:attachment":[{"href":"https:\/\/mindfusion.dev\/blog\/wp-json\/wp\/v2\/media?parent=823"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mindfusion.dev\/blog\/wp-json\/wp\/v2\/categories?post=823"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mindfusion.dev\/blog\/wp-json\/wp\/v2\/tags?post=823"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}