使用科学记数法将数据从datagridview导出到csv

using System;
using System.IO;
using System.Text;
using System.Windows.Forms;

public static class DataGridViewExporter
{
    public static void ExportToCsv(DataGridView dataGridView, string filePath)
    {
        StringBuilder csvContent = new StringBuilder();

        // 遍历每一行
        foreach (DataGridViewRow row in dataGridView.Rows)
        {
            // 遍历每一列
            foreach (DataGridViewCell cell in row.Cells)
            {
                // 判断单元格的值是否为数值类型
                if (cell.Value != null && cell.Value is IConvertible && IsNumericType(cell.Value.GetType()))
                {
                    // 将数值转换为科学记数法表示的字符串
                    string scientificNotation = Convert.ToDouble(cell.Value).ToString("0.###E+0");
                    csvContent.Append(scientificNotation);
                }
                else
                {
                    // 保持原始值不变
                    csvContent.Append(cell.Value);
                }

                csvContent.Append(",");
            }

            csvContent.AppendLine();
        }

        // 将拼接好的字符串写入CSV文件
        File.WriteAllText(filePath, csvContent.ToString());
    }

    private static bool IsNumericType(Type type)
    {
        return type == typeof(byte) ||
               type == typeof(sbyte) ||
               type == typeof(short) ||
               type == typeof(ushort) ||
               type == typeof(int) ||
               type == typeof(uint) ||
               type == typeof(long) ||
               type == typeof(ulong) ||
               type == typeof(float) ||
               type == typeof(double) ||
               type == typeof(decimal);
    }
}

// 假设存在一个名为dataGridView的DataGridView控件
string filePath = "output.csv";
DataGridViewExporter.ExportToCsv(dataGridView, filePath);