尝试将数据保存到Excel文件时出错 [英] Error While trying to save data to excel file

问题描述

我创建了一个简单的Windows窗体应用程序，我创建了一个excel文件来存储和检索数据。但在保存数据的同时，我收到了一条错误消息...



Mycode：

  private   void  button3_Click（ object  sender，EventArgs e） 
 {
 尝试 
 {
 OleDbCommand cmd =  new  OleDbCommand（）; 
  string  query =  null ; 
 connect =  new  OleDbConnection（  provider = Microsoft.Jet.OLEDB.4.0;数据源='c：\\ mydemo.xlsx';扩展属性= Excel 8.0;）; 
 connect.Open（）; 
 cmd.Connection = connect; 
 query =  插入[Sheet1 $]（software_name，versions，keys）值（' + txtSNmae.Text +  '，' + txtVersion.Text +  '，' + txtKey.Text +  '）; 
 cmd.CommandText = query; 
 cmd.ExecuteNonQuery（）; 
 connect.Close（）; 
} 
  catch （Exception ex）
 {
 MessageBox.Show（ex.ToString（））; 
} 
} 
 
 
} 
} 

请帮助....

解决方案

（software_name，versions，keys）值（' + txtSNmae.Text + '，' + txtVersion.Text + '，' + txtKey.Text + '）;
cmd.CommandText = query;
cmd.ExecuteNonQuery（）;
connect.Close（）;
}
catch （Exception ex）
{
MessageBox.Show（ex.ToString（））;
}
}


}
}

请帮助....

我的猜测：

连接字符串错误！正确的连接字符串 [ ^ ]对于 * xlsx 文件是：

 connect =  new  OleDbConnection（ @  Provider = Microsoft.ACE.OLEDB.12.0;数据源= c：\ mydemo.xlsx;扩展属性='Excel 12.0; HDR = YES';）; 

如需了解更多信息，请参阅：

从.NET应用程序访问Microsoft Office数据 [ ^ ]

I have created a simple windows form application where i have created an excel file to store and retrieve data from. But while saving the data I am getting an erorr message...

Mycode:

        private void button3_Click(object sender, EventArgs e)
        {
            try
            {
                OleDbCommand cmd = new OleDbCommand();
                string query = null;
                connect = new OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0; Data Source='c:\\mydemo.xlsx';Extended properties=Excel 8.0;");
                connect.Open();
                cmd.Connection = connect;
                query = "Insert into [Sheet1$] (software_name,versions,keys) values('" + txtSNmae.Text + "','" + txtVersion.Text + "','" + txtKey.Text + "')";
                cmd.CommandText = query;
                cmd.ExecuteNonQuery();
                connect.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }

        
    }
}

Please Help....

解决方案

(software_name,versions,keys) values('" + txtSNmae.Text + "','" + txtVersion.Text + "','" + txtKey.Text + "')"; cmd.CommandText = query; cmd.ExecuteNonQuery(); connect.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } } }

Please Help....

My guess:
The connection string is wrong! Proper connection string[^] for *xlsx files is:

connect = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0; Data Source=c:\mydemo.xlsx;Extended properties='Excel 12.0;HDR=YES';");

For further information, please see:
Accessing Microsoft Office Data from .NET Applications[^]

这篇关于尝试将数据保存到Excel文件时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！