Spire.Office 6.2.1已发布。本次更新带了一些新的功能,譬如:Spire.PDF 支持检测 PDF 是否是加密文档,支持转换PDF为灰度文档,以及新增了替换文本方法;Spire.Presentation支持了替换视频文件的功能。此外,该版本还修复了大量的问题。详情请阅读以下内容。
该版本涵盖了最新版的Spire.Doc, Spire.PDF, Spire.XLS, Spire.Presentation, Spire.Email, Spire.DocViewer, Spire.PDFViewer, Spire.Spreadsheet, Spire.OfficeViewer, Spire.DataExport, Spire.Barcode。
版本信息如下:
https://www.e-iceblue.cn/Downloads/Spire-Office-NET.html
新功能:
PdfGrayConverter convert = new PdfGrayConverter(inputFile);
convert.ToGrayPdf(outputFile);
PdfDocument.IsPasswordProtected(inputFile);
public CustomPKCS7SignatureFormatter(X509Certificate2 certificate)
{
if (null == certificate)
{ throw new ArgumentNullException("certificate"); }
m_certificate = certificate;
Parameters.Add("Filter", "Adobe.PPKMS");
Parameters.Add("SubFilter", "adbe.pkcs7.detached");
Parameters.Add("SignatureLength", 975);
Parameters.Add("SoftwareModuleName", "Create by Spire.Pdf");
}
PdfTextReplacer ptr = new PdfTextReplacer(page);
ptr.ReplaceAllText("LONDON MIDLAND", "West Midlands Railway");//全部替换
ptr.ReplaceText("LONDON MIDLAND", "West Midlands Railway");//仅替换一个
问题修复:
新功能:
Presentation ppt= new Presentation();
ppt.LoadFromFile(inputFile);
VideoCollection videos = ppt.Videos;
foreach (ISlide sld in ppt.Slides)
{
foreach (Spire.Presentation.Shape sp in sld.Shapes)
{
if (sp is IVideo)
{
IVideo video = sp as IVideo;
byte[] bts = File.ReadAllBytes("C:/test.mp4");
VideoData videoData = videos.Append(bts);
video.EmbeddedVideoData = videoData;
}
}
}
ppt.SaveToFile(outputFile, FileFormat.Pptx2013);
问题修复:
问题修复:
问题修复:
Spire.XLS 11.2.3已发布。该版本增强了转换XLSM/Excel到PDF的功能,并且修复了加载XLSX文档时出现的问题。详情请阅读以下内容。
问题修复:
Spire.Presentation 6.2.2已发布。该版本支持了替换视频文件的功能并且修复了加载和合并文档PPT文档时出现的问题。
新功能:
Presentation ppt= new Presentation();
ppt.LoadFromFile(inputFile);
VideoCollection videos = ppt.Videos;
foreach (ISlide sld in ppt.Slides)
{
foreach (Spire.Presentation.Shape sp in sld.Shapes)
{
if (sp is IVideo)
{
IVideo video = sp as IVideo;
byte[] bts = File.ReadAllBytes("C:/test.mp4");
VideoData videoData = videos.Append(bts);
video.EmbeddedVideoData = videoData;
}
}
}
ppt.SaveToFile(outputFile, FileFormat.Pptx2013);
问题修复:
https://www.e-iceblue.cn/Downloads/Spire-Presentation-NET.html
Spire.PDF 7.2.5已发布。该版本新增替换文本方法修复了转换PDF到图片等问题。详情请阅读以下内容。
新功能:
PdfTextReplacer ptr = new PdfTextReplacer(page);
ptr.ReplaceAllText("LONDON MIDLAND", "West Midlands Railway");//全部替换
ptr.ReplaceText("LONDON MIDLAND", "West Midlands Railway");//仅替换一个
问题修复:
该文将介绍如何使用Spire.PDF for .NET 检测PDF文档是否加密。Spire.PDF 提供方法 IsPasswordProtected(string fileName) 返回一个布尔值。如果返回值为true,则表明该文档被加密。
using Spire.Pdf;
using System;
namespace PdfDemo
{
class Program
{
static void Main(string[] args)
{
string fileName = "Sample.pdf";
bool value = PdfDocument.IsPasswordProtected(fileName);
Console.WriteLine(value);
Console.ReadKey();
}
}
}
Imports Spire.Pdf
Imports System
Namespace PdfDemo
Class Program
Private Shared Sub Main(ByVal args() As String)
Dim fileName As String = "Sample.pdf"
Dim value As Boolean = PdfDocument.IsPasswordProtected(fileName)
Console.WriteLine(value)
Console.ReadKey
End Sub
End Class
End Namespace
运行项目后,将返回结果如下:

本文介绍使用Spire.XLS for .NET来复制Excel中的指定单元格区域,包括复制单元格文本及单元格样式。复制时,可在工作簿中的同一个sheet工作表内复制,也可在不同工作簿的不同sheet工作表间复制。
在同一个sheet工作表中复制
using Spire.Xls;
namespace CopyRanges_XLS
{
class Program
{
static void Main(string[] args)
{
//加载Excel工作簿
Workbook book = new Workbook();
book.LoadFromFile("sample.xlsx", ExcelVersion.Version2013);
//获取第一个工作表
Worksheet sheet = book.Worksheets[0];
//将源数据数据复制到目标单元格区域
sheet.Copy(sheet.Range["A1:F1"], sheet.Range["A6:F6"], true);
//保存文档
book.SaveToFile("result.xlsx", ExcelVersion.Version2013);
System.Diagnostics.Process.Start("result.xlsx");
}
}
}
Imports Spire.Xls
Namespace CopyRanges_XLS
Class Program
Private Shared Sub Main(args As String())
'加载Excel工作簿
Dim book As New Workbook()
book.LoadFromFile("sample.xlsx", ExcelVersion.Version2013)
'获取第一个工作表
Dim sheet As Worksheet = book.Worksheets(0)
'将源数据数据复制到目标单元格区域
sheet.Copy(sheet.Range("A1:F1"), sheet.Range("A6:F6"), True)
'保存文档
book.SaveToFile("result.xlsx", ExcelVersion.Version2013)
System.Diagnostics.Process.Start("result.xlsx")
End Sub
End Class
End Namespace

在不同工作簿的sheet工作表间复制
using Spire.Xls;
namespace CopyRanges2
{
class Program
{
static void Main(string[] args)
{
//加载Excel工作簿1
Workbook book1 = new Workbook();
book1.LoadFromFile("sample.xlsx", ExcelVersion.Version2013);
//加载Excel工作簿2
Workbook book2 = new Workbook();
book2.LoadFromFile("test.xlsx");
//获取工作表
Worksheet sheet1 = book1.Worksheets[0];
Worksheet sheet2 = book2.Worksheets[1];
//将源数据数据复制到目标单元格区域
sheet1.Copy(sheet1.Range["A1:F1"], sheet2.Range["B4:G4"], true);
//保存工作簿2
book2.SaveToFile("result2.xlsx", ExcelVersion.Version2013);
System.Diagnostics.Process.Start("result2.xlsx");
}
}
}
Imports Spire.Xls
Namespace CopyRanges2
Class Program
Private Shared Sub Main(args As String())
'加载Excel工作簿1
Dim book1 As New Workbook()
book1.LoadFromFile("sample.xlsx", ExcelVersion.Version2013)
'加载Excel工作簿2
Dim book2 As New Workbook()
book2.LoadFromFile("test.xlsx")
'获取工作表
Dim sheet1 As Worksheet = book1.Worksheets(0)
Dim sheet2 As Worksheet = book2.Worksheets(1)
'将源数据数据复制到目标单元格区域
sheet1.Copy(sheet1.Range("A1:F1"), sheet2.Range("B4:G4"), True)
'保存工作簿2
book2.SaveToFile("result2.xlsx", ExcelVersion.Version2013)
System.Diagnostics.Process.Start("result2.xlsx")
End Sub
End Class
End Namespace

Spire.Office for Java 4.2.0 已发布。本次更新带来了一些新功能,例如:Spire.Doc for Java 新增了锁住内容控件的功能;Spire.XLS for Java 支持数字签名和透视表分组和取消分组的功能。此外,该版本还修复了大量问题。详情请阅读以下内容。
获取Spire.Office for Java 4.2.0,请点击:https://www.e-iceblue.cn/Downloads/Spire-Office-JAVA.html
问题修复:
问题修复:
新功能:
sd.getSDTProperties().setLockSettings(LockSettingsType.SDT_Locked);
sd.getSDTProperties().setLockSettings(LockSettingsType.SDT_Content_Locked);
问题修复:
问题修复:
新功能:
GetCertAndPrivateKeyFromPFX certAndPrivateKeyFromPFX=new GetCertAndPrivateKeyFromPFX();
HashMap<X509Certificate,PrivateKey> hashMap=certAndPrivateKeyFromPFX.getCertAndPrivateKeyFromPFX(inputFile_pfx);
IDigitalSignatures dsc = workbook.addDigitalSignature(hashMap.keySet().iterator().next(), hashMap.get(hashMap.keySet().iterator().next()), "e-iceblue", calendar.getTime());
workbook.isDigitallySigned();
workbook.removeAllDigitalSignatures();
//Group
Workbook wb = new Workbook();
wb.loadFromFile(inputFile);
Worksheet sheet = wb.getWorksheets().get("Sheet1");
XlsPivotTable pt = (XlsPivotTable)sheet.getPivotTables().get(0);
PivotField r1 = (PivotField)pt.getPivotFields().get("Count");
pt.setManualGroupField(r1,7,15, EnumSet.of(PivotGroupByType.RangeOfValues),5);
wb.saveToFile(outputFile, ExcelVersion.Version2013);
wb.dispose();
//Ungroup
Workbook wb = new Workbook();
wb.loadFromFile(inputFile);
Worksheet sheet = wb.getWorksheets().get("Sheet1");
XlsPivotTable pt = (XlsPivotTable)sheet.getPivotTables().get(0);
PivotField r1 = (PivotField)pt.getPivotFields().get("Count");
pt.setUngroup(r1);
wb.saveToFile(outputFile, ExcelVersion.Version2013);
wb.dispose();
问题修复:
Spire.XLS for Java 4.2.0已发布。该版本支持数字签名,增加透视表分组和取消分组的功能。此外,该版本还增强了转换Excel到图片/PDF的功能。详情请阅读以下内容。
新功能:
GetCertAndPrivateKeyFromPFX certAndPrivateKeyFromPFX=new GetCertAndPrivateKeyFromPFX();
HashMap<X509Certificate,PrivateKey> hashMap=certAndPrivateKeyFromPFX.getCertAndPrivateKeyFromPFX(inputFile_pfx);
IDigitalSignatures dsc = workbook.addDigitalSignature(hashMap.keySet().iterator().next(), hashMap.get(hashMap.keySet().iterator().next()), "e-iceblue", calendar.getTime());
workbook.isDigitallySigned();
workbook.removeAllDigitalSignatures();
//Group
Workbook wb = new Workbook();
wb.loadFromFile(inputFile);
Worksheet sheet = wb.getWorksheets().get("Sheet1");
XlsPivotTable pt = (XlsPivotTable)sheet.getPivotTables().get(0);
PivotField r1 = (PivotField)pt.getPivotFields().get("Count");
pt.setManualGroupField(r1,7,15, EnumSet.of(PivotGroupByType.RangeOfValues),5);
wb.saveToFile(outputFile, ExcelVersion.Version2013);
wb.dispose();
//Ungroup
Workbook wb = new Workbook();
wb.loadFromFile(inputFile);
Worksheet sheet = wb.getWorksheets().get("Sheet1");
XlsPivotTable pt = (XlsPivotTable)sheet.getPivotTables().get(0);
PivotField r1 = (PivotField)pt.getPivotFields().get("Count");
pt.setUngroup(r1);
wb.saveToFile(outputFile, ExcelVersion.Version2013);
wb.dispose();
问题修复:
Spire.Doc 9.2.0已发布。该版本增强了转换Word到PDF的功能,并且修复了加载Word文档时出现的问题。详情请阅读以下内容。
问题修复:
Spire.PDF 7.2.0已发布。该版本支持检测PDF是否是加密文档,支持检测PDF是否是加密文档,增强了转换PDF 到图片/Doc/SVG的功能。此外,该版本还修复了打印PDF时出现的问题。详情请阅读以下内容。
新功能:
PdfGrayConverter convert = new PdfGrayConverter(inputFile);
convert.ToGrayPdf(outputFile);
PdfDocument.IsPasswordProtected(inputFile);
public CustomPKCS7SignatureFormatter(X509Certificate2 certificate)
{
if (null == certificate)
{ throw new ArgumentNullException("certificate"); }
m_certificate = certificate;
Parameters.Add("Filter", "Adobe.PPKMS");
Parameters.Add("SubFilter", "adbe.pkcs7.detached");
Parameters.Add("SignatureLength", 975);
Parameters.Add("SoftwareModuleName", "Create by Spire.Pdf");
}
问题修复: