Spire.XLS 14.10.2 现已发布。该版本支持 ARRAYTOTEXT、ARABIC、BASE、COMBINA 和 XOR 公式，还支持嵌入图片到单元格以及获取单元格的 NamedRange。此外，一些在转换 Excel 到 PDF、获取页数和导出数据时出现的问题也已成功解决。新功能及问题修复详情如下。

新功能:

• MarkerDesigner 支持应用过滤值参数。
• 支持 ARRAYTOTEXT 公式。

Workbook workbook = new Workbook();
workbook.Worksheets[0].Range["A1"].Text = "True";
workbook.Worksheets[0].Range["A2"].Text = "1234.01234";
workbook.Worksheets[0].Range["A3"].Text = "你好";
workbook.Worksheets[0].Range["B1"].Text = "#VALUE!";
workbook.Worksheets[0].Range["B2"].Text = "Seattle";
workbook.Worksheets[0].Range["B3"].Text = "$1，123.00";          
workbook.Worksheets[0].Range["D1"].FormulaArray = "=ARRAYTOTEXT(A1：B4，0)"; 
workbook.Worksheets[0].Range["D3"].FormulaArray = "=ARRAYTOTEXT(A1：B4，1)";    
workbook.SaveToFile(outputFile, ExcelVersion.Version2013);

• 支持 ARABIC 公式。

Workbook workbook = new Workbook();
workbook.Worksheets[0].Range["A1"].Value2 = "mcmxii";             
workbook.Worksheets[0].Range["C1"].Formula = "=ARABIC(A1)";
workbook.Worksheets[0].Range["C2"].Formula = "=ARABIC(\"LVII\")"; 
workbook.Worksheets[0].Range["C3"].Formula = "=ARABIC(\"mcmxii\")"; 
workbook.Worksheets[0].Range["C4"].Formula = "=ARABIC(\"\")"; 
workbook.Worksheets[0].Range["C5"].Formula = "=ARABIC(\"-LVII\")";
workbook.Worksheets[0].Range["C6"].Formula = "=ARABIC(\"57\")"; 
workbook.Worksheets[0].Range["C7"].Formula = "=ARABIC(\"2024/10/15\")"; 
workbook.Worksheets[0].Range["C8"].Formula = "=ARABIC(\"文本\")"; 

• 支持 BASE 公式。

Workbook workbook = new Workbook();
workbook.Worksheets[0].Range["A1"].Value2 = 7;           
workbook.Worksheets[0].Range["C1"].Formula = "=BASE(A1,2)";
workbook.Worksheets[0].Range["C2"].Formula = "=BASE(7,2)"; 
workbook.Worksheets[0].Range["C3"].Formula = "=BASE(100,16))";
workbook.Worksheets[0].Range["C4"].Formula = "=BASE(15,2,10)"; 
workbook.Worksheets[0].Range["C5"].Formula = "=BASE(文本,16))"; 
workbook.Worksheets[0].Range["C6"].Formula = "=BASE(-7,2)"; 

• 支持 COMBINA 公式。

Workbook workbook = new Workbook();
workbook.Worksheets[0].Range["A1"].Value2 = 4;             
workbook.Worksheets[0].Range["C1"].Formula = "=COMBINA(A1,3)";
workbook.Worksheets[0].Range["C2"].Formula = "=COMBINA(4,3)"; 
workbook.Worksheets[0].Range["C3"].Formula = "=COMBINA(10,3)"; 
workbook.Worksheets[0].Range["C4"].Formula = "=COMBINA(3,10)";
workbook.Worksheets[0].Range["C5"].Formula = "=COMBINA(文本,16))"; 

• 支持 XOR 公式。

Workbook workbook = new Workbook();
workbook.Worksheets[0].Range["A1"].Value2 = 3;
workbook.Worksheets[0].Range["A2"].Value2 = 0;
workbook.Worksheets[0].Range["C1"].Formula = "=XOR(A1>A2)";
workbook.Worksheets[0].Range["C2"].Formula = "=XOR(2>9)"; 
workbook.Worksheets[0].Range["C3"].Formula = "=XOR(3>0,2<9)"; 
workbook.Worksheets[0].Range["C4"].Formula = "=XOR(3>12,2<9)"; 
workbook.Worksheets[0].Range["C5"].Formula = "=XOR(3>12,2<9,4>6)"; 
workbook.Worksheets[0].Range["A6"].Value2 = 3>0;
workbook.Worksheets[0].Range["C6"].Formula = "=XOR(A6)"; 

• 支持嵌入图片到单元格。

worksheet.Range["B1"].InsertOrUpdateCellImage("D:\\vs1.png",true); 

• 支持判断单元格是否存在 NamedRange 以及支持获取单元格的 NamedRange。

Workbook workbook = new Workbook();
workbook.LoadFromFile(inputFile);
var result = workbook.Worksheets[0].Range["A1"].GetNamedRange();
System.Console.WriteLine(result);
var result1 = workbook.Worksheets[0].Range["A2"].GetNamedRange();
System.Console.WriteLine(result1);
File.WriteAllText(outputFile_T, result.ToString()+ "\r\n");
File.AppendAllText(outputFile_T, result1.ToString()+ "\r\n");
var result2 = workbook.Worksheets[0].Range["A3"].GetNamedRange();
if (result2 == null)
{
   System.Console.WriteLine("null");
   File.AppendAllText(outputFile_T, "null");
}

问题修复:

• 修复了获取页面数量不正确的问题。
• 修复了在 NET6 框架导出数据的小数点不正确的问题。
• 修复了转换 Excel 到 PDF 后，嵌入到单元格的图片丢失的问题。
• 修复了转换 Excel 到 PDF，程序抛 "Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index')" 异常的问题。
• 修复了获取公式的计算结果不正确的问题。
• 修复了转换 Excel 到 PDF 程序抛异常的问题。
• 修复了插入公式到单元格多出 "@" 字符以及公式值不正确的问题。
• 修复删除迷你图失败的问题。
• 修复了给透视表添加过滤器失败的问题。

https://www.e-iceblue.cn/Downloads/Spire-XLS-NET.html