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,                Missing.Value,

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

                Missing.Value,                Missing.Value);

           

[1] [2] [3] [4] [5] [6] [7] 下一页

复制本页网址和标题，发送给你QQ/Msn的好友一起分享

上一篇:最详细的SQL注入相关的命令整理

下一篇:怎样将Excel中的数据导入到SQLServer2000数据库中