Aspose公司对旗下产品
Aspose.Cells For .NET发布了新的8.6.1版本,这篇文章主要介绍
Aspose.Cells 8.6.1和8.6.0在控件提供的API上有什么新的变化,在新的8.6.1版本中不仅包含了新的方法和添加类,还描述了很多功能上的增强,具体可以参考下面的介绍:
- HtmlLinkTargetType.Blank: 在新的窗口或者标签里打开新的文档
- HtmlLinkTargetType.Parent: 在父窗口中打开新的文档
- HtmlLinkTargetType.Self: 在自身窗口打开新的页或文档.
- HtmlLinkTargetType.Top:全屏打开链接的文档或页
具体用法:
Workbook workbook = new Workbook(inputFilePath);
//Create an instance of HtmlSaveOptions
HtmlSaveOptions options = new HtmlSaveOptions();
//Set the LinkTargetType property to appropriate value
options.LinkTargetType = HtmlLinkTargetType.Blank;
//Convert the
Spreadsheet to HTML with preset HtmlSaveOptions
workbook.Save(outputFilePath, options);
新增VbaModuleCollection.Remove方法,该方法用于删除指定工作表的宏模块,具体用法如下:
Workbook workbook = new Workbook(inputFilePath);
//Retrieve the VBA modules from the Workbook
VbaModuleCollection modules = workbook.VbaProject.Modules;
//Remove the VBA modules from specific Worksheet
modules.Remove(workbook.Worksheets[0]);
Aspose.Cells 8.6.1版本新增了RangeCollection.Add方法,该方法用于添加新的Range到Range集合,具体用法如下:
Workbook workbook = new Workbook(inputFilePath);
//Retrieve the Cells of the first worksheet in the workbook
Cells cells = workbook.Worksheets[0].Cells;
//Retrieve the range collection from first worksheet of the Workbook
RangeCollection ranges = cells.Ranges;
//Add another range to the collection
ranges.Add(cells.CreateRange("A1:B4"));
新增了Cell.SetCharacters方法,该方法用于设置Excel单元格内部分文本或者全部文本的字体、样式、颜色等,具体用法如下:
Workbook workbook = new Workbook(inputFilePath);
//Access first worksheet of the workbook
Worksheet worksheet = workbook.Worksheets[0];
//Access the cells containing the Rich Text
Cell cell = worksheet.Cells["A1"];
//Retrieve the array of FontSetting from the cell
FontSetting[] settings = cell.GetCharacters();
//Modify the Font Name for the first FontSetting
settings[0].Font.Name = "Arial";
//Set the updated FontSetting
cell.SetCharacters(settings);
新增了VbaProject.IsSigned方法,Aspose.Cells提供的该方法用于检测Excel文件里嵌入的VBA项目是否签名,具体用法如下:
Workbook workbook = new Workbook(inputFilePath);
//Retrieve the VbaProject from the Workbook
VbaProject project = workbook.VbaProject;
//Test if VbaProject is signed
if (project.IsSigned)
{
Console.WriteLine("VBA Project is Signed");
}
else
{
Console.WriteLine("VBA Project is not Signed");
}
- 修改了Cell.GetFormatConditions方法的返回值类型,在8.6.1版本后该方法返回一个FormatConditionCollection数组类型
- Workbook.CheckWriteProtectedPassword方法在8.6.1种标记为即将作废,建议使用新的WorkbookSettings.WriteProtection.ValidatePassword方法