kev-ops

I am reading the content of excel file(.XLSX), I am having issue in reading cell with a value "4.9" (please refer to the screenshot below, highlighted in yellow)  In...

Yes, the number in my case "4.9" which is a general number resulted to [accurately represent numbers](https://stackoverflow.com/questions/21895756/why-are-floating-point-numbers-inaccurate). which is unwanted. _**Could the s="2" value be the significant digits?**_ Answer: I...

I also have relevant concern in date formatting **Observed behavior** Custom Date format and other date format returns inconsistent NumberFormatId Please refer to the attached file **1.xlsx**  I have...

In addition, Is it possible to convert a date in c# using these formatCodes? We are struggling converting the date values retrieved from excel in c# using the format codes...