Number format is not correctly converted when using XLRange.AsTable().AsNativeDataTable()

[parag-patil]

• Bug

Version of ClosedXML
0.94.2.0

Presently, Excel's CellFormat = Number is not converting correctly using XLRange.AsTable().AsNativeDataTable().

My excel has column with the cellFormat as Number with 0 decimal places. But whenever I use above statement to read the excel into DataTable, it convert that column into Double data type and shows data with one decimal place.

What is the expected behavior or new feature?

Expected behavior is system it should read as Number with 0 decimal places.

Did this work in previous versions of our tool? Which versions?

NO

Code to reproduce problem:

var workBook = GetXLWorkbook(_postedData.File);
            var workSheet = workBook.Worksheets.FirstOrDefault();
            var firstDetailRowAddress = workSheet.Row(_postedData.DetailLineNumber).FirstCell().Address;
            var lastDetailRowAddress = workSheet.LastCellUsed().Address;
            var detailTableRange = workSheet.Range(firstDetailRowAddress, lastDetailRowAddress).RangeUsed();
            var detailTable = detailTableRange.AsTable().AsNativeDataTable();

            var _jsonSettings = new JsonSerializerSettings();
            _jsonSettings.DateFormatString = "MM/dd/yyyy hh:mm:ss tt";
            return JsonConvert.SerializeObject(detailTable, _jsonSettings);

Reproduce - Upload excel with column with cellFormat as Number with 0 decimal places.

[igitur]

Give me code that I can run, please.