使用openxml从excel中读取时获取浮点数而不是精确字符串

我只想把它读成字符串里的样子。所以这个应该是7.5,而不是7.499或者其他东西。 任何帮助都将不胜感激。 这是我在datatable中读取Excel的代码

private static string ConvertFileToDataTable(Stream fileStream, DataTable framworkDatatable, List<FileErrorModel> fileErrorModels)
    {
        string frameworkName;

        InitializeDataTable(framworkDatatable);

        using (var document = SpreadsheetDocument.Open(fileStream, true))
        {
            var workbookPart = document.WorkbookPart;

            var mysheet = (Sheet)document.WorkbookPart.Workbook.Sheets.ChildElements.GetItem(0);

            frameworkName = mysheet.Name;

            var worksheet = ((WorksheetPart)workbookPart.GetPartById(mysheet.Id)).Worksheet;

            var sheetData = (SheetData)worksheet.ChildElements.GetItem(4);

            foreach (var row in sheetData.Descendants<Row>())
            {
                if (row == null) continue;
                if (row.RowIndex.Value == Constants.ColumnNameRowIndex)
                {
                    if (row.Descendants<Cell>().Count() > Constants.ValidColumnCount || row.Descendants<Cell>().Count() < Constants.ValidColumnCount)
                    {
                        var error = new FileErrorModel
                        {
                            ErrorText = ValidationMessages.IncompatibleCoulmns,
                            RowNumber = null,
                            ColumnNumber = null
                        };
                        fileErrorModels.Add(error);
                    }
                }

                if (row.RowIndex.Value == Constants.TableNameRowIndex ||
                    row.RowIndex.Value == Constants.ColumnNameRowIndex) continue;

                framworkDatatable.Rows.Add();
                var i = 0;

                foreach (var cell in row.Descendants<Cell>())
                {
                    framworkDatatable.Rows[framworkDatatable.Rows.Count - 1][i] = GetCellValue(document, cell);
                    i++;
                }
            }
        }
        return frameworkName;
    }

这就是我初始化数据表的方法

private static void InitializeDataTable(DataTable framworkDatatable)
    {
        framworkDatatable.Columns.AddRange(new[] {
                new DataColumn(ImportSheetColumnNames.ControlFamilyIdentifier, typeof(string)),
                new DataColumn(ImportSheetColumnNames.ControlFamilyShortName, typeof(string)),
                new DataColumn(ImportSheetColumnNames.ControlFamilyDescription,typeof(string)),
                new DataColumn(ImportSheetColumnNames.ControlIdentifier,typeof(string)),
                new DataColumn(ImportSheetColumnNames.ControlType,typeof(string)),
                new DataColumn(ImportSheetColumnNames.ControlDescription,typeof(string)),
                new DataColumn(ImportSheetColumnNames.TestProcedure,typeof(string)),
                new DataColumn(ImportSheetColumnNames.BestPractice,typeof(string)),
                new DataColumn(ImportSheetColumnNames.Help,typeof(string)),
                new DataColumn(ImportSheetColumnNames.ActionPlan,typeof(string)),
                new DataColumn(ImportSheetColumnNames.Question,typeof(string))
        });
    }

忽略“ImportSheetColumnNames”,它们只是常量列名