Winform导入导出EXCEL

}
MessageBoxEx.Show("数据导入成功！");
}
else
{
MessageBoxEx.Show("请检查你的Excel中是否存在数据");
dt = DbHelperOleDb.Query_dt(sql);
//this.dataGridViewX2.DataSource = dt.DefaultView;
if (dt.Rows.Count > 0)
for (int i = 1; i <= count; i++)
{
names[i - 1] = ((Microsoft.Office.Interop.Excel.Worksheet)wb.Worksheets[i]).Name;
string sql = "select * from [Excel 8.0;HDR=Yes;IMEX=1;database=" + txtFilesUrl.Text + "].[Sheet1$] ";
System.Data.DataTable dt = new System.Data.DataTable();
{
OpenFileDialog openFileDialog1 = new OpenFileDialog();
openFileDialog1.InitialDirectory = "c:\\";
openFileDialog1.Filter = "Excel Files(2007以上) (*.xlsx)|*.xlsx|Excel Files(2000-2003) (*.xls)|*.xls";
try
{
string filename = txtFilesUrl.Text;
//string sql = "insert into main_body select * from [Excel 8.0;HDR=Yes;IMEX=1;database=" + txtFilesUrl.Text + "].[Sheet1$] ";
+ "','" + dt.Rows[i]["职位层次"].ToString()
+ "','" + dt.Rows[i]["工作单位及职务"].ToString() + "','" + dt.Rows[i]["技术职务"].ToString()
if (openFileDialog1.ShowDialog() == DialogResult.OK)
{
this.txtFilesUrl.Text = openFileDialog1.FileName;
this.btnSelectFile.Enabled = false;
}
return names;
}
/// <summary>
/// 开始导入
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnImport_Click(object sender, EventArgs e)
{
if (txtFilesUrl.Text.Length == 0)
{
MessageBoxEx.Show("请选择导入数据的Execl文件");
}
else
{
OleDbConnection conExcel = new OleDbConnection();
/// <param name="sender"></param>
/// <param name="e"></param>
Microsoft.Office.Interop.Excel.Workbook wb = wbs.Open(filePath, Type.Missing, Type.Missห้องสมุดไป่ตู้ng, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
{
for (int i = 0; i < dt.Rows.Count; i++)
{
//写入数据库数据
{
conExcel.Close();
}
}
}
/// <summary>
/// //导出到execl
/// </summary>
this.txtFilesUrl.ReadOnly = true;
}
}
/// <summary>
/// 获得当前所选择的Excel Sheet的所有名字
/// </summary>
/// <param name="filePath"></param>
/// <returns></returns>
public static string[] GetExcelSheetNames(string filePath)
{
}
//OleDbCommand com = new OleDbCommand(sql, conExcel);
//conExcel.Open();
//com.ExecuteNonQuery();
//DbHelperOleDb.ExecuteSql(sql);
//MessageBoxEx.Show("导入数据成功", "导入数据", MessageBoxButtons.OK, rmation);
+ "','" + dt.Rows[i]["考官类别"].ToString()
+ "')";
DbHelperOleDb.ExecuteSql(MySql);
string MySql = "insert into Main_Body values(" + DbHelperOleDb.GetMaxID("oae001", "main_body") + ",'" + dt.Rows[i]["姓名"].ToString() + "','" + dt.Rows[i]["性别"].ToString()
/// <summary>
/// 选择文件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSelectFile_Click(object sender, EventArgs e)
Microsoft.Office.Interop.Excel.ApplicationClass excelApp = new ApplicationClass();
Microsoft.Office.Interop.Excel.Workbooks wbs = excelApp.Workbooks;
this.txtFilesUrl.Text = "";
this.txtFilesUrl.ReadOnly = false;
this.btnSelectFile.Enabled = true;
openFileDialog1.FilterIndex = 2;
openFileDialog1.RestoreDirectory = true;
//openFileDialog1.CreatePrompt = true;
openFileDialog1.Title = "导入文件路径";
}
catch (Exception ex)
{
MessageBoxEx.Show(ex.ToString());
}
finally
Type.Missing, Type.Missing, Type.Missing, Type.Missing);
int count = wb.Worksheets.Count;
string[] names = new string[count];
+ "','" + dt.Rows[i]["移动电话"].ToString()
+ "','" + dt.Rows[i]["办公电话"].ToString()