Microsoft Excel is a trusted tool for organizing, calculating, and visualizing data. However, the process of converting spreadsheets into tangible documents can sometimes be less straightforward. This is where the Syncfusion Excel Library becomes invaluable, allowing you to print Excel documents without relying on any Microsoft Excel dependencies.
The Syncfusion Excel Library (Essential XlsIO) is a robust tool that facilitates the smooth creation, reading, and editing of Excel documents using C#. It supports Excel printing options by converting Excel files to PDF and printing that PDF document. The Excel document can be printed with a specified page setup and printer settings in XlsIO.
Let’s see how to print your Excel documents with the help of the Syncfusion Excel Library using C#!
Our XlsIO library supports converting an entire workbook or a single worksheet into a PDF document, using the Syncfusion Excel-to-PDF converter. You can also employ various customization options such as embedding fonts, ignoring empty pages or worksheets, and showing or hiding headers and footers. This process is fast, reliable, and supported in hosting environments such as AWS, Google Cloud App, and Microsoft Azure web services.
This comprehensive library supports the following key features:
First, we are going to create a new WPF application in Visual Studio.
Refer to the following image.
Then, add the following NuGet packages to your WPF app:
Add the required UI buttons for selecting Excel documents and performing the print operation in the MainWindow.xaml file.
Refer to the following code example.
<Window x:Name="Print_Excel" x:Class="PrintExcelDocuments.MainWindow"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
xmlns:local="clr-namespace:PrintExcelDocuments"
mc:Ignorable="d"
Title="MainWindow" Height="250" Width="532">
<Grid Margin="3,-1,0,-6" Background="#FFE0E4EB">
<Grid.ColumnDefinitions>
<ColumnDefinition Width="37*"/>
<ColumnDefinition Width="21*"/>
<ColumnDefinition Width="81*"/>
<ColumnDefinition Width="68*"/>
<ColumnDefinition Width="278*"/>
<ColumnDefinition Width="44*"/>
</Grid.ColumnDefinitions>
<Button Click="PrintExcel" Content="Print" HorizontalAlignment="Left" VerticalAlignment="Top" Width="110" Height="27" Margin="47,111,0,0" FontWeight="Bold" Grid.Column="3" Grid.ColumnSpan="2"/>
<Label Content="Select Excel File" HorizontalAlignment="Left" Margin="24,60,0,0" VerticalAlignment="Top" Width="114" Height="25" FontSize="14" Grid.ColumnSpan="3"/>
<TextBox Name="filePath" HorizontalAlignment="Left" Margin="4,61,0,0" TextWrapping="Wrap" VerticalAlignment="Top" Width="195" Height="24" Grid.Column="3" Grid.ColumnSpan="2"/>
<Button Content="Browse" HorizontalAlignment="Left" Margin="152,61,0,0" VerticalAlignment="Top" RenderTransformOrigin="0.5,0.5" Click="SelectFile" Width="68" Height="24" FontWeight="Bold" FontStyle="Italic" Grid.Column="4"/>
</Grid>
</Window> After executing the previous code example, the UI will look like the following image.
You can choose the Excel document by clicking Browse and then click Print to start the printing process.
Finally, add the following code in the MainWindow.xaml.cs file to convert the Excel document to PDF using the Syncfusion Excel-to-PDF converter and print the document.
using System.Drawing.Printing;
using System.Windows;
using Syncfusion.ExcelToPdfConverter;
using Syncfusion.XlsIO;
namespace PrintExcelDocuments
{
/// <summary>
/// Interaction logic for MainWindow.xaml
/// </summary>
public partial class MainWindow : Window
{
public MainWindow()
{
InitializeComponent();
}
private void SelectFile(object sender, RoutedEventArgs e)
{
//Initializes FileSavePicker.
Microsoft.Win32.OpenFileDialog openFileDialog = new Microsoft.Win32.OpenFileDialog();
openFileDialog.Filter = "Excel Files|*.xls;*.xlsx;*.xlsm,*.xltm,*.csv,*.tsv";
openFileDialog.Title = "Select a Excel File";
openFileDialog.ShowDialog();
//Gets the path of specified file.
filePath.Text = openFileDialog.FileName;
}
private void PrintExcel(object sender, RoutedEventArgs e)
{
using (ExcelEngine excelEngine = new ExcelEngine())
{
IApplication application = excelEngine.Excel;
application.DefaultVersion = ExcelVersion.Xlsx;
//Loads or opens an existing workbook through Open method of IWorkbooks.
IWorkbook workbook = application.Workbooks.Open(filePath.Text);
//Initialize the printer settings.
PrinterSettings printerSettings = new PrinterSettings();
//Customizing the printer settings.
printerSettings.PrinterName = "HP LaserJet Pro MFP M127-M128 PCLmS";
printerSettings.Copies = 2;
printerSettings.FromPage = 1;
printerSettings.ToPage = 3;
printerSettings.DefaultPageSettings.Color = true;
printerSettings.Duplex = Duplex.Vertical;
printerSettings.Collate = true;
ExcelToPdfConverter converter = new ExcelToPdfConverter(workbook);
converter.Print();
}
}
}
} The following image shows the input Excel document.
By executing this code example, you will get a printed Excel document as shown in the following image.
For more details, refer to the print Excel documents using C# documentation and GitHub demos.
Thanks for reading! In this blog, we explored the steps involved in printing Excel documents using C# with the Syncfusion Excel Library. Additionally, we learned how to convert an Excel document to a PDF document in C# using our Syncfusion Excel-to-PDF converter library. With Essential XlsIO, you also have the ability to export Excel data to images, data tables, CSV, TSV, HTML, collections of objects, ODS , JSON, and other file formats.
Feel free to try out these methods and share your feedback in the comments section of this blog post!
For existing customers, the new version of Essential Studio® is available for download from the License and Downloads page. If you are not yet a Syncfusion customer, you can try our 30-day free trial to check out our available features.
For questions, you can contact us through our support forum, support portal, or feedback portal. We are happy to assist you!