改进上一篇读取EXCEL的数据到datagridview（增加导出Excel功能）

最新推荐文章于 2020-11-17 15:03:49 发布

weixin_30955617

最新推荐文章于 2020-11-17 15:03:49 发布

阅读量61

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/shineqiujuan/archive/2008/10/16/1312527.html

本文介绍了一个使用C#实现的简单应用程序，该程序可以导入Excel文件中的数据到DataGridView，并将DataGridView中的数据导出到新的Excel文件。涉及的技术包括使用OLE DB连接Excel文件、读取特定工作表的数据以及使用StreamWriter将数据写入新文件。

Code
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Web;
using System.IO;

namespace WindowsApplication1
{
public partial class Form2 : Form
    {
public Form2()
        {
            InitializeComponent();
        }

private void button1_Click(object sender, EventArgs e)
        {
this.openFileDialog1.ShowDialog();
this.textBox1.Text = this.openFileDialog1.FileName;
        }

private void button2_Click(object sender, EventArgs e)
        {
string fileName = "";
           fileName = this.textBox1.Text;
if (this.textBox1.Text != "")
           {
try
               {
string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = " + fileName + " ;Extended Properties=Excel 8.0";
                   System.Data.OleDb.OleDbConnection myConn = new System.Data.OleDb.OleDbConnection(strCon);
string strCom = " SELECT * FROM [punishCase$] ";
                   System.Data.OleDb.OleDbDataAdapter myCommand = new System.Data.OleDb.OleDbDataAdapter(strCom, myConn);
                   System.Data.DataTable dt = new System.Data.DataTable();
                   myCommand.Fill(dt);
this.dataGridView1.DataSource = dt;
this.label1.Text = myConn.State.ToString();
                   MessageBox.Show("导入成功");

               }
catch
               {
                   MessageBox.Show("请选择案件导入的EXCEL");

               }



           }
else
           {
               MessageBox.Show("请选择Excel文件");
           }



        }

private void button3_Click(object sender, EventArgs e)
        {
            SaveFileDialog saveFileDialog = new SaveFileDialog();

            saveFileDialog.Filter = "Execl files (*.xls)|*.xls";

            saveFileDialog.FilterIndex = 0;

            saveFileDialog.RestoreDirectory = true;

            saveFileDialog.CreatePrompt = true;

            saveFileDialog.Title = "Export Excel File To"; 


            saveFileDialog.ShowDialog();


            Stream myStream;

            myStream = saveFileDialog.OpenFile();

//StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding("gb2312"));

            StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding(-0));

string str = "";

try

            {

//写标题

for (int i = 0; i < dataGridView1.ColumnCount; i++)

                {

if (i > 0)

                    {

                        str += "\t";

                    }

                    str += dataGridView1.Columns[i].HeaderText;

                }


                sw.WriteLine(str);



//写内容

for (int j = 0; j < dataGridView1.Rows.Count; j++)

                {

string tempStr = "";

for (int k = 0; k < dataGridView1.Columns.Count; k++)

                    {

if (k > 0)

                        {

                            tempStr += "\t";

                        }

                        tempStr += dataGridView1.Rows[j].Cells[k].Value.ToString();

                    }



                    sw.WriteLine(tempStr);                    

                }

                sw.Close();

                myStream.Close();

            }

catch

            {



            }

finally

            {

                sw.Close();

                myStream.Close();

            }           

      }



    }
}