NPOI.Extension
NPOI.Extension copied to clipboard
无法获取公式计算后的值
背景
在导入Excel时 excel文件如下: 单元格A2:A2 单元格B2:=CONCATENATE("test", A2)
实体类 public ExcelData{ [Column(Index = 0)] public string A{get;set;} [Column(Index = 1)] public string B{get;set;} }
var data = Excel.Load<ExcelData>(file, sheetIndex: 1);
期望结果及实际结果
期望data 的B属性为:testA2 实际结果为:CONCATENATE("test", A2)
Issue-Label Bot is automatically applying the label bug
to this issue, with a confidence of 0.90. Please mark this comment with :thumbsup: or :thumbsdown: to give our bot feedback!
Links: app homepage, dashboard and code for this bot.