//引用
using System.Windows.Forms;
using System.Data.OleDb;
SaveFileDialog sfd = new SaveFileDialog();
sfd.Filter = "Excel file(*.xls)|*.xls";
sfd.Title = CliUtils.GetMessage("exporttitle");
sfd.AddExtension = true;
if (sfd.ShowDialog() == DialogResult.OK)
{
ExportExcel(sfd.FileName);
}
private void ExportExcel(string path)
{
//根据模板导出
string _fileName = string.Format(@"{0}\{1}", Application.StartupPath, "ImportTemplate.xls");
if (!File.Exists(_fileName))
{
MessageBox.Show("客户端找不到导出模板文件");
return;
}
try
{
File.Copy(_fileName, path, true);
}
catch
{
MessageBox.Show(CliUtils.GetMessage("exportuse"));
return;
}
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";Extended Properties='Excel 8.0;'";//IMEX=1
OleDbConnection OleConn = new OleDbConnection(strConn);
OleConn.Open();
OleDbCommand comm;
int count = 0;
try
{
for (int i = 0; i < dataSet1.Tables[1].Rows.Count; i++)
{
string sql = string.Format(" Insert into [Sheet1$] values ('{0}',{1}) ", new object[]{
dataSet1.Tables[1].Rows[i]["value"],dataSet1.Tables[1].Rows[i]["qty"]});
comm = new OleDbCommand(sql, OleConn);
comm.ExecuteNonQuery();
count++;
}
}
catch
{
MessageBox.Show("文件正在被使用");
return;
}
finally
{
OleConn.Close();
}
if (count > 0)
{
this.Close();
}
}
C#winForm导出excel
最新推荐文章于 2024-09-10 14:09:51 发布