Excel数据网格指数问题

本文关键字：指数问题网格数据网数据 Excel | 更新日期: 2023-09-27 18:04:38

我使用以下代码在数据网格中显示excel文件，问题是，大数以指数形式显示，即1236548965132160在网格中显示为1.23654896513216E+15，

string xlsxString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=myFile.xlsx;Extended Properties='"Excel 12.0 Xml;HDR=YES;IMEX=1'"";
OleDbConnection excelOleDBConnection = new OleDbConnection(xlsxString);
excelOleDBConnection.Open();
OleDbDataAdapter dataAdapterForExcelFile = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", excelOleDBConnection);
DataTable dataTableForTheAdapter = new DataTable();
dataAdapterForExcelFile.Fill(dataTableForTheAdapter);
this.dataGridView1.DataSource = dataTableForTheAdapter.DefaultView;

我需要从代码中删除这个指数形式，而不是excel，请建议。

Excel数据网格指数问题

两个选项:

DataTable dataTableForTheAdapter = new DataTable();
dataAdapterForExcelFile.FillSchema(dataTableForTheAdapter, SchemaType.Source);
for(int i = 0; i < dataTableForTheAdapter.Columns.Count; i++)
   if (dataTableForTheAdapter.Columns[i].DataType == typeof(double))
      dataTableForTheAdapter.Columns[i].DataType = typeof(decimal);
dataAdapterForExcelFile.Fill(dataTableForTheAdapter);

或:

     this.dataGridView1.DataSource = dataTableForTheAdapter.DefaultView;
     for (int i = 0; i < this.dataGridView1.Columns.Count; i++)
     {
        if (this.dataGridView1.Columns[i].ValueType == typeof(double))
           this.dataGridView1.Columns[i].DefaultCellStyle.Format = "N";
     }