DEV Community

Cover image for How to Convert Excel to PDF in ASP.NET Core using the Excel Library
Arun for Syncfusion, Inc.

Posted on

1

How to Convert Excel to PDF in ASP.NET Core using the Excel Library

Learn how to convert Excel to PDF in ASP.NET Core using the Syncfusion Excel Library. In this video, I will demonstrate how to integrate the Syncfusion Excel to PDF converter with an ASP.NET Core application using Visual Studio. I will also demonstrate how to convert an Excel document into a PDF file.

Syncfusion Essential XlsIO is a high-performance and feature-rich .NET Excel framework. This framework has an Excel creation and editing library that allows you to create, read, and edit Microsoft Excel files in.NET applications. It also offers an Excel-inspired Spreadsheet UI control to create, edit, view, and format Excel documents. Its powerful conversion APIs make it easy to convert Excel files to PDF, images, and more.

You can convert an Excel workbook or worksheet to PDF format. Use various customization options, like embedding fonts, ignoring empty pages or worksheets, showing or hiding headers, and footers. This Library supports import and export of data and formulas. Import and edit existing Excel files in the Spreadsheet control. Spreadsheets can be exported to XLS, XLSX, CSV, and PDF file formats. More than 400 Excel-compatible functions are supported, such as cross-sheet references, named ranges, table formulas, and formulas. Users can create and manipulate tables, Pivot Tables, Charts, and Sparklines.

This Library is also used to fill data using Template Markers, clone and merge Excel worksheets, and encrypt and decrypt Excel documents. The Spreadsheet control provides a variety of text and number formatting options along with conditional formatting to improve the appearance and effectiveness of spreadsheet. The Spreadsheet control supports on-demand data loading when bound to data sources. It improves initial loading time by requesting only the visible data from the data source. It also allows you to perform various kinds of data processing such as data validation, sorting, and filtering.

Product overview: https://www.syncfusion.com/document-processing/excel-framework/net-core

Tutorial video: https://www.syncfusion.com/tutorial-videos

Download examples from GitHub: https://github.com/SyncfusionExamples/XlsIO-Examples/tree/master/Getting%20Started/ASP.NET%20Core/Convert%20Excel%20to%20PDF

AWS Q Developer image

Your AI Code Assistant

Generate and update README files, create data-flow diagrams, and keep your project fully documented. Built to handle large projects, Amazon Q Developer works alongside you from idea to production code.

Get started free in your IDE

Top comments (0)

Qodo Takeover

Introducing Qodo Gen 1.0: Transform Your Workflow with Agentic AI

Rather than just generating snippets, our agents understand your entire project context, can make decisions, use tools, and carry out tasks autonomously.

Read full post

πŸ‘‹ Kindness is contagious

Please leave a ❀️ or a friendly comment on this post if you found it helpful!

Okay