我有一个Excel文件,该文件以编程方式使用EPPlus进行填充。
我尝试了以下方法:
// provides access to named ranges, does not appear to work with single cells
worksheet.Names["namedCell1"].Value = "abc123";
// provides access to cells by address
worksheet.Cells["namedCell1"].Value = "abc123";
以下内容确实有效-所以我知道我至少很亲密。
worksheet.Cells["A1"].Value = "abc123";
实际上,这有点误导。命名范围存储在workBOOK
级别而非workSHEET
级别中。因此,如果您执行以下操作:
[TestMethod]
public void Get_Named_Range_Test()
{
//http://stackoverflow.com/questions/30494913/is-there-a-way-to-get-named-cells-using-epplus
var existingFile = new FileInfo(@"c:\temp\NamedRange.xlsx");
using (var pck = new ExcelPackage(existingFile))
{
var wb = pck.Workbook; //Not workSHEET
var namedCell1 = wb.Names["namedCell1"];
Console.WriteLine("{{\"before\": {0}}}", namedCell1.Value);
namedCell1.Value = "abc123";
Console.WriteLine("{{\"after\": {0}}}", namedCell1.Value);
}
}
您可以在输出中获得此信息(使用其中包含虚拟数据的excel文件):
{"before": Range1 B2}
{"after": abc123}
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句