导出Excle.docVIP

C#将SQL数据库中数据导入Excel中，并将Excel中反导入SQL数据库中 文章录入：7747.Net 责任编辑：7747.Net 234 【字体：小 大】 实际的开发中，我们会经常遇到数据的转化的需要，将Excel中的数据转入到SQL中，或将SQL在数据库表中的数据导入到Excel中。代码如下： using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using GemBox.ExcelLite; using System.Data.SqlClient; using System.Data.OleDb; using System.Collections; using System.IO; namespace Encryption { public partial class ExcelDemo : Form { private static string _filePath = string.Empty; public ExcelDemo() { InitializeComponent(); BindUser(); } /// summary /// 绑定数据 /// /summary private void BindUser() { string sql = select * from Users; DataTable dt = DbHelperSQL.QueryTb(sql); dataGridView1.DataSource = dt; } /// summary /// 将Users表中的数据导入Excel中 /// /summary private void btnExcelin_Click(object sender, EventArgs e) { ExcelFile excelFile = new ExcelFile(); ExcelWorksheet sheet = excelFile.Worksheets.Add(Users); int columns = dataGridView1.Columns.Count; int rows = dataGridView1.Rows.Count; for (int j = 0; j columns; j++) { sheet.Cells[0, j].Value = dataGridView1.Columns[j].HeaderText; } for (int i = 1; i rows; i++) { for (int j = 0; j columns; j++) { sheet.Cells[i, j].Value = dataGridView1[j, i - 1].Value.ToString().Trim(); } } excelFile.SaveXls(./Users.xls); MessageBox.Show(生成成功); } /// summary /// 选择要向SQL数据库中导入数据的Excel文件 /// /summary private void btnChoose_Click(object sender, EventArgs e) {