C#源码读取excel数据到程序中-SQL SERVER-到dataset中

一、将Excel数据只读到程序中显示：

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using Microsoft.Office.Interop.Excel;
using System.Reflection;

namespace ExcelDemo
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();

}

        private void button1_Click(object sender, EventArgs e)
        {
            Microsoft.Office.Interop.Excel.ApplicationClass app = new ApplicationClass();
            app.Visible = false;

            WorkbookClass w = (WorkbookClass)app.Workbooks.Open(@"C:\Documents and Settings\qqq\桌面\002.xls", //Environment.CurrentDirectory+
                Missing.Value,                Missing.Value,                Missing.Value,

Missing.Value, Missing.Value, Missing.Value,

Missing.Value, Missing.Value);

            object missing = Type.Missing;
            Sheets sheets = w.Worksheets;
            Worksheet datasheet = null;
            foreach (Worksheet sheet in sheets)
            {
                if (sheet.Name == "Recovered_Sheet1")
                {
                    datasheet = sheet;
                    break;
                }
            }
            if (null == datasheet)
            {
                MessageBox.Show(this, "没有名称为 Recovered_Sheet1 的Sheet.");
                return;
            }

            Range range = datasheet.get_Range("A8","N35");

            System.Array values = (System.Array)range.Formula;
            if (values != null)
            {
                int len1 = values.GetLength(0);
                int len2 = values.GetLength(1);

                for (int i = 1; i <= len1; i++)
                {
                    this.textBox1.Text += "\r\n";
                    for (int j = 1; j <= len2; j++)
                    {
                        if (values.GetValue(i, j).ToString().Length == 0)
                            this.textBox1.Text += "\t\t";
                        this.textBox1.Text += "\t" + values.GetValue(i, j).ToString();
                    }
                }
            }

            app.Quit();
            app = null;
        }
    }
}

二、读取到dataset中/从dataset中写入sql server：

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

        /// <summary>
        /// 读取Excel文档
        /// </summary>
        /// <param name="Path">文件名称</param>
        /// <returns>返回一个数据集</returns>
        public DataSet ExcelToDS(string Path)
        {
            string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Path + ";" + "Extended Properties=Excel 8.0;";
            OleDbConnection conn = new OleDbConnection(strConn);
            conn.Open();
            string strExcel = "";
            OleDbDataAdapter myCommand = null;
            DataSet ds = null;
            strExcel = "select * from [Recovered_Sheet1$]";
            myCommand = new OleDbDataAdapter(strExcel, strConn);
            ds = new DataSet();
            myCommand.Fill(ds);
            return ds;
        }

        /// <summary>
        /// 写入Excel文档
        /// </summary>
        /// <param name="Path">文件名称</param>
        //public bool SaveFP2toExcel(string Path)
&nb

[1] [2] 下一页