Spire.Office 9.5.0 for .NET

Spire.Office for .NET is a combination of Enterprise-Level Office .NET API offered by E-iceblue. It includes Spire.Doc, Spire.XLS, Spire.Spreadsheet, Spire.Presentation, Spire.PDF, Spire.DataExport, Spire.OfficeViewer, Spire.PDFViewer, Spire.DocViewer, Spire.Barcode and Spire.Email. Spire.Office contains the most up-to-date versions of the above .NET API.

With Spire.Office for .NET, developers can create a wide range of applications. It enables developers to open, create, modify, convert, print, View MS Word, Excel, PowerPoint and PDF documents. Furthermore, it allows users to export data to popular files such as MS Word/Excel/RTF/Access, PowerPoint, PDF, XPS, HTML, XML, Text, CSV, DBF, Clipboard, SYLK, PostScript, PCL, etc.

Spire.Office for .NET can be linked into any type of a 32-bit or 64-bit .NET application including ASP.NET, Web Services and WinForms for .NET Framework version 2.0 to 4.5. Spire.Office also supports to work on .NET Core, .NET 5.0, .NET 6.0, Microsoft Azure, Mono Android and Xamarin.iOS.

the release of Spire.Office 9.5.0. In this version, Spire.Doc supports converting Word to PDF while retaining form fields, Spire.XLS supports finding cells based on regular expressions, Spire.Presentation supports setting spacing between two columns. Meanwhile, tons of known issues have been fixed. More details are listed below.

In this version, the most recent versions of Spire.Doc, Spire.PDF, Spire.XLS, Spire.Presentation, Spire.Email, Spire.DocViewer, Spire.PDFViewer, Spire.Spreadsheet, Spire.OfficeViewer, Spire.DataExport, and Spire.Barcode are included.

DLL Versions:

• Spire.Doc.dll v12.5.5.0
• Spire.Pdf.dll v10.5.5.0
• Spire.XLS.dll v14.5.3.0
• Spire.Presentation.dll v9.5.3.0
• Spire.Barcode.dll v7.2.9.0
• Spire.Email.dll v6.5.10.0
• Spire.DocViewer.Forms.dll v8.7.10.0
• Spire.PdfViewer.Asp.dll v7.12.14.0
• Spire.PdfViewer.Forms.dll v7.12.14.0
• Spire.Spreadsheet.dll v7.4.6.0
• Spire.OfficeViewer.Forms.dll v8.7.12.0
• Spire.DataExport.dll 4.9.0.0
• Spire.DataExport.ResourceMgr.dll v2.1.0

Here is a list of changes made in this release

Spire.Doc

ToPdfParameterList.PreserveFormFields = true;

Document.LayoutOptions.CommentDisplayMode = CommentDisplayMode.ShowInAnnotations;

Spire.PDF

Spire.XLS

//Load image
System.Drawing.Image bufferedImage = System.Drawing.Image.FromFile(inputFile_Img);

//Set image on first page header and footer
wb.Worksheets[0].PageSetup.FirstLeftHeaderImage = bufferedImage;
wb.Worksheets[0].PageSetup.FirstLeftFooterImage = bufferedImage;
wb.Worksheets[1].PageSetup.FirstCenterHeaderImage = bufferedImage;
wb.Worksheets[1].PageSetup.FirstCenterFooterImage = bufferedImage;
wb.Worksheets[2].PageSetup.FirstRightHeaderImage = bufferedImage;
wb.Worksheets[2].PageSetup.FirstRightFooterImage = bufferedImage;

Worksheet worksheet = workbook.Worksheets[0];
string Information = null;
foreach (CellRange range in worksheet.ActiveSelectionRange)
{
Information += "RangeAddressLocal:"+ range.RangeAddressLocal+"\r\n";
Information += "ColumnCount:" + range.ColumnCount + "\r\n";
Information += "ColumnWidth:" + range.ColumnWidth + "\r\n";
Information += "Column:" + range.Column + "\r\n";
Information += "RowCount:" + range.RowCount+ "\r\n";
Information += "RowHeight:" + range.RowHeight + "\r\n";
Information += "Row:" + range.Row + "\r\n";
}
File.WriteAllText(outputFile_TXT,Information);

CellRange[] ranges = sheet.FindAllString(".*test.", false, false, true);

Spire.Presentation

//The unit is point
shape.TextFrame.ColumnSpacing = 20.50f;