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.
美丽分界线/美丽分界线_____________________________
Spire.Office for Java is a combination of Enterprise-Level Office Java APIs offered by E-iceblue. It includes Spire.Doc for Java, Spire.XLS for Java, Spire.Presentation for Java, Spire.PDF for Java and Spire.Barcode for Java.
Developers can use Spire.Office for Java to perform a wide range of office document operations in Java applications, such as opening, creating, modifying, converting and printing Word, Excel, PowerPoint and PDF documents, generating and scanning 1D&2D barcodes.
As an independent Office Java library, Spire.Office for Java doesn't need Microsoft Office to be installed on either the development or target systems.文章来源：https://uudwc.com/A/La0Eo
文章来源地址https://uudwc.com/A/La0Eo
| Java | ||
| Spire.XLS for Java | ||
| Category | ID | Description |
| New feature | SPIREXLS-4731 | Optimizes the conversion time from Excel to PDF. |
| New feature | SPIREXLS-4852 | Adds the function of finding cells based on regular expressions. |
| Bug | SPIREXLS-3760 | Fixes the issue that the program threw "sun.security.x509.X509CertImpl" exception when using spire.xls.jar under IBM websphere. |
| Bug | SPIREXLS-4873 | Fixes the issue that the program threw "Input string was not in the correct format" exception when loading documents. |
| Spire.PDF for Java | ||
| Category | ID | Description |
| Bug | SPIREPDF-6241 | Fixes the issue that the characters overlapped when converting OFD to PDF. |
| .NET | ||
| Spire.Doc | ||
| Category | ID | Description |
| New feature | SPIREDOC-9057 | Supports converting math formulas to OfficeMathMLCode. |
| Document doc = new Document(); | ||
| doc.LoadFromFile("1.docx"); | ||
| StringBuilder stringBuilder = new StringBuilder(); | ||
| foreach (Section section in doc.Sections) | ||
| { | ||
| foreach (Paragraph par in section.Body.Paragraphs) | ||
| { | ||
| foreach (DocumentObject obj in par.ChildObjects) | ||
| { | ||
| OfficeMath omath = obj as OfficeMath; | ||
| if (omath == null) continue; | ||
| string mathml = omath.ToOfficeMathMLCode(); | ||
| stringBuilder.Append(mathml); | ||
| stringBuilder.Append("\r\n"); | ||
| } | ||
| } | ||
| } | ||
| File.WriteAllText("1.txt", stringBuilder.ToString()); | ||
| doc.Close(); | ||
| New feature | SPIREDOC-9710 | Supports adding hyperlinks to images in mail merge. |
| Document doc = new Document(); | ||
| doc.LoadFromFile("Test.docx"); | ||
| var fieldNames = new string[] { "MyImage" }; | ||
| var fieldValues = new string[] { "logo.png" }; | ||
| doc.MailMerge.MergeImageField += new MergeImageFieldEventHandler(MailMerge_MergeImageField); | ||
| doc.MailMerge.Execute(fieldNames, fieldValues); | ||
| doc.SaveToFile("result.docx", FileFormat.Docx); | ||
| } | ||
| void MailMerge_MergeImageField(object sender, MergeImageFieldEventArgs field) | ||
| { | ||
| string filePath = field.FieldValue as string; | ||
| if (!string.IsNullOrEmpty(filePath)) | ||
| { | ||
| field.Image = Image.FromFile(filePath); | ||
| field.ImageLink = "https://www.e-iceblue.com/"; | ||
| } | ||
| } | ||
| New feature | SPIREDOC-9778 | Improves the efficiency of document storage. |
| Bug | SPIREDOC-9769 | Fixes the issue that the content layout of the result documents generated in .NET 7.0 projects was incorrect. |
| Bug | SPIREDOC-6013 | Fixes the issue that loading Word documents threw a System.InvalidOperationException exception. |
| Bug | SPIREDOC-8541 | Fixes the issue that converting Word to PDF caused inconsistent pagination. |
| Bug | SPIREDOC-8587 | Fixes the issue that converting Word to PDF threw a System.NullReferenceException exception. |
| Bug | SPIREDOC-9197 | Fixes the issue that exporting Docx files from Sparrow and converting them to HTML files failed. |
| Bug | SPIREDOC-9213 | Fixes the issue that page number fields could not be automatically updated after insertion. |
| Bug | SPIREDOC-9253 | Fixes the issue that list characters were displayed incorrectly when converting HTML to Doc. |
| Bug | SPIREDOC-9310 | Fixes the issue that line break tags were ignored when converting HTML to Doc. |
| Bug | SPIREDOC-9400 | Fixes the issue that logos were lost when converting Docx to PDF. |
| Bug | SPIREDOC-9627 | Fixes the issue that loading RTF documents threw a System.NullReferenceException exception. |
| Bug | SPIREDOC-9640 | Fixes the issue that the symbol "~" in LaTeX formulas was parsed incorrectly. |
| Bug | SPIREDOC-9641 | Fixes the issue that TOC was split across multiple pages when converting Word to PDF. |
| Bug | SPIREDOC-9684 | Fixes the issue that images were blurry when converting Docx to HTML. |
| Bug | SPIREDOC-9712 | Fixes the issue that extra text appeared when converting Word to PDF. |
| Bug | SPIREDOC-9755 | Fixes the issue that content was inconsistent after loading and saving a document. |
| Bug | SPIREDOC-9761 | Fixes the issue that the program hung when inserting HTML strings. |
| Spire.PDF | ||
| Category | ID | Description |
| New feature | SPIREPDF-6199 | Add a new method to determine if a document is encrypted without loading the document. |
| bool value = PdfDocument.IsPasswordProtected("1.pdf"); | ||
| New feature | SPIREPDF-6223 | Supports setting margins when printing. |
| pdf.PrintSettings.SelectMultiPageLayout(2,2,false,Spire.Pdf.Print.PdfMultiPageOrder.Horizontal, marginValue) | ||
| Bug | SPIREPDF-4391 | Fixed the issue that some cells were split into two columns when converting PDF to Excel. |
| Bug | SPIREPDF-6023 | Fix the issue that setting the WholeWord property when searching for text caused the failure of highlighting text. |
| Bug | SPIREPDF-6138 | Fix the issue that text was lost when converting PDF to Word. |
| Bug | SPIREPDF-6194 | Fix the issue that the XML file failed to open in the result file after adding XML attachments to PDF files. |
| Bug | SPIREPDF-6198 | Fix the issue that the program threw an exception "System.ArgumentOutOfRangeException" when loading a compressed document. |
| Bug | SPIREPDF-6201 | Fix the issue that it failed to open the compressed document with PDF reader. |
| Bug | SPIREPDF-6203 | Fixed the issue that PDF converted to Word with permission password set (content copy and page extraction not allowed) did not request permission password. |
| Bug | SPIREPDF-6204 | Fixed the issue that characters were displayed incorrectly after converting PDF to POSTSCRIPT. |
| Bug | SPIREPDF-6205 | Fixed the issue that stamps were lost after converting OFD to PDF and images. |
| Bug | SPIREPDF-6213 | Fix the issue that the content was garbled after converting PDF to PDFA. |
| Bug | SPIREPDF-6227 | Fix the issue that the program threw an exception "System.IndexOutOfRangeException" when drawing a table. |
| Bug | SPIREPDF-1752 | Fixed the issue that opening the result file in Adobe failed after creating an overlay. |
| Bug | SPIREPDF-5146 | Fixed the issue that the watermark was changed after decrypting a PDF file. |
| Bug | SPIREPDF-5865 | Fixed the issue that finding cross-line text in a PDF file failed. |
| SPIREPDF-6114 | ||
| Bug | SPIREPDF-6024 | Fixed the issue that setting FitToPage and FitToHTML properties under PdfHtmlLayoutFormat didn't take effect. |
| Bug | SPIREPDF-6140 | Fixed the issue that printing the same PDF file multiple times resulted in increased file size and printing time. |
| Bug | SPIREPDF-6150 | Fixed the issue that the content orientation was incorrect when printing double-sided. |
| Bug | SPIREPDF-6193 | Fixed the issue that the application threw a "System.NullReferenceException" exception when adding attachments to a PDF file. |
| Spire.XLS | ||
| Category | ID | Description |
| New feature | SPIREXLS-2146 | Supports customizing the paper size without scaling the content during printing. |
| sheet.PageSetup.SetCustomPaperSize(224, (float)25.4); | ||
| sheet.PageSetup.Orientation = PageOrientationType.Portrait; | ||
| New feature | SPIREXLS-4640 | Supports adding Signature Line. |
| sheet.Range["A1"].AddSignatureLine("e-iceblue","E-iceblue","123@123.com", "description" ,false, true); | ||
| New feature | SPIREXLS-4740 | Supports getting shapes in sheets. |
| Spire.Xls.Core.IShapes shapes = sheet.Shapes; | ||
| Bug | SPIREXLS-1782 | Fixes the issue that the program threw an exception when creating HIPERVINCULO formulas in a Spanish environment. |
| Bug | SPIREXLS-4824 | Fixes the issue that the program threw a "NullReferenceException" when loading an Excel document created by the new version of WPS. |
| SPIREXLS-4830 | ||
| Bug | SPIREXLS-4842 | Fixes the issue that the slicer was lost after saving Excel. |
| Bug | SPIREXLS-4850 | Fixes the issue that after splitting Excel documents, the generated file prompted the message that the content has error when opening in Microsoft Excel. |
| Bug | SPIREXLS-4851 | Fixes the issue that the program threw "NullReferenceException" when merging multiple Excel documents. |
| Bug | SPIREXLS-4853 | Fixes the issue that the program threw "NullReferenceException" when loading Excel documents. |
| Spire.Presentation | ||
| Category | ID | Description |
| New feature | SPIREPPT-2311 | Supports highlighting replaced text. |
| Presentation ppt = new Presentation(); | ||
| ppt.LoadFromFile("input.pptx"); | ||
| DefaultTextRangeProperties format = new DefaultTextRangeProperties(); | ||
| format.IsBold = TriState.True; | ||
| format.Fill.FillType = Spire.Presentation.Drawing.FillFormatType.Solid; | ||
| format.Fill.SolidColor.Color = Color.Red; | ||
| format.FontHeight = 25; | ||
| ppt.ReplaceAndFormatText("Yuma", "AAAA", format); | ||
| ppt.SaveToFile("output.pptx",FileFormat.Pptx2016); | ||
| Bug | SPIREPPT-2286 | Fixes the issue that the think-cell objects were lost when splitting a PowerPoint document containing think-cell objects. |
| Bug | SPIREPPT-2292 | Fixes the issue that copying a PowerPoint slide containing modern annotation content failed. |
| Bug | SPIREPPT-2315 | Fixes the issue that the program threw System.IndexOutOfRangeException when getting points in the teardrop shape. |
| Bug | SPIREPPT-2317 | Fixes the issue that the color did not take effect when converting to PDF after changing the hyperlink color. |
| Spire.DocViewer | ||
| Category | ID | Description |
| Bug | SPIREDOCVIEWER-107 | Fixed the issue that the image location was incorrect when viewing a Word document. |
| Spire.PDFViewer | ||
| Category | ID | Description |
| Bug | SPIREPDFVIEWER-575 | Fixed the issue that the application threw a "System.ArgumentNullException" exception when loading a PDF file. |
| Bug | SPIREPDFVIEWER -576 | Fixed the issue that the application threw a "System.OutOfMemoryException" exception when loading a PDF file. |
