NPOI.Extension icon indicating copy to clipboard operation
NPOI.Extension copied to clipboard

无法获取公式计算后的值

Open y976362357 opened this issue 4 years ago • 2 comments

背景

在导入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)

y976362357 avatar Aug 03 '20 01:08 y976362357

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.

issue-label-bot[bot] avatar Aug 03 '20 01:08 issue-label-bot[bot]