Printing excel is supported and new features to operate pivot table are added in Spire.XLS
Join the DZone community and get the full member experience.Join For Free
E-iceblue is proud to announce Spire.XLS supports the important feature of printing excel files now. Several new features to operate pivot table are added in the latest version as well.
Spire.XLS for .NET is a professional Excel .NET component that can be used to any type of .NET 2.0, 3.5, 4.0 or 4.5 framework applications. This standalone library offers support both for the old Excel 97-2003 format (.xls) and for the new Excel 2007,Excel 2010 and Excel 2013 (.xlsx, .xlsb, .xlsm), along with Open Office (.ods) format. It features fast and reliably compared to developing your own spreadsheet manipulation solution or using Microsoft Automation.
This library has powerful conversion ability and it enables converting Excel files to most common and popular formats: Excel to HTML/XML/CSV, XML/CSV to Excel; Excel to Image/Txt/PDF.
With Spire.XlS, users can freely operate worksheets:
Create and edit Excel;
Find and Replace Data;
Import/Export data from a DataTable, DataView, Array, DataGrid etc;
Save Excel to file/Stream or as web response;
Read and write hyperlinks;
Insert/Delete or Hide Rows, Columns and Sheets;
Calculate Complex Excel Formula;
Protect/Unprotect Worksheets Merge data into Excel with MarkerDesigner
Recently we’ve added new features to Spire.XLS:
1. Print Excel worksheets in C#.
2. Operate Pivot table in Excel worksheet with C# code, such as expand/collapse the rows, read value in a row, insert blank rows as a header in an existing Pivot Table, etc.
3. More elements in Excel file can be converted to PDF successfully, such as chart, shape, smart art, Pivot table and etc.
You are welcome to check and evaluate our Spire.XLS from the URL below:
Database Pivot table Printing
Opinions expressed by DZone contributors are their own.