C#中excel的导出和导入.docVIP

C#将SQL数据库中数据导入Excel中，并将Excel中反导入SQL数据库中 实际的开发中，我们会经常遇到数据的转化的需要，将Excel中的数据转入到SQL中，或将SQL在数据库表中的数据导入到Excel中。代码如下： Codeusing?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)????????{????????????using?(OpenFileDialog?dialog?=?new?OpenF