Spire.Office 9.9.0 for .NET FIX

于 2024-09-30 21:02:34 发布
阅读量828 收藏 17
点赞数 27
分类专栏： Spire.Office for NET 文章标签： .net Spire.Office
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/john_dwh/article/details/142663802
版权

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.XLS

CategoryIDDescription
New featureSPIREXLS-5307Adds the 'OleObjectType.Msg' type to identify OLE objects in Msg format. 
Workbook wb = new Workbook();
wb.LoadFromFile(inputFile);
Worksheet sheet =wb.Worksheets[0];
OleObjectType type;
if (sheet.HasOleObjects)
{
   for (int i = 0; i < sheet.OleObjects.Count; i++)
   {
      var Object = sheet.OleObjects[i];
      type = sheet.OleObjects[i].ObjectType;
      switch (type)
      {
         case OleObjectType.Msg:
            File.WriteAllBytes(outputFile_1, Object.OleData);
            break;     
         ......                   
      }
    }
}
New featureSPIREXLS-5359Adds the 'workbook.ProhibitDtd = true' property to disable DTD processing. 
Workbook workbook = new Workbook();
workbook.ProhibitDtd = true; 
workbook.LoadFromFile(inputFile);
workbook.SaveToFile(outputFile, ExcelVersion.Version2013);
workbook.Dispose();
New featureSPIREXLS-5395Implements the support for the BAHTTEXT formula. 
Workbook workbook = new Workbook();
workbook.Worksheets[0].Range["A3"].Value2 = 1234;
workbook.Worksheets[0].Range["C3"].Formula = "=BAHTTEXT(A3)";
workbook.Worksheets[0].Range["A9"].Value = "1234";
workbook.Worksheets[0].Range["C9"].Formula = "=BAHTTEXT(A9)";            
workbook.SaveToFile(outputFile, ExcelVersion.Version2013);
workbook.Dispose();
New featureSPIREXLS-5255Supports adding filters to row fields/column fields of pivot tables. 
XlsPivotTable pt1 = workbook.Worksheets["PivotTable_1"].PivotTables[0] as XlsPivotTable;
pt1.RowFields[0].AddValueFilter(PivotValueFilterType.Between, pt1.DataFields[0], 100000, 1000000);
pt1.ColumnFields[0].AddValueFilter(PivotValueFilterType.Between, pt1.DataFields[0], 100000, 1000000);
pt1.CalculateData();
New featureSPIREXLS-5393Supports the issue that the TEXTBEFORE formula is now available. 
workbook.Worksheets[0].Range["A1"].Formula = "=TEXTBEFORE(\"Red riding hood's, red hood\", \"hood\")";
New featureSPIREXLS-5394Supports the issue that the TEXTSPLIT formula is now available. 
Supports the issue that the TEXTSPLIT formula is now available. 
workbook.Worksheets[0].Range["B2:D2"].FormulaArray = "=TEXTSPLIT(A2, \" \")";
New featureSPIREXLS-5397Supports the issue that the TEXTAFTER formula is now available. 
workbook.Worksheets[0].Range["A3"].Formula = "=TEXTAFTER(\"Red riding hood’s, red hood\", \"\")";
BugSPIREXLS-5108Fixed the issue that the table borders were inconsistent in color after converting an Excel document to a picture.
BugSPIREXLS-5280Fix the issue that the content was incorrect after converting an Excel document to a CSV document.
BugSPIREXLS-5315Fix the issue that the order of setting different font styles for the contents of a cell affected the inconsistency of the results.
BugSPIREXLS-5321Fix the issue that icons were lost after converting an Excel document to an HTML document.
BugSPIREXLS-5332Fix the issue that the data in the pivot table was lost when converting an Excel document to a picture.
BugSPIREXLS-5346Fix the issue that the result of data summing using MarkerDesigner function was incorrect.
BugSPIREXLS-5360Fixed the issue that the program threw System.OutOfMemoryException when converting charts to pictures.
BugSPIREXLS-5361Fixed the issue that the formatting was changed after saving as an XLSX document.
BugSPIREXLS-5363Fixed the issue that the spacing between words became larger after converting an Excel document to a PDF document.
BugSPIREXLS-5400Fix the issue that the text line breaks were incorrect after converting an Excel document to a PDF document.
BugSPIREXLS-5355Fixes the issue that the content is incorrect when converting Excel documents to images.
BugSPIREXLS-5467Fixes the issue that an exception "System.InvalidCastException" is thrown when copying worksheets containing charts.
BugSPIREXLS-5468Fixes the issue that there is a discrepancy in data after the decimal point when converting Excel documents to PDF.

Spire.PDF

CategoryIDDescription
BugSPIREPDF-4562
SPIREPDF-5019		Improves the speed of printing PDF documents.
BugSPIREPDF-4445Fixes the issue that content is blank when converting PDF documents to images.
BugSPIREPDF-6938Fixes the issue that the program throws a System.FormatException: "Header checksum illegal" when compressing PDF documents.
BugSPIREPDF-6969Fixes the issue that the program throws a System.NullReferenceException: "Object reference not set to an instance of an object." when converting PDF documents to OFD documents.
BugSPIREPDF-6970Fixes the issue that the program throws a System.Exception: "Header of the stream cannot be read." when extracting images.
BugSPIREPDF-6971Fixes the issue that the content is incorrect when converting SVG files to PDF documents.
BugSPIREPDF-6974Fixes the issue with font errors when converting SVG files to PDF documents.
BugSPIREPDF-6979Fixes the issue that the program throws a System.IndexOutOfRangeException: "Index is outside the bounds of the array." when converting PDF documents to images.
BugSPIREPDF-6981Fixes the issue that the program throws a System.NullReferenceException: "Object reference not set to an instance of an object." when retrieving fonts.
BugSPIREPDF-6995Fixes the issue that results are incorrect when extracting text multiple times.
BugSPIREPDF-6997Fixes the issue that the program throws a System.NullReferenceException: "Object reference not set to an instance of an object." when converting PDF documents to PDFA1B documents.

Spire.Presentation

CategoryIDDescription
New featureSPIREPPT-2567Supports setting the global font directory when execute the conversion function. 
Presentation.SetCustomFontsDirctory("myfonts");
New featureSPIREPPT-2594Adds the "IChart.ChartData.LastRowIndex" and "IChart.ChartData.LastColIndex" properties to obtain the last row and last column of the chart's data source. 
Presentation ppt = new Presentation();
ppt.LoadFromFile(inputFile);
StringBuilder stringBuilder= new StringBuilder();
IChart chart = ppt.Slides[0].Shapes[0] as IChart;
if (chart != null)
{
	int lastRow = chart.ChartData.LastRowIndex;
	int lastCol = chart.ChartData.LastColIndex;
	sb.AppendLine("lastRow" + lastRow + "\r\n" + "lastColumn" + lastCol);
	int dataRow = chart.Series[2].Values[chart.Series[2].Values.Count - 1].Row; 
	int dataColumn = chart.Series[2].Values[chart.Series[2].Values.Count - 1].Column; 
	sb.AppendLine("dataRow" + datarow + "\r\n" + "dataColumn" + dataColumn);
	chart.ChartData.Clear(dataRow + 1, 0, lastRow + 1, lastCol + 1);  
	chart.ChartData.Clear(0, dataColumn + 1, lastRow + 1, lastCol + 1); 
}
File.WriteAllText(outputFile_T,stringBuilder.ToString());
ppt.SaveToFile(outputFile, FileFormat.Pptx2013);
ppt.Dispose();
BugSPIREPPT-2582Fixes the issue that the type changed from "graphic" to "image" when copying shapes.
BugSPIREPPT-2590Fixes the issue that the content was incorrect when converting PPTX documents to SVG documents.
sdk大全
关注
专栏目录
.NET 免费Office类库-Free Spire.Office for .NET_4.3.zip
03-26
Free Spire.Office for .NET 涵盖Spire系列所有 .NET Office 免费组件的集合，包括Free Spire.Doc for .NET，Free Spire.DocViewer for .NET，Free Spire XLS for .NET，Free Spire.Presentation for .NET，Free Spire.PDF for .NET，Free Spire.PDFViewer for .NET，Free Spire.DataExport for .NET和 Free Spire.Barcode for .NET。 使用 Free Spire.Office for .NET，开发人员可以创建大量的用于处理办公文档的应用程序。对文档的操作包括打开，创建，修改，转换，打印，浏览 Word、Excel、PowerPoint® 和 PDF 文档，以及将数据从数据源导出为常用的文档格式，例如：Word，Excel，RTF，Access，PowerPoint，PDF，XPS，HTML，XML，Text，CSV，DBF 和剪贴版等格式。 作为一个独立的 Office 组件，Free Spire.Office 的运行环境无需安装 Microsoft Office 及其他第三方软件。具有安全性、稳定性、可扩展性、高效率等优点。
Spire.Office
12-07
仅包含适用.NET4.0的DLL文件，如果需要用于WPF,Silverlight和帮助文档，请到官网下载完整包。
推荐一套.NET文档处理组件Spire.Office
05-25 204
以前的项目中用到一点Word简单处理的功能（文字替换和转PDF格式），当时使用的是一套COM组件，必须在服务器上安装office环境。最近考虑系统升级，希望能找个.NET组件，省去COM组件的注册和环境依赖。朋友推荐了Spire.Office组件，测试了一下，感觉挺不错。特此记录和介绍一下，大家以后也多一个选择。 经过简单的代码测试和查阅资料，个人总体评价如下： 优点与特色： ...
7.5.4:Spire Office for .NET New Version
控件与插件之大全
06-12 491
Spire.Office for .NET是 E-iceblue 提供的企业级 Office .NET API 的组合。它包括Spire.Doc、Spire.XLS、Spire.Spreadsheet、Spire.Presentation、Spire.PDF、Spire.DataExport、Spire.OfficeViewer、Spire.PDFViewer、Spire.DocViewer、Spire.Barcode和Spire.Email。Spire.Office 包含上述 .NET API 的最新版本
Spire.Office.2.13.4
10-31
[DLL]包括： Spire.Doc XML PDF XLS Spire.DocViewer.Forms Spire.DataExport Spire.PdfViewer.Forms
Spire.Office for Java 7.5.4
控件与插件之大全
06-10 847
Spire.Office for Java 是 E-iceblue 提供的企业级 Office Java API 的组合。它包括Java 的Spire.Doc、Java的Spire.XLS、Java的Spire.Presentation、Java的Spire.PDF 和 Java的Spire.Barcode。开发人员可以使用 Spire.Office for Java 在 Java 应用程序中执行各种办公文档操作，例如打开、创建、修改、转换和打印 Word、Excel、PowerPoint 和 PDF 文档
Spire.Office for .NET 4.3 无水印
12-28
Spire.Office for .NET 4.3 是一个强大的.NET开发工具包，专为开发者设计，用于处理Microsoft Office格式的文档，如Word（Doc）、PowerPoint（Presentation）、Excel（XLS）以及PDF文件。这个无水印版本意味着在生成...
Spire.DataExport for .NET试用版:一款可以导出数据为多种文件格式的控件
07-17
Spire.DataExport for .NET 试用版 试用版 开发语言： .NET 可用平台： Visual Studio 2005-2013 当前版本： v3.5 Spire.DataExport for .NET是一个纯数据.NET组件套包，用于将数据导出到MS Word、Excel、RTF、...
Spire.PDFViewer for .NET试用版:一款强大的PDF文件浏览控件
07-16
Spire.PDFViewer for .NET 试用版 试用版 开发语言： .NET 可用平台： Visual Studio 2005-2013 当前版本： v4.1 Viewer for .NET是一个用于.NET的强大PDF阅读器组件，允许开发人员从流、文件和字节数组加载PDF文档...
免费版.NET 组件_Free Spire.Pdfviewer for .NET 3.4
07-13
Free Spire.PDFViewer for .NET 是 Spire.PDFViewer for .NET 的免费版本，使用 Free Spire.PDFViewer，程序员可以在 WinForm 程序中加载并查看 PDF 文档。浏览 PDF 时，用户可以自由设置浏览选项，比如：自动适应...
免费Spire.Office全套组件
08-14
Free Spire.Office for .NET 涵盖 E-iceblue 所有 .NET Office 免费组件的集合，它包括的免费产品有：Free Spire.Doc，Free Spire.DocViewer，Free Spire XLS，Free Spire.Presentation，Free Spire.PDF，Free Spire.PDFViewer，Free Spire.DataExport 和 Free Spire.Barcode。 使用 Free Spire.Office for .NET，开发人员可以创建大量的用于处理办公文档的应用程序。对文档的操作包括打开，创建，修改，转换，打印，浏览 Word、Excel、PowerPoint® 和 PDF 文档，以及将数据从数据源导出为常用的文档格式，例如：Word，Excel，RTF，Access，PowerPoint，PDF，XPS，HTML，XML，Text，CSV，DBF 和剪贴版等格式。 作为一个独立的 Office 组件，Free Spire.Office 的运行环境无需安装 Microsoft Office 及其他第三方软件。基于安全性、稳定性、可扩展性、效率及价格方面的考
spire.office,Spire.Office 5.3.7组件的最新版本
q2315702359的博客
12-18 592
　　spire.office,Spire.Office 5.3.7组件的最新版本 　　Spire.Office是面向.NET程序员的有用Office组件的集合。该集合包含.NET，wpf和Silverlight的各种Office组件的最新版本。因此，它们可用于C#和Visual Basic的桌面和Web应用程序中。这些组件在企业和高级级别提供，包括诸如Spire.Doc，Spire XLS，Spire.Spreadsheet，Spire.Presentation，Spire.PDF，Spire.DataE
Spire.Office for NET 全家桶最新版7.7.6
控件与插件之大全
08-07 1352
.NET Libraries for Processing MS Office Documents and PDF 注：没破解版Spire.Office for .NET is a combination of Enterprise-Level Office .NET API offered by E-iceblue. It includes the most recent versions of Spire.Doc, Spire.XLS, Spire.Spreadsheet...
Spire.Office for Java 8.10.2 同步更新Crk
最新发布
控件与插件之大全
11-07 364
Spire.Office for Java 是 E-iceblue 提供的企业级 Office Java API 的组合。它包括Spire.Doc for Java、Spire.XLS for Java、Spire.Presentation for Java、Spire.PDF for Java和Spire.Barcode for Java。
【更新】专业office工具套包 Spire.Office 补丁 v4.4.0发布 | 附下载
Aote222的博客
04-09 546
Spire.Office 4.4.0已经正式发布了。该版本添加了许多新功能，例如，Spire.PDF支持查找和高亮跨行的文本，Spire.Presnetation支持对文本添加动画，Spire.XLS支持设置文本框的内边距，Spire.Spreadsheet支持自定义语言配置文件的路径。此外，本次更新还修复了大量漏洞。 该版本涵盖了最新版的Spire.Doc、Spire.PDF、Spire.XL...
Spire.Office 8.7.0 for .NET Spire.Office 特殊版
控件与插件之大全
07-12 1082
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,
无需安装Microsoft Office和Adobe实现办公文档操作，Spire.Office免费资源清单一览
daneas的专栏
09-22 1648
作为一个独立的 Office 组件，Free Spire.Office 的运行环境无需安装 Microsoft Office 及其他第三方软件。基于安全性、稳定性、可扩展性、效率及价格方面的考虑，Spire.Office 已经成为微软办公套件有力的替代品。友情提示: 免费版有篇幅限制。除了文档篇幅限制外，Free Spire.Office 没有任何警告信息，但我们仅对免费版进行不定期维护。 在加载或操作 Word 文档时，要求 Word 文档不超过 500 个段落，25 个表格。同时将 Word 文档转换
spire.office的使用
qq_39472036的博客
09-23 1180
参考：https://www.e-iceblue.cn/ 1.maven导入 <dependency> <groupId> e-iceblue </groupId> <artifactId>spire.office</artifactId> <version>4.8.0</version> </dependency> 2.参考案例
free spire.pdf for .net。
10-07
Free Spire.PDF for .NET 是一个用于 .NET 平台的免费 PDF 处理库。它提供了丰富的功能，可以用于创建、编辑、处理和转换 PDF 文档。 首先，Free Spire.PDF for .NET 可以用于创建全新的 PDF 文档。用户可以使用库...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值