Input: Cell Value=6.25%;
var Value= ws1.Cell(rowNum, collNum).Value.ToString();
Output: 0.0625 Expected Output: 6.25%
可以将文章内容翻译成中文,广告屏蔽插件可能会导致该功能失效(如失效，请关闭广告屏蔽插件后再试):
问题:
回答1:
I find the solution by using .GetFormattedString() insted of .Value
Input: Cell Value=6.25%;
var Value= ws1.Cell(rowNum, collNum).Value.ToString();
Output: 0.0625 Expected Output: 6.25%
I find the solution by using .GetFormattedString() insted of .Value
