最近要做一个Excel在C#winform中的导入导出,经过两天时间(本人菜鸟一只刚接触C#)终于做好了,现在与大家分享下
public partial class Form1 : Form
{
//private SerialPort sp;
private DataTable dt;
public Form1()
{
InitializeComponent();
}
public void ImportExcel(string excelName,string tableName){
string strcon = "Provider=Microsoft.Ace.OLEDB.12.0;Data Source=" + excelName + ";Extended Properties='Excel 12.0;HDR=Yes;IMEX=1'";//连接excel文件的字符串
if (excelName == null)
{
return;
}
OleDbConnection con = new OleDbConnection(strcon);//建立连接
con.Open();//打开连接
OleDbDataAdapter oda = new OleDbDataAdapter("select * from" + tableName, con);
DataSet ds = new DataSet();
try
{
oda.Fill(ds,"Sheet1");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
if (ds != null)